← Back to team overview

dhis2-users team mailing list archive

Re: Resource Table error

 

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@xxxxxxxxx> 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@xxxxxxxxx>
> wrote:
>
>> dear Alex,
>> what you mean was fixed? i currently using:
>> Version:2.19Build revision:19251Build date:2015-07-01 02:04
>>
>> On Thu, Apr 7, 2016 at 10:46 PM, Alex Tumwesigye <atumwesigye@xxxxxxxxx>
>> 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@xxxxxxxxx>
>>> 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@xxxxxxxxxxxxxxxxxxx
>>>> 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
>>> "
>>>
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> 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
>



-- 
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 "

Follow ups

References