Analytics - no history table in Datastore

book

Article ID: 145588

calendar_today

Updated On:

Products

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

Issue/Introduction

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.  

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, 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.