Hi Maheeed, Let us know if it works as expected on your side..
regards, Lars On Sep 1, 2014 9:31 AM, "Knut Staring" <knu...@gmail.com> wrote: > Hi, Morten has now fixed this in the latest 2.16, you can find it here: > > https://apps.dhis2.org/ci/job/dhis-2.16/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war > > Knut > > On Wed, Aug 20, 2014 at 12:20 PM, Morten Olav Hansen <morte...@gmail.com> > wrote: > >> Ok, good to hear that. I'm sorry, but it will take some time to fix >> this.. we are looking into it >> >> -- >> Morten >> >> >> On Wed, Aug 20, 2014 at 12:47 PM, Maheed Ramadan <maheed.rama...@nrc.no> >> wrote: >> >>> Dear Morten & developers, >>> >>> >>> >>> As described in my previous mail, the error that is appearing when >>> generating the analytics/resource tables is probably related to the current >>> time zone setting on my pc which is è (UTC+2 Beirut/Lebanon). >>> >>> >>> >>> The error is also indicating that it is related to daylight saving gap. >>> >>> So, what I did is that I removed the automatic daylight saving on my PC >>> as indicated in the below picture (temporarily just to test this issue). >>> >>> >>> >>> I restarted the DHIS server & tried to regenerate the analytics tables >>> and it went successfully without any errors. >>> >>> So, just removing the auto daylight saving eliminated the problem. >>> >>> >>> >>> However, I need to keep daylight saving enabled so I appreciate if this >>> bug is resolved ASAP. >>> >>> >>> >>> Hope this helps. Awaiting your feedback. >>> >>> >>> >>> I am using DHIS: >>> >>> Version: 2.16 >>> >>> Build revision: 16323 >>> >>> Build date: 2014-08-20 02:04 >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> Thank you. >>> >>> >>> >>> Maheed >>> >>> >>> >>> >>> >>> >>> >>> *From:* Dhis2-users [mailto:dhis2-users-bounces+maheed.ramadan= >>> nrc...@lists.launchpad.net] *On Behalf Of *Maheed Ramadan >>> *Sent:* Tuesday, August 19, 2014 1:37 PM >>> *To:* Morten Olav Hansen >>> *Cc:* dhis2-users; dhis2-d...@lists.launchpad.net >>> *Subject:* Re: [Dhis2-users] [Dhis2-devs] FW: Problem generating >>> reporting & analytics tables. (dhis 2.16) >>> >>> >>> >>> Thanks Morten. >>> >>> >>> >>> I appreciate your help. >>> >>> >>> >>> >>> >>> *From:* Morten Olav Hansen [mailto:morte...@gmail.com >>> <morte...@gmail.com>] >>> *Sent:* Tuesday, August 19, 2014 12:35 PM >>> *To:* Maheed Ramadan >>> *Cc:* dhis2-users; Lars Helge Øverland; dhis2-d...@lists.launchpad.net >>> *Subject:* Re: [Dhis2-devs] FW: Problem generating reporting & >>> analytics tables. (dhis 2.16) >>> >>> >>> >>> Hi Maheed >>> >>> I will have a look at it and get back to you. >>> >>> On Aug 19, 2014 4:21 PM, "Maheed Ramadan" <maheed.rama...@nrc.no> wrote: >>> >>> Dear Lars, >>> >>> >>> >>> Please do you have any update or feedback on this issue. >>> >>> I am still unable to find a solution or fix for this. >>> >>> >>> >>> Note that I did try a clean installation for both v2.15 and 2.16 on my >>> machine. >>> >>> >>> >>> Ver 2.15 worked well è it generated the analytics tables. >>> >>> >>> >>> While 2.16 raised this error: >>> >>> *Process failed: Illegal instant due to time zone offset transition >>> (daylight savings time 'gap'): 1975-04-30T22:00:00.000 <00.000> >>> (Asia/Beirut)* >>> >>> >>> >>> The log file is attached for more details. >>> >>> >>> >>> Thank you for your support. >>> >>> >>> >>> >>> >>> Maheed >>> >>> >>> >>> >>> >>> >>> >>> *From:* Dhis2-devs [mailto:dhis2-devs-bounces+maheed.ramadan= >>> nrc...@lists.launchpad.net] *On Behalf Of *Maheed Ramadan >>> *Sent:* Monday, August 18, 2014 2:18 PM >>> *To:* Knut Staring >>> *Cc:* dhis2-users@lists.launchpad.net; dhis2-d...@lists.launchpad.net >>> *Subject:* Re: [Dhis2-devs] Problem generating reporting & analytics >>> tables. (dhis 2.16) >>> >>> >>> >>> Hi Knut, >>> >>> >>> >>> Please find the attached log file. You can find the error in the last >>> line of the file. >>> >>> It seems it is occurring while generating the “_dateperiodstructure” >>> table. >>> >>> >>> >>> Actually, I don’t have any data in 1975. However, when I added the org >>> units to the system, I set the opening date to an arbitrary date of >>> 01/01/1970 for all org units. I don’t know if this is related to the >>> problem. >>> >>> >>> >>> To check this, I changed the opening dates to “01/01/2013” and the >>> problem still exists. >>> >>> >>> >>> Actually, as I previously indicated, the error is appearing on a clean >>> database without adding anything to it. >>> >>> >>> >>> Note: I am using v 2.16 rev. 16320 . >>> >>> >>> >>> I hope this helps. >>> >>> >>> >>> Awaiting your feedback. >>> >>> >>> >>> Thank you. >>> >>> >>> >>> >>> >>> *Maheed Ramadan* >>> >>> M&E Database Officer >>> >>> *Norwegian Refugee Council- Lebanon* >>> >>> >>> >>> Email: maheed.rama...@nrc.no >>> >>> Skype: mr_maheed >>> >>> Mobile: 70-888037 >>> >>> Website : www.nrc.no >>> >>> >>> >>> *[image: Description: Logo_Eng_til-epost-sign]* >>> >>> P Please consider the environment before printing this e-mail. >>> >>> You control Climate Change: Turn down, switch off, recycle, walk >>> >>> >>> >>> *From:* Knut Staring [mailto:knu...@gmail.com <knu...@gmail.com>] >>> *Sent:* Monday, August 18, 2014 1:24 PM >>> *To:* Maheed Ramadan >>> *Cc:* dhis2-users@lists.launchpad.net; Lars Helge Øverland; >>> dhis2-d...@lists.launchpad.net >>> *Subject:* Re: [Dhis2-devs] Problem generating reporting & analytics >>> tables. (dhis 2.16) >>> >>> >>> >>> Can you please share your log file? Do you have data going back to 1975? >>> >>> On 18 Aug 2014 09:27, "Maheed Ramadan" <maheed.rama...@nrc.no> wrote: >>> >>> Dear All, >>> >>> >>> >>> I am facing a problem in the reporting & Analytics module of DHIS 2.16 >>> (latest revision) >>> >>> When I try to generate the analytics tables from the reporting module, >>> the system displays the progress bar and freeze their forever and so no >>> reporting can be created since this is process is failing. >>> >>> >>> >>> I tried it on new & clean database without any data and still no success. >>> >>> >>> >>> Then I tried to generate resource tables from the data maintenance >>> section. Here the progress bar showed for a couple of seconds and then it >>> displayed the following error message: >>> >>> >>> >>> *Process failed: Illegal instant due to time zone offset transition >>> (daylight savings time 'gap'): 1975-04-30T22:00:00.000 <00.000> >>> (Asia/Beirut)* >>> >>> >>> >>> >>> >>> So, it seems that generating analytics tables is actually failing >>> because it is trying to generate the resource tables first and this is >>> causing it to freeze. >>> >>> >>> >>> I am using the local instance of dhis 2.16 on windows 7 + latest java >>> update. The database is postgres 9.3. >>> >>> Note that I tried it also on the local H2 database and it still fails. >>> >>> >>> >>> Please, how I resolve this issue? Note: My windows machine time zone is >>> set to è (UTC+02:00) Beirut. >>> >>> >>> >>> >>> >>> Thanks for your support. >>> >>> >>> >>> Maheed. >>> >>> >>> _______________________________________________ >>> 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 >> >> > > > -- > Knut Staring > Dept. of Informatics, University of Oslo > +4791880522 > http://dhis2.org > > _______________________________________________ > 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-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp