SAP Knowledge Base Article - Preview

2169201 - GRANT-SHADOW-PRIVILEGES: Cannot find the object <xxx> when using MSSQL database

Symptom

GRANT-SHADOW-PRIVILEGES phase fails with the following error message:

"Could not complete DMT process. Check the DMT.GRANT_PRIVILEGES.LOG log file.

You can find more information in the files <SUM_DIR>\sdt\log\SWITCH\GRANT-SHADOW-PRIVILEGES_<NR>.LOG and ProcessOverview.html."

In file DMT.GRANT_PRIVILEGES_01_<NR>.ERR there are entries like the following:

SQL Exception code 15151: Cannot find the object 'SHD_COMPVERS', because it does not exist or you do not have permission. 
OpenSQLExceptionCategories: [] com.sap.sql.exception.OpenSQLException: Cannot find the object 'SHD_COMPVERS', because it does not exist or you do not have permission.
OpenSQLExceptionCategories: [] com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object 'SHD_COMPVERS', because it does not exist or you do not have permission.

Also, MS SQL Server SAP<SID>DB schema is empty and all SAP tables belongs to dbo user (dbo.*).


Read more...

Environment

  • Windows Server
  • MS SQL Server Database

Product

SAP NetWeaver all versions

Keywords

KBA , BC-UPG-TLS-TLJ , Upgrade tools for Java , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.