EM reporting DB is not available

Document ID : KB000125670
Last Modified Date : 01/02/2019
Show Technical Document Details
Issue:
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.
Environment:
APM 10.7 with Postgres DB
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





 
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