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?
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;