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