dhis2-devs team mailing list archive

[channara rin <rin.channara@xxxxxxxxx>]

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@xxxxxxxxx> 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@xxxxxxxxx>
> 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@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 "
>>
>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
>