SAP Knowledge Base Article - Preview

2259379 - Database error 297 in System Log

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

SAP Solution Manager 7.1

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.