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.
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.