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 , 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.
SAP Knowledge Base Article - Preview