Symptom
In your Solution Manager system, you observe in the System Log (SM21 transaction) the following errors:
15:49:37 DIA 001 100 SM_EFWK BY 2 Database error 297 at OPC
15:49:37 DIA 001 100 SM_EFWK BY 0 > The user does not have permission to perform this action.
15:49:37 DIA 001 100 SM_EFWK BY 1 Database error 297
15:56:31 DIA 026 100 SM_EFWK BY 2 Database error 297 at OPC
15:56:31 DIA 026 100 SM_EFWK BY 0 > The user does not have permission to perform this action.
15:56:31 DIA 026 100 SM_EFWK BY 1 Database error 297
Further checking the developer traces (dev_XX files) you discover the cause of the errors are coming from remote monitored system:
B Connect to DBTESTMON as DBM_SAPMonitor with OBJECT_SOURCE=SAPMonitor MSSQL_DBNAME=DBM MSSQL_SERVER=DBTESTSERVER
C dbdsmss: DBSL99 SQL297
C The user does not have permission to perform this action.
B ***LOG BY2=> sql error 297 performing OPC [dbds 398]
B ***LOG BY0=> The user does not have permission to perform thisaction. [dbds 398]
B ***LOG BY1=> sql error 297 [dbacds 1843]
To not be confused with the symptoms described in SAP Note 1849350.
Read more...
Environment
- SAP Solution Manager 7.1;
- MS SQL Server 2005 and higher;
- Windows Server 2003 and higher;
Product
Keywords
missing permissions, missing grants, error297, sqlerror297, SolMan, sapmon, SM21 , 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.