Hi team,
We recently encountered an issue in generating resource tables. It would be of great help if, there any inputs from DHIS team/@dhis2-analytics team to resolve it. We have our servers on 2.26 version. Thought the version is not currently supported, some suggestion for the same, would really help us.
Context :
Our analytics jobs started failing, giving,
SQL [insert into _dateperiodstructure_temp values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: duplicate key value violates unique constraint “_dateperiodstructure_temp_pkey1”
we understood that it is Resource table that, while being generated, throws this error.
We have tried the following,
-
Clear analytics cache - didn’t’ help.
-
From Data Administration → maintenance, try to generate resource tables - this again threw the same error.
-
we tried to drop the table directly from db (_dateperiodstructure) and then tried to generate the resource table. - this also threw the same error.
Is it anything else that we can try, to resolve this. Some insights on this would help.
Thanks,