I’m using the DHIS2 version 2.33.
I tried running resource tables for first time, after tracker capture . It gave me following error.
Tried ‘clear analytic tables’ in maintanance, and it didn’t help.
Also I checked the _dateperiodstructure_temp table, and there is no value of ‘1978-10-15’
Process failed: PreparedStatementCallback; SQL [insert into _dateperiodstructure_temp values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: duplicate key value violates unique constraint “_dateperiodstructure_temp_pkey” Detail: Key (dateperiod)=(1978-10-15) already exists.; nested exception is org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint “_dateperiodstructure_temp_pkey” Detail: Key (dateperiod)=(1978-10-15) already exists.
I tried to get back with previous version 2.32 but is the same issue.
Please advice me and thanks a lot for your time.
Best Regards,
Hadeel