dhis2-devs team mailing list archive

[Uddin Fatema <fatemacse@xxxxxxxxx>]

Dear Morten,

Time zone error still remains in 2.18 and 2.19 version. but working fine in
2.17 and bellow version

Time Zone
(UTC+06:00) Dhaka
(UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi

are giving same error.

(UTC+06:30) Yangon (Rangoon)..do not showing that error.

I change the time zone  UTC+06.30 Yangon and update the resource table it
was fine but inside period table a major change shows.
id               Startdate     Enddate
1283308;3;"2015-05-01";"2015-05-31"
1283335;3;"2015-02-28";"2015-03-30"
1283334;3;"2015-06-01";"2015-06-30"
1283336;3;"2014-12-31";"2015-01-30"
1283337;3;"2014-11-30";"2014-12-30"
1283338;3;"2013-12-31";"2014-01-30"
1283339;3;"2014-01-31";"2014-02-27"
1283340;3;"2014-07-31";"2014-08-30"
1283341;3;"2014-10-31";"2014-11-29"
1283342;3;"2015-04-30";"2015-05-30"
1283343;3;"2015-03-31";"2015-04-29"

Please resolve the bug and help us.

Thanks in advance

On Mon, Mar 23, 2015 at 2:12 PM, Morten Olav Hansen <mortenoh@xxxxxxxxx>
wrote:

> Yes, this is a known bug. I'm still looking into it, it only happens with
> certain timezones, will let you know when it has been fixed.
>
> --
> Morten
>
> On Mon, Mar 23, 2015 at 3:05 PM, Ola Hodne Titlestad <olati@xxxxxxxxxx>
> wrote:
>
>> Hi Fatema,
>>
>> This is not a database issue, but a bug that occurs when generating the
>> period structure table on machines/servers using on of a few specific time
>> zones.
>>
>> I think I commented on this issues on another email thread you started.
>>
>> Morten knows the details, but my quick fix advice is to change the system
>> time zone to a zone that we know works, e.g. GMT.
>>
>> Ola
>> On 20 Mar 2015 14:16, "Alex Tumwesigye" <atumwesigye@xxxxxxxxx> wrote:
>>
>>> Dear Fatema,
>>>
>>> All looks good and no duplicates.
>>> The only odd stuff is this: Note the years (2063 and 2140)
>>> "811017","1","2063-03-11","2063-03-11"
>>> "811018","1","2063-03-12","2063-03-12"
>>> "811019","1","2063-03-13","2063-03-13"
>>> "811020","1","2063-03-14","2063-03-14"
>>> "811021","1","2063-03-15","2063-03-15"
>>> "811022","1","2063-03-16","2063-03-16"
>>> "811023","1","2063-03-17","2063-03-17"
>>> "811024","1","2063-03-18","2063-03-18"
>>> "811025","1","2063-03-19","2063-03-19"
>>> "811026","1","2063-03-20","2063-03-20"
>>> "811027","1","2063-03-21","2063-03-21"
>>> "811028","1","2063-03-22","2063-03-22"
>>> "811029","1","2063-03-23","2063-03-23"
>>> "811030","1","2063-03-24","2063-03-24"
>>> "811031","1","2063-03-25","2063-03-25"
>>> "1555","1","2140-09-03","2140-09-03"
>>> "1554","1","2140-09-04","2140-09-04"
>>> "1550","1","2140-09-05","2140-09-05"
>>> "1551","1","2140-09-06","2140-09-06"
>>> "1552","1","2140-09-07","2140-09-07"
>>> "1553","1","2140-09-08","2140-09-08"
>>>
>>> can you try this query on period table?
>>> delete from period where enddate is null  or startdate is null;
>>>
>>> After running this query, go to resource table and regenerate them.
>>>
>>> Thanks.
>>>
>>> Alex
>>>
>>> On Fri, Mar 20, 2015 at 3:52 PM, Uddin Fatema <fatemacse@xxxxxxxxx>
>>> wrote:
>>>
>>>> Dear Alex,
>>>>
>>>> I have run this query and get two result.
>>>>
>>>> select enddate,startdate,periodtypeid from period where enddate =
>>>> '2009-12-31' or startdate = '2009-12-31'
>>>>
>>>> Result is
>>>>
>>>> "2009-12-31";"2009-12-01";3
>>>> "2009-12-31";"2009-01-01";6
>>>>
>>>> here i attached the file too.
>>>>
>>>> Thanks a lot
>>>>
>>>>
>>>> On Fri, Mar 20, 2015 at 6:37 PM, Alex Tumwesigye <atumwesigye@xxxxxxxxx
>>>> > wrote:
>>>>
>>>>> Fatema,
>>>>>
>>>>> Can you dump for me the enddate, startdate and periodtype from period
>>>>> table for that date '2009-12-31'
>>>>>
>>>>> I need to see the output of "select enddate,startdate,periodtypeid
>>>>> from period where enddate like '2009-12-31' or startdate like '2009-12-31' "
>>>>>
>>>>> Thanks.
>>>>>
>>>>> Alex
>>>>>
>>>>> On Fri, Mar 20, 2015 at 3:20 PM, Calle Hedberg <
>>>>> calle.hedberg@xxxxxxxxx> wrote:
>>>>>
>>>>>> 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
>>>>>>
>>>>>> *******************************************
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> 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>
>>>>
>>>>
>>>
>>>
>>> --
>>> 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
>>>
>>>
>> _______________________________________________
>> 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
>>
>>
>
> _______________________________________________
> 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
>
>


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