When upgrading the SAP system with Software Update Manager (SUM), during the configuration step PREP_INSTALL/SHDINST_DB_PREP, you get the following errors:
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!
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.
- SAP Systems based on SAP NetWeaver;
- Microsoft SQL Server 2005 and higher;
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 pageThis 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.