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 <morte...@gmail.com> 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 <ol...@ifi.uio.no> > 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" <atumwesi...@gmail.com> 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 <fatema...@gmail.com> >>> 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 <atumwesi...@gmail.com >>>> > 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.hedb...@gmail.com> 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 <fatema...@gmail.com> 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.hedb...@gmail.com> 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 <fatema...@gmail.com> >>>>>>>> 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 < >>>>>>>>> atumwesi...@gmail.com> 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 < >>>>>>>>>> fatema...@gmail.com> 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@lists.launchpad.net >>>>>>>>>>> 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-d...@lists.launchpad.net >>>>>>>>> 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.hedb...@gmail.com >>>>>>>> >>>>>>>> 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.hedb...@gmail.com >>>>>> >>>>>> 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-d...@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> _______________________________________________ >> 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 >> >> > > _______________________________________________ > 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 > > -- 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp