[image: Inline image 1] RUN [image: Inline image 2]
On Mon, Oct 5, 2015 at 6:36 PM, channara rin <rin.chann...@gmail.com> wrote: > No record found... > > On Mon, Oct 5, 2015 at 6:21 PM, Jason Pickering < > jason.p.picker...@gmail.com> wrote: > >> What about >> >> SELECT * FROM period where startdate = '1975-01-01'::date >> >> >> >> On Mon, Oct 5, 2015 at 12:30 PM, channara rin <rin.chann...@gmail.com> >> wrote: >> >>> Hi Jason, >>> I am using version 2.20 and Time zone: GMT+7:00 >>> >>> On Mon, Oct 5, 2015 at 5:24 PM, Jason Pickering < >>> jason.p.picker...@gmail.com> wrote: >>> >>>> What time zone are you on and which version are you using? >>>> >>>> >>>> On Mon, Oct 5, 2015 at 12:02 PM, channara rin <rin.chann...@gmail.com> >>>> wrote: >>>> >>>>> thank you jason >>>>> by the way, i run already. but didn't see any record show up >>>>> >>>>> On Mon, Oct 5, 2015 at 4:41 PM, Jason Pickering < >>>>> jason.p.picker...@gmail.com> wrote: >>>>> >>>>>> And you may want to be careful about deleting anything as there may >>>>>> be data attached to one of those periods. You should of course make a >>>>>> backup before you attempt to delete anything, and then find any data >>>>>> which >>>>>> is referencing the duplicate period. There are quite a few tables which >>>>>> reference "period", so you may need to check these. >>>>>> >>>>>> However, if you get back a period which does not actually correspond >>>>>> to the correct period type (for instance, a year with a period type as a >>>>>> week), that is the one you should focus on trying to get rid of. >>>>>> >>>>>> Regards >>>>>> Jason >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> On Mon, Oct 5, 2015 at 11:36 AM, Knut Staring <knu...@gmail.com> >>>>>> wrote: >>>>>> >>>>>>> The table is called period. >>>>>>> >>>>>>> But please first run this query: >>>>>>> >>>>>>> SELECT * FROM period WHERE startdata, enddate IN >>>>>>> (SELECT startdate, endedate FROM period HAVING count(*) >1 GROUP BY >>>>>>> startdate, enddate) >>>>>>> >>>>>>> On Mon, Oct 5, 2015 at 11:33 AM, channara rin < >>>>>>> rin.chann...@gmail.com> wrote: >>>>>>> >>>>>>>> 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 >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Knut Staring >>>>>>> Dept. of Informatics, University of Oslo >>>>>>> Norway: +4791880522 >>>>>>> Skype: knutstar >>>>>>> http://dhis2.org >>>>>>> >>>>>>> _______________________________________________ >>>>>>> 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 >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Jason P. Pickering >>>>>> email: jason.p.picker...@gmail.com >>>>>> tel:+46764147049 >>>>>> >>>>> >>>>> >>>> >>>> >>>> -- >>>> Jason P. Pickering >>>> email: jason.p.picker...@gmail.com >>>> tel:+46764147049 >>>> >>> >>> >> >> >> -- >> Jason P. Pickering >> email: jason.p.picker...@gmail.com >> tel:+46764147049 >> > >
_______________________________________________ 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