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

Search for additional results

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