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:
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 , 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 for Me (Login required).

Search for additional results

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