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 <[email protected]> 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= > [email protected]] *On Behalf Of *Maheed Ramadan > *Sent:* Tuesday, August 19, 2014 1:37 PM > *To:* Morten Olav Hansen > *Cc:* dhis2-users; [email protected] > *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:[email protected] <[email protected]>] > > *Sent:* Tuesday, August 19, 2014 12:35 PM > *To:* Maheed Ramadan > *Cc:* dhis2-users; Lars Helge Øverland; [email protected] > *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" <[email protected]> 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= > [email protected]] *On Behalf Of *Maheed Ramadan > *Sent:* Monday, August 18, 2014 2:18 PM > *To:* Knut Staring > *Cc:* [email protected]; [email protected] > *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: [email protected] > > 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:[email protected] <[email protected]>] > *Sent:* Monday, August 18, 2014 1:24 PM > *To:* Maheed Ramadan > *Cc:* [email protected]; Lars Helge Øverland; > [email protected] > *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" <[email protected]> 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 : [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
