Re: [Dhis2-users] Duplicate Key Error

2018-11-02 Thread Gerald Thomas 

* ERROR 2018-11-01 08:19:14,139 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-460])
* ERROR 2018-11-01 08:19:14,185 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-460])
* ERROR 2018-11-01 08:19:15,774 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-463])
* ERROR 2018-11-01 08:19:15,785 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-463])
* ERROR 2018-11-01 08:20:19,807 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-456])
* ERROR 2018-11-01 08:20:20,066 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-456])
* ERROR 2018-11-01 08:20:24,360 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-468])
* ERROR 2018-11-01 08:20:24,472 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-468])
* ERROR 2018-11-01 08:40:09,194 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-471])
* ERROR 2018-11-01 08:40:09,332 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-471])
* ERROR 2018-11-01 08:50:05,967 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-466])
* ERROR 2018-11-01 08:50:06,161 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-466])
* ERROR 2018-11-01 08:54:14,112 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-447])
* ERROR 2018-11-01 08:54:14,216 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-447])
* ERROR 2018-11-01 08:55:36,021 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-466])
* ERROR 2018-11-01 08:55:36,130 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-466])
* ERROR 2018-11-01 08:56:29,229 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-467])
* ERROR 2018-11-01 08:56:29,359 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-467])
* ERROR 2018-11-01 09:05:56,392 ERROR: duplicate key value violates unique 
constraint "datavalue_pkey"
* ERROR 2018-11-01 09:05:56,392 HHH000346: Error during managed flush [could 
not execute statement] (SessionImpl.java [tomcat-http-456])
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value 
violates unique constraint "datavalue_pkey"
* ERROR 2018-11-01 09:10:01,926 ERROR: duplicate key value violates unique 
constraint "datavalue_pkey"
* ERROR 2018-11-01 09:10:01,927 HHH000346: Error during managed flush [could 
not execute statement] (SessionImpl.java [tomcat-http-471])
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value 
violates unique constraint "datavalue_pkey"
* ERROR 2018-11-01 09:11:21,808 ERROR: duplicate key value violates unique 
constraint "datavalue_pkey"
* ERROR 2018-11-01 09:11:21,808 HHH000346: Error during managed flush [could 
not execute statement] (SessionImpl.java [tomcat-http-466])
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value 
violates unique constraint "datavalue_pkey"
* ERROR 2018-11-01 09:11:36,607 ERROR: duplicate key value violates unique 
constraint "datavalue_pkey"
* ERROR 2018-11-01 09:11:36,607 HHH000346: Error during managed flush [could 
not execute statement] (SessionImpl.java [tomcat-http-466])
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value 
violates unique constraint "datavalue_pkey"
* ERROR 2018-11-01 09:25:00,650 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-465])
* ERROR 2018-11-01 09:25:00,755 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-465])
* ERROR 2018-11-01 09:25:19,213 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-458])
* ERROR 2018-11-01 09:25:19,319 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-458])
* ERROR 2018-11-01 09:39:59,115 ERROR: duplicate key value violates unique 
constraint "datavalue_pkey"
* ERROR 2018-11-01 09:39:59,116 HHH000346: Error during managed flush [could 
not execute statement] (SessionImpl.java [tomcat-http-456])
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value 
violates unique constraint "datavalue_pkey"
* ERROR 2018-11-01 09:40:00,515 ERROR: duplicate key value violates unique 
constraint "datavalue_pkey"
* ERROR 2018-11-01 09:40:00,515 HHH000346: Error during managed flush [could 
not execute statement] (SessionImpl.java [tomcat-http-465])
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value 
violates unique constraint "datavalue_pkey"
* ERROR 2018-11-01 09:42:41,203 ERROR: duplicate key value violates unique 
constraint "datavalue_pkey"
* ERROR 2018-11-01 09:42:41,204 HHH000346: Error during managed flush [could 
not execute statement] (SessionImpl.java [tomcat-http-463])
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value 
violates unique constraint "datavalue_pkey"
* ERROR 2018-11-01 10:46:22,656 Initialised statement manager

[Dhis2-users] Duplicate Key Error

2018-10-30 Thread gerald thomas 
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.


-- 
Regards,

Gerald
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp