Symptom
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 <drive>:\usr\sap\<SID>\SUM\abap\bin/SAPuptool exited with 20, see '<drive>:\usr\sap\
<SID>\SUM\abap\log\SQLSTMTSTD.OUT' for details.
The results in the file SQLSTMTSTD.OUT shows:
SQL: ('CREATE SCHEMA <sid>_shd AUTHORIZATION <sid>_shd')
SQL: EXECUTE AS USER = '<sid>_shd' IF EXISTS (select * from sys.objectsError message: DBSL error 99 (db code 229):
SQL: where name = 'sap_check_if_sick' and object_id = object_id('<sid>_shd.'
SQL: + name, 'P') ) drop proc <sid>_shd.sap_check_if_sick
Date & Time: <Date_time>
Error message: DBSL error 99 (db code ERR):
The SELECT permission was denied on the object 'objects', database
'mssqlsystemresource', schema 'sys'.
exit code: "20"
Rollback.
Read more...
Environment
- SAP Systems based on SAP NetWeaver;
- Microsoft SQL Server 2005 and higher;
Product
Keywords
Error 229, db_ddladmin, db_owner, shadow,PREP_INSTALL, SHDINST_DB_PREP, authorization, permission, roles , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , 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.