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.
SAP Knowledge Base Article - Preview