so you mean, i can delete row from table? which table should i can delete that row?
On Mon, Oct 5, 2015 at 4:20 PM, Alex Tumwesigye <atumwesi...@gmail.com> wrote: > Dear Channara, > > Which version are you running? This bug was fixed. It is related to > timezone I f I remember very well. > If you check your period table, there are invalid ranges for 1975-01-01. > Just delete the invalid ranges and you will be fine. > > > Alex > > On Mon, Oct 5, 2015 at 12:14 PM, channara rin <rin.chann...@gmail.com> > wrote: > >> Hi DHIS2 member, >> i got the message from DHIS2 system like below. can you help me how to >> fix this problem? >> >> ===================================================== >> Resource table process failed, please check the logs. Time: >> 2015-10-05T00:00:08.388+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.GeneratedMethodAccessor2260.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.$Proxy104.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-devs >> Post to : dhis2-devs@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > Alex Tumwesigye > > Technical Advisor - DHIS2 (Consultant), > Ministry of Health/AFENET > Kampala > Uganda > > IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya > > IT Specialist (Servers, Networks and Security, Health Information Systems > - DHIS2 ) & Solar Consultant > > +256 774149 775, + 256 759 800161 > > "I don't want to be anything other than what I have been - one tree hill " >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
