Re: [Dhis2-users] [Dhis2-devs] FW: Problem generating reporting & analytics tables. (dhis 2.16)

2014-08-19 Thread Morten Olav Hansen 
Hi Maheed

I will have a look at it and get back to you.
On Aug 19, 2014 4:21 PM, "Maheed Ramadan"  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 ]
> *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"  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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] FW: Problem generating reporting & analytics tables. (dhis 2.16)

2014-08-19 Thread Maheed Ramadan 
Thanks Morten.

I appreciate your help.


From: Morten Olav Hansen [mailto: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" 
mailto: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 (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

[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]
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" 
mailto: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 (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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help

Re: [Dhis2-users] [Dhis2-devs] FW: Problem generating reporting & analytics tables. (dhis 2.16)

2014-08-19 Thread Maheed Ramadan 
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



[cid:image002.png@01CFBC4A.08CE66E0]


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]
Sent: Tuesday, August 19, 2014 12:35 PM
To: Maheed Ramadan
Cc: dhis2-users; Lars Helge Øverland; 
dhis2-d...@lists.launchpad.net<mailto: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" 
mailto: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 (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<mailto:dhis2-devs-bounces%2Bmaheed.ramadan>=nrc...@lists.launchpad.net<mailto: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<mailto:dhis2-users@lists.launchpad.net>; 
dhis2-d...@lists.launchpad.net<mailto: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<mailto:maheed.rama...@nrc.no>
Skype: mr_maheed
Mobile: 70-888037
Website : www.nrc.no<http://www.nrc.no/>

[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]
Sent: Monday, August 18, 2014 1:24 PM
To: Maheed Ramadan
Cc: dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>; 
Lars Helge Øverland; 
dhis2-d...@lists.launchpad.net<mailto: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" 
mailto: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

Re: [Dhis2-users] [Dhis2-devs] FW: Problem generating reporting & analytics tables. (dhis 2.16)

2014-08-19 Thread Morten Olav Hansen 
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 
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 ]
>
> *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"  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 ]
> *Sent:* Monday, August 18, 2014 1:24 PM
> *To:* Maheed Ramada

Re: [Dhis2-users] [Dhis2-devs] FW: Problem generating reporting & analytics tables. (dhis 2.16)

2014-09-01 Thread Knut Staring 
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 
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 
> 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
>> ]
>> *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"  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

Re: [Dhis2-users] [Dhis2-devs] FW: Problem generating reporting & analytics tables. (dhis 2.16)

2014-09-01 Thread Lars Helge Øverland 
Hi Maheeed,

Let us know if it works as expected on your side..

regards,

Lars
On Sep 1, 2014 9:31 AM, "Knut Staring"  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 
> 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 
>> 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
>>> ]
>>> *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"  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 Sta

Re: [Dhis2-users] [Dhis2-devs] FW: Problem generating reporting & analytics tables. (dhis 2.16)

2014-09-01 Thread Maheed Ramadan 
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" 
mailto: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 
mailto: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 
mailto: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



[cid:image001.png@01CFC5DB.349DCBE0]


Thank you.

Maheed



From: Dhis2-users 
[mailto:dhis2-users-bounces+maheed.ramadan<mailto:dhis2-users-bounces%2Bmaheed.ramadan>=nrc...@lists.launchpad.net<mailto: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<mailto: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]
Sent: Tuesday, August 19, 2014 12:35 PM
To: Maheed Ramadan
Cc: dhis2-users; Lars Helge Øverland; 
dhis2-d...@lists.launchpad.net<mailto: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" 
mailto: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 (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<mailto:dhis2-devs-bounces%2Bmaheed.ramadan>=nrc...@lists.launchpad.net<mailto: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<mailto:dhis2-users@lists.launchpad.net>; 
dhis2-d...@lists.launchpad.net<mailto: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<mailto:maheed.rama...@nrc.no>
Skype: mr_maheed
Mobile: 70-888037
Website : www.n

Re: [Dhis2-users] [Dhis2-devs] FW: Problem generating reporting & analytics tables. (dhis 2.16)

2014-09-01 Thread Lars Helge Øverland 
Great.
On Sep 1, 2014 10:52 AM, "Maheed Ramadan"  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"  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 
> 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 
> 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 ]
>
> *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"  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. Ho