Thank you Morten, I am eagerly waiting for it. On Thu, Jun 18, 2015 at 7:41 AM, Morten Olav Hansen <[email protected]> wrote:
> Hi Fatema > > I will try and have another look at this. > > -- > Morten > > On Wed, Jun 17, 2015 at 4:45 PM, Uddin Fatema <[email protected]> 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 <[email protected]> >> 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 <[email protected]> >>> 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" <[email protected]> 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 <[email protected]> >>>>> 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 < >>>>>> [email protected]> 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 < >>>>>>> [email protected]> 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 <[email protected]> >>>>>>>> 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 < >>>>>>>>> [email protected]> 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 <[email protected]> >>>>>>>>>> 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 < >>>>>>>>>>> [email protected]> 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 < >>>>>>>>>>>> [email protected]> 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 : [email protected] >>>>>>>>>>>>> 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 : [email protected] >>>>>>>>>>> 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: [email protected] >>>>>>>>>> >>>>>>>>>> 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: [email protected] >>>>>>>> >>>>>>>> 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 : [email protected] >>>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>>> More help : https://help.launchpad.net/ListHelp >>>>> >>>>> >>>> _______________________________________________ >>>> Mailing list: https://launchpad.net/~dhis2-devs >>>> Post to : [email protected] >>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>> More help : https://help.launchpad.net/ListHelp >>>> >>>> >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~dhis2-devs >>> Post to : [email protected] >>> 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> >> >> > -- 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 : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
