dhis2-devs team mailing list archive

[Calle Hedberg <calle.hedberg@xxxxxxxxx>]

Did you verify that all three constraints are in place on the period table?

If they are and you are 100% sure there are no duplicates, then I don't
know - I've had similar error messages a couple of times, but removing the
duplicates and re-inserting the constraint have always sorted it out.

Clear cache (DHIS and browser), empty resource tables, re-start tomcat -
I'm not aware of any other tricks....

Regards
Calle

On 20 March 2015 at 14:15, Uddin Fatema <fatemacse@xxxxxxxxx> wrote:

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


-- 

*******************************************

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

*******************************************