← Back to team overview

dhis2-users team mailing list archive

Resource tables - duplicate key value

 

I got the following error message when I update resource tables.

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

I'm struggling with the issue for some time, and couldn't find the solution
yet.

Can someone kindly guide me to resolve this matter?

Best Regards,

Tharanga