Data Mart problem between ODS and Cube
Hi BW Gurus,
I have a problem with the population of our Cube from an ODS. I recently run a Repeat Load for an ODS. The Delta load consists of uploading data from R3 to ODS then ODS to Cube. The Repeat Load for ODS went fine, several thousands of records were uploaded. However, when updating the ODS data to the Cube it encountered an error. Checking RSMO, for datasource 8ODS1, the error is in "Processing (data packet)" section. The error is "Object requested locked by user ALEREMOTE". ALEREMOTE is the background userid we use to communicate between source system and bw. I already checked SM12 for that user and found no locked objects. How can I do a Repeat load from ODS to CUBE? I tried to mark the load "Red" in the Cube and do a Repeat load from the 8ODS1 Datasource. However, it doesnt prompt me for a Repeat load?
Would really appreciate reply and reward points.