Re: [Dhis2-devs] 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

Re: [Dhis2-devs] Duplicate Key Error

2018-11-01 Thread moses mwale 
Can you share the full log.

On Tue, 30 Oct 2018 at 1:22 PM, gerald thomas  wrote:

> 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-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
-- 
developer_lusaka_systems
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] 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-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp