Analytics - no history table in Datastore

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

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.  

Environment

Release : 12.3

Component : Analytics

Resolution

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.