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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.