Skip to Content
Former Member
May 27, 2008 at 07:42 PM

BI Upgrade - Change logs not linked to ODS objects


BI Gurus,

We are in the process of Upgrading BW from 3.X to BI 7. As part of this we copied our existing Production system into the sand box and basis did the technical upgrade on the same (Sand Box). Later we ran some post upgrade Jobs as part of the SAP defined Upgrade Process.

1) But after the upgrade I notice that most of the ODS objects do not have a 'Change Log' table in the 'Information (Log/Status)' screen.

2) Even when I try to view the change log content in Manage screen, it gives me a pop up to enter the change log table, instead of taking me directly to the selection screen.

3) When I try to activate a request, even that fails with an SQL error 'SAPSQL_EMPTY_TABNAME'.

Also, we are at SP level 16.

Is there any process that has to be run to link the Older version change log tables to the corresponding ODSs after Upgrade?

Has anyone come accross similar issues? If yes, how was it solved? All suggestions are welcomed.


Michael T. Smith

Ashland Inc.