BW NW 7.0 SPs 21 to Upgrade to EHP2 SPs09 -- Post Upgrade Issues

[Former Member]

Hi,

Hi All,

Recently we upgraded our BW Sandbox system from BW NW 7.0 SPs 21 to EHP2 SPs09

The BW team is now doing a few post upgrade checks and they are getting this error

"Database error 4701 at EXE"

> [Microsoft][SQL Native Client][SQL Server]Cannot find the

> object "/BI0/0200000009" because it does not exist or you do

> not have permissions.

The object does exist in the system and even there is no permission level problem.

They executed RSRV and there were no errors found.

Please help & suggest

Thanks,

Sameer

[Former Member]

This seems to be a temporary object, i recommend reading sap note [1139396 - Temporary database objects in BW 7.X|https://service.sap.com/sap/support/notes/1139396]

Most probably the execution of the SAP_DROP_TMPTABLES will do the clean up for you.

Cheers Michael

[Former Member]

Hello Sameer,

Please make sure this object is active in DB from SE11. Object must be active in both data dictionary and database.

Thanks,

Siva Kumar