EM reporting DB is not available

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