SAP Knowledge Base Article - Preview

2495861 - HANA: Database error 258 at OPC in SM21 when accessing transaction code: DB02/DBACockpit -> Diagnostics -> Diagnostic Files

Symptom

Executing Transaction code: DB02/DBACockpit -> Diagnostics -> Diagnostic Files results in the following error in the system log (Transaction code: SM21).
However, there are no errors shown in the DBACockpit screen.

Database error 258 at OPC
> insufficient privilege: Not authorized

The related work trace file(dev_w*) which can be clarified in the system log shows the following information:

C  SQLCODE    : 258
C  SQLERRTEXT : insufficient privilege: Not authorized

C  SELECT   FILE_NAME AS FILE_NAME ,
C           FILE_SIZE AS FILE_SIZE ,
C           FILE_MTIME AS FILE_MT\
C  IME
C  FROM     (SELECT   SRC_DUMPS.FILE_MTIME AS FILE_MTIME ,
C                     SRC_DUMPS.FILE_NAME\
C   AS FILE_NAME ,
C                     SRC_DUMPS.FILE_SIZE AS FILE_SIZE
C            FROM     SYS.FULL_SY\
C  STEM_INFO_DUMPS AS SRC_DUMPS ) AS SQ_NO_AGGR ;
B  ***LOG BY2=> sql error 258 performing OPC [dbds         437]
B  ***LOG BY0=> insufficient privilege: Not authorized [dbds         437]


Read more...

Environment

SAP HANA Revision 101 and higher

Keywords

SM21, DB01, DB02, DB03, DB12, ST04, DBACOCKPIT, SYS, FULL_SYSTEM_INFO_DUMPS, SRC_DUMPS, sql error 258, insufficient privilege, Not authorized , KBA , HAN-DB , SAP HANA Database , BC-DB-HDB-CCM , CCMS / Database Monitors for SAP HANA , 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.