dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

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