I have an ODS and subsequent Cube. I am able to load to the ODS successfully, but when trying to go to the Cube, it runs forever with only 506 records and finally fails. I've checked the Update Rules and there is nothing as far as code goes that is inefficient. And I have checked the Update and Transfer Rules and everything is active.
I get the following error message:
RSM 1523
Cannot update request in data target
Diagnosis
System checks show that the request cannot be updated to a data target.
The system checked whether:
request is already in the data target (it isn't)
the data target has active update rules for the InfoSource (it does)
the data target was selected for updating (it was)
locks exist
for a DataSource object as a data target, that the request was updated in the correct order (it was the only request)
Procedure
Often there are remaining elements from the request in the data target or links to previous update ( I deleted all the data and when it asked about data tied to dimensions, I said to delete it)
thanks, Keith J