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.