Running Analytics Table

Support - Assistance technique
1

Hello Everyone

I know a lot of people have faced this issue but I couldnt conclude reading through topics, what is the exact fix for the issue.

For me when I run Analytics Table, I get error as below:

Process failed: PreparedStatementCallback; SQL [insert into _dateperiodstructure_temp values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: duplicate key value violates unique constraint “_dateperiodstructure_temp_pkey” Detail: Key (dateperiod)=(2021-01-31) already exists.; nested exception is org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint “_dateperiodstructure_temp_pkey” Detail: Key (dateperiod)=(2021-01-31) already exists.

I have tried below steps mentioned across various community chats like:

  1. Running Maintenance(Clear Analytics table, Clear Cache)
  2. Checked for Improper year formats in db under period/_dateperiodstructure.

My intention is to download metadata file for visualization, for which the API fails with 500 and when I check logs i get that ref table analytics_event_pqflle3gg9q is unavailable. Therefore, I run Analytics table maintenance.

Please help!

@Gassim @dhis2-analytics

2

A post was merged into an existing topic: Urgent | Analytics Table Management Issue