SAP Knowledge Base Article - Preview

2812638 - SELECT permission was denied on the object 'objects', database 'mssqlsystemresource', schema 'sys'.

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

SAP ERP 6.0

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.