Analytics - no history table in Datastore


Article ID: 145588


Updated On:


CA Automic Workload Automation - Automation Engine CA Automic Workload Automation - Automation Engine


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

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, Analytics backend starts successfully and creates all tables.

The error was to load api_key table with setup.psql before starting Anamytics 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 firt start.