dhis2-devs team mailing list archive

[Uddin Fatema <fatemacse@xxxxxxxxx>]

Thanks Calle,

I have already checked all part and this period is daily, so startdate and
enddate is same 2009-12-31

However, my problem is remains same

What can i do.


On Fri, Mar 20, 2015 at 6:11 PM, Calle Hedberg <calle.hedberg@xxxxxxxxx>
wrote:

> Fatema,
>
> note that 2009-12-31 looks like an ENDdate, not a startdate.
>
> Regards
> Calle
>
> On 20 March 2015 at 14:09, Uddin Fatema <fatemacse@xxxxxxxxx> wrote:
>
>> Thanks Bharath Anna and Alex.
>>
>> Actually i checked period table with this( 2009-12-31) startdate and
>> there is no duplicate period with same startdate.
>>
>> Additionally, for test purpose i deleted this period from period table
>> and from other related table with this periodid.
>>
>> Several time restart the tomcat and clear the cash.
>>
>> Although, problem remain same.
>>
>> "Process failed: PreparedStatementCallback; SQL [insert into
>> _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: duplicate
>> key value violates unique constraint "_dateperiodstructure_pkey" Detail:
>> Key (dateperiod)=(2009-12-31) already exists.; nested exception is
>> org.postgresql.util.PSQLException: ERROR: duplicate key value violates
>> unique constraint "_dateperiodstructure_pkey" Detail: Key
>> (dateperiod)=(2009-12-31) already exists.
>> 2015-03-20 12:03:45 Generating resource tables  "
>>
>> What can i do now?
>>
>> On Fri, Mar 20, 2015 at 5:22 PM, Alex Tumwesigye <atumwesigye@xxxxxxxxx>
>> wrote:
>>
>>> Dear Fatema,
>>>
>>> If I remember correctly, this used to be an issue in 2.16. I guess, it
>>> has been carried to 2.18.
>>>
>>> The problem was that, two similar dates were created and when you try to
>>> run the resource table, that range is already created.
>>> Query the period table directly for this date "2009-12-31", two
>>> duplicates may exist.Please try to attempt to compare ranges for different
>>> period types, this is where the problem is (You will encounter a range that
>>> is meant to be for a week, yet it is assigned to daily or monthly)
>>> If so, you may need drop it manually for the resource tables to be
>>> generated.
>>> Let me look for the script
>>>
>>> Thanks.
>>>
>>> Alex
>>>
>>>
>>> On Fri, Mar 20, 2015 at 2:06 PM, Uddin Fatema <fatemacse@xxxxxxxxx>
>>> wrote:
>>>
>>>> Dear All,
>>>>
>>>> I have upgrade our application from 2.16 to 2.18.
>>>> However, when we generate Resource table,we have get error. the error
>>>> short note given in bellow.
>>>>
>>>>  ERROR, category: RESOURCETABLE_UPDATE, t
>>>> ime: Fri Mar 20 16:52:29 BDT 2015, message: Process failed:
>>>> PreparedStatementCal
>>>> lback; SQL [insert into _dateperiodstructure values
>>>> (?,?,?,?,?,?,?,?,?,?,?,?)];
>>>> ERROR: duplicate key value violates unique constraint
>>>> "_dateperiodstructure_pkey
>>>> "
>>>>   Detail: Key (dateperiod)=(2009-12-31) already exists.; nested
>>>> exception is org
>>>> .postgresql.util.PSQLException: ERROR: duplicate key value violates
>>>> unique const
>>>> raint "_dateperiodstructure_pkey"
>>>>   Detail: Key (dateperiod)=(2009-12-31) already exists.]
>>>> (InMemoryNotifier.java
>>>> [taskScheduler-1])
>>>> * ERROR 2015-03-20 16:52:29,445 Unexpected error occurred in scheduled
>>>> task. (Ta
>>>> skUtils.java [taskScheduler-1])
>>>>
>>>> Additionally, here i attached the bug file.
>>>>
>>>> Could anyone please help us.
>>>> --
>>>> Regards,
>>>> *Fatema Uddin*
>>>>
>>>> Technical Advisor (HIS)-Support to the Health Sector Program II
>>>> Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
>>>> German House
>>>> House 10/A-2, Road 90
>>>> Gulshan 2, Dhaka 1212, Bangladesh
>>>>
>>>> T          +880 9666701000
>>>> F          +880 28823099
>>>> M         +880 19 6206 4721
>>>> I           www.giz.de
>>>> <https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.&URL=http%3a%2f%2fwww.giz.de%2f>
>>>>
>>>>
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> 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
>>> "
>>>
>>
>>
>>
>> --
>> Regards,
>> *Fatema Uddin*
>>
>> Technical Advisor (HIS)-Support to the Health Sector Program II
>> Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
>> German House
>> House 10/A-2, Road 90
>> Gulshan 2, Dhaka 1212, Bangladesh
>>
>> T          +880 9666701000
>> F          +880 28823099
>> M         +880 19 6206 4721
>> I           www.giz.de
>> <https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.&URL=http%3a%2f%2fwww.giz.de%2f>
>>
>>
>> _______________________________________________
>> 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
>>
>>
>
>
> --
>
> *******************************************
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472
>
> Cell: +27-82-853-5352
>
> Iridium SatPhone: +8816-315-19274
>
> Email: calle.hedberg@xxxxxxxxx
>
> Skype: calle_hedberg
>
> *******************************************
>
>


-- 
Regards,
*Fatema Uddin*

Technical Advisor (HIS)-Support to the Health Sector Program II
Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
German House
House 10/A-2, Road 90
Gulshan 2, Dhaka 1212, Bangladesh

T          +880 9666701000
F          +880 28823099
M         +880 19 6206 4721
I           www.giz.de
<https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.&URL=http%3a%2f%2fwww.giz.de%2f>