Analytics - no history table in Datastore
search cancel

Analytics - no history table in Datastore


Article ID: 145588


Updated On:


CA Automic Workload Automation - Automation Engine


This is an issue on Automic 12.3.1, OS is Linux, DB is PostgreSQL 10 on Windows

Error message:

The analytics Backend server cannot start.

setup.psql was run successfully, there is table api_key in DB but there's no other table.  


Release : 12.3

Component : Analytics


The issue is " Found non-empty schema(s) "public"".

Solution for this issue is to drop api_key table, drop public schema and create again public schema which is empty.

Then the Analytics backend starts successfully and creates all tables.

Root cause: 

The error was to load api_key table with setup.psql before starting Analytics backend for the first time.

setup.psql must be run according to documentation to create the analytics database and the user but it also creates a table which make fail the backend first start.