Skip to Content
0
Former Member
May 28, 2008 at 02:05 PM

Load from ODS to InfoProvider

39 Views

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