CA Automic Analytics on Premise only synchronizes data from initial startup

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

The CA Automic Analytics on Premise, the Backend, checks the last date for each table and only collect newer records. It starts collecting from the initial startup 32 days back.

How can data older than 32 days be loaded into CA Automic Analytics Backend?
 

Environment

N/A

Resolution

The CA Automic Analytics Backend checks the last date for each table and only collects newer records, that is why you must remove existing data in order to recollect old data.
 
• Stop CA Automic Analytics Backend
• Connect to the PostgreSQL database for CA Automic Analytics
• Execute the following queries to clean the datastore
 

TRUNCATE ah CASCADE;
TRUNCATE ah_cleaned CASCADE;
TRUNCATE ara_execution CASCADE;
TRUNCATE ara_execution_cleaned CASCADE;
TRUNCATE laslm CASCADE;
TRUNCATE laslm_cleaned CASCADE;

• Edit the application.properties file of the CA Automic Analytics Backend and change the following parameter from:

#<collector>.initial_collect_before_now_days=32

to e.g.:

collector.initial_collect_before_now.days=180

• Restart the CA Automic Analytics Backend (if tables are empty the collector.initial_collect_before_now.days=180 will be used, if any data is already in the datastore it will only collect newer stuff)

This allows you to synchronize data that goes back 180 days to the PostgreSQL database.