Symptom
When upgrading the SAP system with Software Update Manager (SUM), during the configuration step PREP_INSTALL/SHDINST_DB_PREP, below error is thrown:
Checks after phase PREP_INSTALL/SHDINST_DB_PREP were negative!
Last error code set: Process E:\usr\sap\ED8\SUM\abap\bin/SAPuptool exited with 20, see 'C:\usr\sap\<SID>\SUM\abap\log\SQLSTMTSTD.OUT' for details.
The results in the file SQLSTMTSTD.OUT shows:
FATAL ERROR: DBSL error 99 (db code 15151):
Cannot alter the role 'db_ddladmin', because it does not exist or you do not have permission.
SAPup> Process with PID 9652 terminated with status 20 at 20160511195920!
Or:
Cannot alter the role 'db_owner', because it does not exist or you do not have permission.
This may also fail with other commands like sp_grantdbaccess, sp_addrolemember, etc.
Read more...
Environment
- SAP Systems based on SAP NetWeaver;
- Microsoft SQL Server 2005 and higher;
Product
Keywords
upgradation, upgrade, upgrading, error, sum stop, sum stop after, during upgradation, during upgrade, while upgrading, can't alter role, ddl_admin, SHDINST_DB_PREP, shadow instance, shadow database, PREP_INSTALL, prep install, shdinst db prep, msql, mssql, ms_sql, microsoft sql server, sidadm, <sid>adm, <sapsid>adm, sapsid, shd_sid, shd_<sid>, shd_<sapsid>, sp_grantdbaccess, sp_addrolemember, authorization, permission, roles, db_owner, , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BC-UPG-TLS-TLA , Upgrade tools for ABAP , BC-DB-MSS-UPG , SQL Server Upgrades 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