Symptom
after checking the alerts in transaction DBACOCKPIT, the following errors are logged in the syslog (sm21):
Database error 362 at OPC > invalid schema name: LCAALERTS: line 1 col 15 (at pos 14)
The corresponding WP trace shows:
C SQLCODE : 362 C SQLERRTEXT : invalid schema name: LCAALERTS: line 1 col 15 (at pos 14) C sc_p=7fffd01e0438,no=199,idc_p=(nil),con=0,act=1,slen=33,smax=256,#vars=0,stmt=7ff861f996f0,table= C SELECT * FROM LCAALERTS.LCAALERTS; B ***LOG BY2=> sql error 362 performing OPC [dbds 505] B ***LOG BY0=> invalid schema name: LCAALERTS: line 1 col 15 (at pos 14) [dbds 505]
Read more...
Environment
SAP S/4HANA
Product
Keywords
solman, lcaalerts, livecache, monitoring, dbacockpit, alerts , 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