SAP Knowledge Base Article - Preview

2232777 - Database error 229 at OPC in Solution Manager

Symptom

The Solution Manager is monitoring a remote SQL Server database.

In SM21 transaction you can see the following error repeatedly:

229_opc.png

"Database Error 229 at OPC"
"The SELECT permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'.
"Database Error 229"



By following the errors in the SM21, in ST11 it is possible to follow up more details about the errors:

 

229_wp.png

 

In the application server that the error occurred, go to ST11 transaction and open the given dev_wXX file (in this case, you can see it is the dev_w25 file):

 

st11_dev_w_file.png

 

In the developer trace file you can see the following errors:


C  dbdsmss: DBSL99 SQL229

The SELECT permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'.
B  ***LOG BY2=> sql error 229 performing OPC [dbds         398]
B  ***LOG BY0=> The SELECT permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'. [dbds         398]
B  ***LOG BY1=> sql error 229 [dbacds       1843]
B  Connect to E83 as E83_SAPMonitor with OBJECT_SOURCE=SAPMonitor MSSQL_DBNAME=E83 MSSQL_SERVER=WHIPLASH-DB
...
C Mon Oct 19 10:00:17 2015
C  ERROR: -1 in function StartSelect (execute) [line 14752]
C  (229) [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]The SELECT permission was denied on the object 'sysjobs', dat
C  Error 99 (dbcode 229) in StartSelect
C  StartSelect: stmt of NULL_STMTID
 
C  dbdsmss: DBSL99 SQL229
The SELECT permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'.
B  ***LOG BY2=> sql error 229 performing OPC [dbds         398]
B  ***LOG BY0=> The SELECT permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'. [dbds         398]
B  ***LOG BY1=> sql error 229 [dbacds       1843]

OR

C  dbdsmss: DBSL99 SQL229
The SELECT permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'.
B  ***LOG BY2=> sql error 229 performing OPC [dbds         398]
B  ***LOG BY0=> The SELECT permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'. [dbds         398]
B  ***LOG BY1=> sql error 229 [dbacds       1843]
B  Connect to E83 as E83_SAPMonitor with OBJECT_SOURCE=SAPMonitor MSSQL_DBNAME=E83 MSSQL_SERVER=WHIPLASH-DB
...
C Mon Oct 19 10:00:17 2015
C  ERROR: -1 in function StartSelect (execute) [line 14752]
C  (229) [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]The SELECT permission was denied on the object 'sysjobs', dat
C  Error 99 (dbcode 229) in StartSelect
C  StartSelect: stmt of NULL_STMTID
 
C  dbdsmss: DBSL99 SQL229
The SELECT permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'.
B  ***LOG BY2=> sql error 229 performing OPC [dbds         398]
B  ***LOG BY0=> The SELECT permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'. [dbds         398]
B  ***LOG BY1=> sql error 229 [dbacds       1843]


Read more...

Environment

  • SAP Solution Manager 7.1;
  • Windows Server 2003 and higher;
  • MS SQL Server 2005 and higher.

Product

SAP Solution Manager 7.1

Keywords

SELECT PERMISSION DENIED, denied on sysjobs, SOLMAN, solman, datenbank zugriff verweigert, datenbank zugriff , KBA , BC-DB-MSS-CCM , CCMS/Database Monitors for SQL Server , 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.