Symptom
In Strategy One users may notice that newly created objects have a blank value for object_location in the lu_object table in the Platform Analytics warehouse as seen in the image below:
Users may also notice that this is only seen for objects created within the last day. Older objects have the correct value for object location.
This behavior is seen because the object_location column is only populated when the daily_etl procedure in the Platform Analytics warehouse runs. Other columns in lu_object are populated when the new object is created in the metadata, but object_location is not. When daily_etl runs the object_location for the object is resolved from the list of folders in the etl_lu_folder table and then the parent folder of the object is inserted into the object_location column for the object in question.
Action
If users see that the location for newly created objects is blank, they should wait until the daily_etl runs and afterwords the object will have the correct value for object_location. By default the daily_etl runs at 5:02 UTC every day.
