Analytics: no tables after repo change

[simonB2020]

I have just destroyed & recreated my postgresdb.
(AWS Aurora)

I have updated the Repository Connection settings, the "Test" succedes.
Also Restarted Collector & Purger.

However, no tables are created in the new DB.
The Analytics Dashboard states "ERROR: relation "aem_task" does not exist"


My only suspicion is that that the new host value 'might' be the same as the old ?
Is there anything I should be doing to 'reset' ?

Thanks

[Dana_Baldwin · Accepted solution]

Hi @simonB2020 

On the Repository Connection screen, did you click the "Initalize Analytics Repository" button? This creates all the database tables/objects.

After this, stop and resume the collector & purger.

[simonB2020]

I can see that button, but it is greyed out and disabled.

[simonB2020]

Sorry YES !!
I stopped collector & purger.

Then I was able to initialize.

Thank you !

[SushilKumar]

Hello team,

If our response has been helpful, please consider clicking "Accept as Solution". This will assist other users in easily finding the answer.

Regards,

Sushil Kumar