dhis2-users team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

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 <knutst@xxxxxxxxx> 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 <knutst@xxxxxxxxx> 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.channara@xxxxxxxxx>
>> 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 <atumwesigye@xxxxxxxxx>
>>> 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.channara@xxxxxxxxx>
>>>> 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@xxxxxxxxxxxxxxxxxxx
>>>>> 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@xxxxxxxxxxxxxxxxxxx
>>> 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