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 the 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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.