Resource Table error

Dear friend,
when i run analytic, i always got error like below. how to fix this problem?

···

==========================================

Resource table process failed

Resource table process failed, please check the logs. Time: 2016-04-07T21:45:16.145+07:00. Message: PreparedStatementCallback; SQL [insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: duplicate key value violates unique constraint “_dateperiodstructure_pkey”
Detail: Key (dateperiod)=(1975-01-01) already exists.; nested exception is org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint “_dateperiodstructure_pkey”
Detail: Key (dateperiod)=(1975-01-01) already exists. Cause: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint “_dateperiodstructure_pkey”
Detail: Key (dateperiod)=(1975-01-01) already exists.

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)

at org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1130)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:396)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2892)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)

at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1005)

at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:989)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:673)

at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:989)

at org.springframework.jdbc.core.BatchUpdateUtils.executeBatchUpdate(BatchUpdateUtils.java:32)

at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1039)

at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034)

at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.batchUpdate(JdbcResourceTableStore.java:101)

at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDatePeriodTable(DefaultResourceTableService.java:456)

at sun.reflect.GeneratedMethodAccessor906.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)

at com.sun.proxy.$Proxy262.generateDatePeriodTable(Unknown Source)

at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)

at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:85)

at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)

at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)

at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Dear Channara,

I think this bug was fixed.

The date “1975-01-01” is duplicated.

check your period table for any anomaly for that date.

Alex

···

On Thu, Apr 7, 2016 at 6:02 PM, channara rin rin.channara@gmail.com wrote:

Dear friend,
when i run analytic, i always got error like below. how to fix this problem?

==========================================

Resource table process failed

Resource table process failed, please check the logs. Time: 2016-04-07T21:45:16.145+07:00. Message: PreparedStatementCallback; SQL [insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: duplicate key value violates unique constraint “_dateperiodstructure_pkey”
Detail: Key (dateperiod)=(1975-01-01) already exists.; nested exception is org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint “_dateperiodstructure_pkey”
Detail: Key (dateperiod)=(1975-01-01) already exists. Cause: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint “_dateperiodstructure_pkey”
Detail: Key (dateperiod)=(1975-01-01) already exists.

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)

at org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1130)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:396)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2892)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)

at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1005)

at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:989)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:673)

at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:989)

at org.springframework.jdbc.core.BatchUpdateUtils.executeBatchUpdate(BatchUpdateUtils.java:32)

at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1039)

at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034)

at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.batchUpdate(JdbcResourceTableStore.java:101)

at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDatePeriodTable(DefaultResourceTableService.java:456)

at sun.reflect.GeneratedMethodAccessor906.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)

at com.sun.proxy.$Proxy262.generateDatePeriodTable(Unknown Source)

at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)

at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:85)

at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)

at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)

at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)


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

Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda
+256 774149 775, + 256 759 800161

Skype ID: talexie

IT Consultant (Servers, Networks and Security, Health Information Systems - DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant

"I don’t want to be anything other than what I have been - one tree hill "

dear Alex,
what you mean was fixed? i currently using:

Version:
2.19
Build revision:
19251
Build date:
2015-07-01 02:04

···

On Thu, Apr 7, 2016 at 10:46 PM, Alex Tumwesigye atumwesigye@gmail.com wrote:

Dear Channara,

I think this bug was fixed.

The date “1975-01-01” is duplicated.

check your period table for any anomaly for that date.

Alex

On Thu, Apr 7, 2016 at 6:02 PM, channara rin rin.channara@gmail.com wrote:

Dear friend,
when i run analytic, i always got error like below. how to fix this problem?

==========================================

Resource table process failed

Resource table process failed, please check the logs. Time: 2016-04-07T21:45:16.145+07:00. Message: PreparedStatementCallback; SQL [insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: duplicate key value violates unique constraint “_dateperiodstructure_pkey”
Detail: Key (dateperiod)=(1975-01-01) already exists.; nested exception is org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint “_dateperiodstructure_pkey”
Detail: Key (dateperiod)=(1975-01-01) already exists. Cause: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint “_dateperiodstructure_pkey”
Detail: Key (dateperiod)=(1975-01-01) already exists.

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)

at org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1130)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:396)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2892)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)

at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1005)

at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:989)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:673)

at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:989)

at org.springframework.jdbc.core.BatchUpdateUtils.executeBatchUpdate(BatchUpdateUtils.java:32)

at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1039)

at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034)

at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.batchUpdate(JdbcResourceTableStore.java:101)

at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDatePeriodTable(DefaultResourceTableService.java:456)

at sun.reflect.GeneratedMethodAccessor906.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)

at com.sun.proxy.$Proxy262.generateDatePeriodTable(Unknown Source)

at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)

at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:85)

at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)

at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)

at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)


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


Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda
+256 774149 775, + 256 759 800161

Skype ID: talexie

IT Consultant (Servers, Networks and Security, Health Information Systems - DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant

"I don’t want to be anything other than what I have been - one tree hill "

Hi Channara,

It seems to me that the problem is that the _dateperiodstructure table has not been dropped (not sure why).

Then when you try to regenerate it, it tries to insert the same values, starting from 1975-01-01 (which is the first row in the table)

···

On Thu, Apr 7, 2016 at 6:01 PM, channara rin rin.channara@gmail.com wrote:

dear Alex,
what you mean was fixed? i currently using:

Version:
2.19
Build revision:
19251
Build date:
2015-07-01 02:04


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

On Thu, Apr 7, 2016 at 10:46 PM, Alex Tumwesigye atumwesigye@gmail.com wrote:

Dear Channara,

I think this bug was fixed.

The date “1975-01-01” is duplicated.

check your period table for any anomaly for that date.

Alex

On Thu, Apr 7, 2016 at 6:02 PM, channara rin rin.channara@gmail.com wrote:

Dear friend,
when i run analytic, i always got error like below. how to fix this problem?

==========================================

Resource table process failed

Resource table process failed, please check the logs. Time: 2016-04-07T21:45:16.145+07:00. Message: PreparedStatementCallback; SQL [insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: duplicate key value violates unique constraint “_dateperiodstructure_pkey”
Detail: Key (dateperiod)=(1975-01-01) already exists.; nested exception is org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint “_dateperiodstructure_pkey”
Detail: Key (dateperiod)=(1975-01-01) already exists. Cause: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint “_dateperiodstructure_pkey”
Detail: Key (dateperiod)=(1975-01-01) already exists.

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)

at org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1130)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:396)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2892)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)

at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1005)

at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:989)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:673)

at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:989)

at org.springframework.jdbc.core.BatchUpdateUtils.executeBatchUpdate(BatchUpdateUtils.java:32)

at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1039)

at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034)

at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.batchUpdate(JdbcResourceTableStore.java:101)

at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDatePeriodTable(DefaultResourceTableService.java:456)

at sun.reflect.GeneratedMethodAccessor906.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)

at com.sun.proxy.$Proxy262.generateDatePeriodTable(Unknown Source)

at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)

at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:85)

at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)

at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)

at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)


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


Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda
+256 774149 775, + 256 759 800161

Skype ID: talexie

IT Consultant (Servers, Networks and Security, Health Information Systems - DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant

"I don’t want to be anything other than what I have been - one tree hill "

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

Channara,

The issue is related to timezone and was fixed. Upgrade to at least 2.20 or 2.21 but you have to first remove the duplicate period.

Alex

···

On Thu, Apr 7, 2016 at 7:08 PM, Knut Staring knutst@gmail.com wrote:

Hi Channara,

It seems to me that the problem is that the _dateperiodstructure table has not been dropped (not sure why).

Then when you try to regenerate it, it tries to insert the same values, starting from 1975-01-01 (which is the first row in the table)

On Thu, Apr 7, 2016 at 6:01 PM, channara rin rin.channara@gmail.com wrote:

dear Alex,
what you mean was fixed? i currently using:

Version:
2.19
Build revision:
19251
Build date:
2015-07-01 02:04


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

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

On Thu, Apr 7, 2016 at 10:46 PM, Alex Tumwesigye atumwesigye@gmail.com wrote:

Dear Channara,

I think this bug was fixed.

The date “1975-01-01” is duplicated.

check your period table for any anomaly for that date.

Alex

On Thu, Apr 7, 2016 at 6:02 PM, channara rin rin.channara@gmail.com wrote:

Dear friend,
when i run analytic, i always got error like below. how to fix this problem?

==========================================

Resource table process failed

Resource table process failed, please check the logs. Time: 2016-04-07T21:45:16.145+07:00. Message: PreparedStatementCallback; SQL [insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: duplicate key value violates unique constraint “_dateperiodstructure_pkey”
Detail: Key (dateperiod)=(1975-01-01) already exists.; nested exception is org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint “_dateperiodstructure_pkey”
Detail: Key (dateperiod)=(1975-01-01) already exists. Cause: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint “_dateperiodstructure_pkey”
Detail: Key (dateperiod)=(1975-01-01) already exists.

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)

at org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1130)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:396)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2892)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)

at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1005)

at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:989)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:673)

at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:989)

at org.springframework.jdbc.core.BatchUpdateUtils.executeBatchUpdate(BatchUpdateUtils.java:32)

at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1039)

at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034)

at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.batchUpdate(JdbcResourceTableStore.java:101)

at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDatePeriodTable(DefaultResourceTableService.java:456)

at sun.reflect.GeneratedMethodAccessor906.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)

at com.sun.proxy.$Proxy262.generateDatePeriodTable(Unknown Source)

at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)

at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:85)

at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)

at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)

at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)


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


Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda
+256 774149 775, + 256 759 800161

Skype ID: talexie

IT Consultant (Servers, Networks and Security, Health Information Systems - DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant

"I don’t want to be anything other than what I have been - one tree hill "

Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda
+256 774149 775, + 256 759 800161

Skype ID: talexie

IT Consultant (Servers, Networks and Security, Health Information Systems - DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant

"I don’t want to be anything other than what I have been - one tree hill "

Agree with Alex that you should really try to do an upgrade - just please make sure to back up everything first!

However, I notice you had the same problem in October? Was it solve then and now it has come back - or have you had the problem now for 6 months?

https://lists.launchpad.net/dhis2-users/msg08287.html

···

On Thu, Apr 7, 2016 at 6:11 PM, Alex Tumwesigye atumwesigye@gmail.com wrote:

Channara,

The issue is related to timezone and was fixed. Upgrade to at least 2.20 or 2.21 but you have to first remove the duplicate period.

Alex

On Thu, Apr 7, 2016 at 7:08 PM, Knut Staring knutst@gmail.com wrote:

Hi Channara,

It seems to me that the problem is that the _dateperiodstructure table has not been dropped (not sure why).

Then when you try to regenerate it, it tries to insert the same values, starting from 1975-01-01 (which is the first row in the table)


Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda
+256 774149 775, + 256 759 800161

Skype ID: talexie

IT Consultant (Servers, Networks and Security, Health Information Systems - DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant

"I don’t want to be anything other than what I have been - one tree hill "

On Thu, Apr 7, 2016 at 6:01 PM, channara rin rin.channara@gmail.com wrote:

dear Alex,
what you mean was fixed? i currently using:

Version:
2.19
Build revision:
19251
Build date:
2015-07-01 02:04


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

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

On Thu, Apr 7, 2016 at 10:46 PM, Alex Tumwesigye atumwesigye@gmail.com wrote:

Dear Channara,

I think this bug was fixed.

The date “1975-01-01” is duplicated.

check your period table for any anomaly for that date.

Alex

On Thu, Apr 7, 2016 at 6:02 PM, channara rin rin.channara@gmail.com wrote:

Dear friend,
when i run analytic, i always got error like below. how to fix this problem?

==========================================

Resource table process failed

Resource table process failed, please check the logs. Time: 2016-04-07T21:45:16.145+07:00. Message: PreparedStatementCallback; SQL [insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: duplicate key value violates unique constraint “_dateperiodstructure_pkey”
Detail: Key (dateperiod)=(1975-01-01) already exists.; nested exception is org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint “_dateperiodstructure_pkey”
Detail: Key (dateperiod)=(1975-01-01) already exists. Cause: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint “_dateperiodstructure_pkey”
Detail: Key (dateperiod)=(1975-01-01) already exists.

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)

at org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1130)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:396)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2892)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)

at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1005)

at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:989)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:673)

at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:989)

at org.springframework.jdbc.core.BatchUpdateUtils.executeBatchUpdate(BatchUpdateUtils.java:32)

at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1039)

at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034)

at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.batchUpdate(JdbcResourceTableStore.java:101)

at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDatePeriodTable(DefaultResourceTableService.java:456)

at sun.reflect.GeneratedMethodAccessor906.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)

at com.sun.proxy.$Proxy262.generateDatePeriodTable(Unknown Source)

at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)

at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:85)

at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)

at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)

at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)


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


Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda
+256 774149 775, + 256 759 800161

Skype ID: talexie

IT Consultant (Servers, Networks and Security, Health Information Systems - DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant

"I don’t want to be anything other than what I have been - one tree hill "

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

dear alex,
how can i do for remove duplicate period?

Yes, right knut.

by the way, if i upgrade to v2.20, that version doesn’t have individual record function, so my problem is i don’t want to run aggregate data automatic.

···

On Thu, Apr 7, 2016 at 11:29 PM, Knut Staring knutst@gmail.com wrote:

Agree with Alex that you should really try to do an upgrade - just please make sure to back up everything first!

However, I notice you had the same problem in October? Was it solve then and now it has come back - or have you had the problem now for 6 months?

https://lists.launchpad.net/dhis2-users/msg08287.html

On Thu, Apr 7, 2016 at 6:11 PM, Alex Tumwesigye atumwesigye@gmail.com wrote:

Channara,

The issue is related to timezone and was fixed. Upgrade to at least 2.20 or 2.21 but you have to first remove the duplicate period.

Alex


Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

On Thu, Apr 7, 2016 at 7:08 PM, Knut Staring knutst@gmail.com wrote:

Hi Channara,

It seems to me that the problem is that the _dateperiodstructure table has not been dropped (not sure why).

Then when you try to regenerate it, it tries to insert the same values, starting from 1975-01-01 (which is the first row in the table)


Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda
+256 774149 775, + 256 759 800161

Skype ID: talexie

IT Consultant (Servers, Networks and Security, Health Information Systems - DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant

"I don’t want to be anything other than what I have been - one tree hill "

On Thu, Apr 7, 2016 at 6:01 PM, channara rin rin.channara@gmail.com wrote:

dear Alex,
what you mean was fixed? i currently using:

Version:
2.19
Build revision:
19251
Build date:
2015-07-01 02:04


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

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

On Thu, Apr 7, 2016 at 10:46 PM, Alex Tumwesigye atumwesigye@gmail.com wrote:

Dear Channara,

I think this bug was fixed.

The date “1975-01-01” is duplicated.

check your period table for any anomaly for that date.

Alex

On Thu, Apr 7, 2016 at 6:02 PM, channara rin rin.channara@gmail.com wrote:

Dear friend,
when i run analytic, i always got error like below. how to fix this problem?

==========================================

Resource table process failed

Resource table process failed, please check the logs. Time: 2016-04-07T21:45:16.145+07:00. Message: PreparedStatementCallback; SQL [insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: duplicate key value violates unique constraint “_dateperiodstructure_pkey”
Detail: Key (dateperiod)=(1975-01-01) already exists.; nested exception is org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint “_dateperiodstructure_pkey”
Detail: Key (dateperiod)=(1975-01-01) already exists. Cause: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint “_dateperiodstructure_pkey”
Detail: Key (dateperiod)=(1975-01-01) already exists.

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)

at org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1130)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:396)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2892)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)

at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1005)

at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:989)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:673)

at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:989)

at org.springframework.jdbc.core.BatchUpdateUtils.executeBatchUpdate(BatchUpdateUtils.java:32)

at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1039)

at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034)

at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.batchUpdate(JdbcResourceTableStore.java:101)

at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDatePeriodTable(DefaultResourceTableService.java:456)

at sun.reflect.GeneratedMethodAccessor906.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)

at com.sun.proxy.$Proxy262.generateDatePeriodTable(Unknown Source)

at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)

at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:85)

at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)

at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)

at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)


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


Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda
+256 774149 775, + 256 759 800161

Skype ID: talexie

IT Consultant (Servers, Networks and Security, Health Information Systems - DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant

"I don’t want to be anything other than what I have been - one tree hill "

I have the same problem and I created new database but it is the issue is still and I am using 2.31 version, could you please advice