Duplicate Key Error

Dear All,

It had been awhile now that we had been noticing this error in our log:

Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint “datavalue_pkey”
Detail: Key (dataelementid, periodid, sourceid, categoryoptioncomboid, attributeoptioncomboid)=(1969, 9498235, 326, 13, 13) already exists.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2476)

Please i need to know why are we getting these error messages and how can i fix them.

Thanks in advance for your help.




Can you share the full log.



cat.txt (75.3 KB)