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 >
_______________________________________________ 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
