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 <[email protected]> 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 <[email protected]> > 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 <[email protected]> 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 <[email protected]> >>> 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 <[email protected] >>>> > 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 <[email protected]> >>>>> 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 : [email protected] >>>>>> 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 : [email protected] >>>> 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 >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
