Great. On Sep 1, 2014 10:52 AM, "Maheed Ramadan" <maheed.rama...@nrc.no> wrote:
> Hi Lars, > > > > Yes, it is working now after installing the latest version of 2.16. no > more “time zone errors”. > > > > Thank you guys. > > > > Maheed > > > > > > *From:* Dhis2-devs [mailto:dhis2-devs-bounces+maheed.ramadan= > nrc...@lists.launchpad.net] *On Behalf Of *Lars Helge Øverland > *Sent:* Monday, September 01, 2014 11:08 AM > *To:* Knut Staring > *Cc:* dhis2-users; DHIS 2 Developers list > *Subject:* Re: [Dhis2-devs] FW: Problem generating reporting & analytics > tables. (dhis 2.16) > > > > 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
