Hi Fatema I will try and have another look at this.
-- Morten On Wed, Jun 17, 2015 at 4:45 PM, Uddin Fatema <fatema...@gmail.com> wrote: > 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