Regarding delta load from one ODS to another ODS(very urgent)

[Former Member]

Hi BW gurus,

I have a query like while loading delta load from one ODS to another ODS , we are getting error like

ODS object YRV_O01 was built incorrectly. Cannot update request

REQU_DQZEAH1QZKNYTJ9RN2I8IBY3K(1,012,023).

Here source ODS is YSV_O07 and target is YRV_O01

please give your valuable solutions. It is very urgent.

Regards,

Gowri.

[surya_prasad9 · Accepted solution]

Hi Gowri,

Your ODS is getting Delta updates, in between your delta requests you did a Full Update load REQU_DQZEAH1QZKNYTJ9RN2I8IBY3K(1,012,023).

So its not allowing you to activate the ODS.

Delete the above request from the ODS, if you want to do full update between delta updates use the "Repair Full Update" option, you won't get the above error,

Please let me know if you still have the same issue,

Kindest Regards,

Surya.

[Former Member]

Hi Gowri,

Most of the times this problem happens due to issues in delta queue and change log. To resolve you may try deleting the data and doing a reinit.

Bye

Dinesh

[Former Member]

Hi Gowri,

Check this thread:

Also check OSS Note 689964

Bye

Dinesh