1840919 - SAP Solution Manager system log (SM21) shows database connection error

Symptom

When a Managed System goes down for a regularly scheduled offline backup, or if the monitored system/database is completely deactivated, many errors might show up in the system logs (transaction code SM21) of the SAP Solution Manager.

For example:

01:10:34 DIA 010 200 SOLMAN_BTC    BY 2 Database error 12154 at CON
01:10:34 DIA 010 200 SOLMAN_BTC    BY 0 > con=2(databasehost:41521/SOL): ORA-12154: TNS:could not resolve
01:10:34 DIA 010 200 SOLMAN_BTC    BY 0 > the connect identifier specified

07:09:54 DIA 059 100 SM_EFWK BY 2 Database error 12170 at CON
07:09:54 DIA 059 100 SM_EFWK BY 0 > con=2 (dbhostname:1595/SID): ORA-12170: TNS:Connect timeout
07:09:54 DIA 059 100 SM_EFWK BY 0 > occurred
07:09:54 DIA 059 100 SM_EFWK BY 1 Database error 12170

For other database types, the database error code might be different.

E.g. Database error -10709 at CON.

Environment

SAP Solution Manager 7.10
SAP Solution Manager 7.20

Product

SAP Solution Manager 7.1 ; SAP Solution Manager 7.2

Keywords

database errors in SM21 for SM_EFWK; Oracle, HANA, Database error -10709 at CON, ORA, syslog , KBA , SV-SMG-INS-DIA , Configuration of Root Cause Analysis related infrastructure , SV-SMG-MON-ALR , Monitoring/Alerting/Reporting Infrastructure , SV-SMG-DIA-SRV-EFW , Extractor Framework , 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.