EM reporting DB is not available

Products

• APP PERF MANAGEMENT
• CA Application Performance Management Agent (APM / Wily / Introscope)
• CUSTOMER EXPERIENCE MANAGER
• INTROSCOPE

Issue/Introduction

Getting repeated errors in EM log stating that the DB is not avavilable

1/24/19 02:21:37.296 PM GMT [ERROR] [Thread-41] [Manager.AppMap] org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from aca_acl]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "aca_acl" does not exist Position: 15 ..... Caused by: org.postgresql.util.PSQLException: ERROR: relation "aca_acl" does not exist Position: 15
......
1/24/19 02:21:37.297 PM GMT [INFO] [Thread-41] [Manager.AppMap] DB is not available. Next attempt to retry to connect in 15 seconds.

Cause

The message in this case is not entirely correct as the database is available but the syetem is interpretting the fact that a DB related function is failing as an DB down situation. Other DB activities were proceeding correctly.

The key in this case is the message ERROR: relation "aca_acl" does not exist - this indicates a missing table in the database





 

Environment

APM 10.7 with Postgres DB

Resolution

Use the following SQL to identfy the tables present

SELECT tablename FROM pg_catalog.pg_tables where tableowner='admin' order by tablename;
tablename

Provide the result to support who will provide required SQL to recreate missing tables