Still some typos... SELECT * FROM period WHERE (startdate, enddate) IN (SELECT startdate, enddate FROM period GROUP BY startdate, enddate HAVING count(*) >1)
On Mon, Oct 5, 2015 at 11:37 AM, Knut Staring <knu...@gmail.com> wrote: > Oops, wrong order. Should be like this, I think: > > > SELECT * FROM period WHERE startdata, enddate IN > (SELECT startdate, endedate FROM period GROUP BY startdate, enddate HAVING > count(*) >1) > > 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-d...@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-d...@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 >> > > > > -- > Knut Staring > Dept. of Informatics, University of Oslo > Norway: +4791880522 > Skype: knutstar > http://dhis2.org > -- 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
