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.