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