dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

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
>
>