← Back to team overview

dhis2-devs team mailing list archive

Re: FW: Problem generating reporting & analytics tables. (dhis 2.16)

 

Great.
On Sep 1, 2014 10:52 AM, "Maheed Ramadan" <maheed.ramadan@xxxxxx> 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.no@xxxxxxxxxxxxxxxxxxx] *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" <knutst@xxxxxxxxx> 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 <mortenoh@xxxxxxxxx>
> 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.ramadan@xxxxxx>
> 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.no@xxxxxxxxxxxxxxxxxxx] *On Behalf Of *Maheed Ramadan
> *Sent:* Tuesday, August 19, 2014 1:37 PM
> *To:* Morten Olav Hansen
> *Cc:* dhis2-users; dhis2-devs@xxxxxxxxxxxxxxxxxxx
> *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:mortenoh@xxxxxxxxx <mortenoh@xxxxxxxxx>]
>
> *Sent:* Tuesday, August 19, 2014 12:35 PM
> *To:* Maheed Ramadan
> *Cc:* dhis2-users; Lars Helge Øverland; dhis2-devs@xxxxxxxxxxxxxxxxxxx
> *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.ramadan@xxxxxx> 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.no@xxxxxxxxxxxxxxxxxxx] *On Behalf Of *Maheed Ramadan
> *Sent:* Monday, August 18, 2014 2:18 PM
> *To:* Knut Staring
> *Cc:* dhis2-users@xxxxxxxxxxxxxxxxxxx; dhis2-devs@xxxxxxxxxxxxxxxxxxx
> *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.ramadan@xxxxxx
>
> 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:knutst@xxxxxxxxx <knutst@xxxxxxxxx>]
> *Sent:* Monday, August 18, 2014 1:24 PM
> *To:* Maheed Ramadan
> *Cc:* dhis2-users@xxxxxxxxxxxxxxxxxxx; Lars Helge Øverland;
> dhis2-devs@xxxxxxxxxxxxxxxxxxx
> *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.ramadan@xxxxxx> 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-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> 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-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>

PNG image

GIF image


References