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.chann...@gmail.com> 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 <atumwesi...@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.chann...@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 " >> > > > _______________________________________________ > 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
_______________________________________________ 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