← Back to team overview

dhis2-devs team mailing list archive

Re: Error in analytics table generation

 

Hi Jason,
It was solved. Just download last build.

You can take look at jira issue created for that here
https://jira.dhis2.org/browse/DHIS2-2788

Le ven. 27 avr. 2018 à 13:33, Jason Pickering <jason.p.pickering@xxxxxxxxx>
a écrit :

> Yeah, it seems to be the exact same problem.
>
> Olav Poppe did you manage to resolve this? If so, how?
>
> Regards,
> Jason
>
>
> On Fri, Apr 27, 2018 at 11:40 AM, David Huser <dhuser@xxxxxxxxxxxxxx>
> wrote:
>
>> Hi Jason,
>>
>> Some of the expressions were simply empty (perhaps the cause for
>> NullPointerExceptions). The exact problem for those that are *not* empty
>> is still to be determined (lots of validation rules to check).
>> Here was a similar thread from December:
>> https://lists.launchpad.net/dhis2-devs/msg50471.html
>>
>> David
>>
>> On Fri, Apr 27, 2018 at 11:04 AM, Jason Pickering <
>> jason.p.pickering@xxxxxxxxx> wrote:
>>
>>> Hi David,
>>>
>>> Could you give a bit more detail as to what invalid means and how you
>>> identified that they were invalid?
>>>
>>> Regards,
>>> Jason
>>>
>>>
>>> On Fri, Apr 27, 2018 at 10:32 AM, David Huser <dhuser@xxxxxxxxxxxxxx>
>>> wrote:
>>>
>>>> Hi Jason,
>>>>
>>>> Had to look into this recently as well - after fixing validation rules
>>>> with invalid expressions this error went away. Those violations did not
>>>> show up in Integrity Check however.
>>>>
>>>> David
>>>>
>>>> On Fri, Apr 27, 2018 at 10:04 AM, Jason Pickering <
>>>> jason.p.pickering@xxxxxxxxx> wrote:
>>>>
>>>>> A little more detail here. This actually occurs during this phase of
>>>>> analytics which was not clear from the previous message.
>>>>>
>>>>> 2018-04-27 09:17:13 Process failed: null
>>>>> 2018-04-27 09:17:13 Applying aggregation levels
>>>>> 2018-04-27 09:17:13 Populating analytics tables
>>>>> 2018-04-27 09:17:13 Creating analytics tables
>>>>> 2018-04-27 09:17:13 Performing pre-create table work, org unit
>>>>> levels: 7
>>>>> 2018-04-27 09:17:13 Updating tables: VALIDATION_RESULT
>>>>>
>>>>> On Fri, Apr 27, 2018 at 8:04 AM, Jason Pickering <
>>>>> jason.p.pickering@xxxxxxxxx> wrote:
>>>>>
>>>>>> Not exactly sure what is causing this, but this is occurring just at
>>>>>> the end of the analytics tables process. Here is what we see from the GUI:
>>>>>> 2018-04-27 08:00:17 Process failed: null
>>>>>> 2018-04-27 08:00:17 Applying aggregation levels
>>>>>> 2018-04-27 08:00:17 Populating analytics tables
>>>>>> And the error logs
>>>>>>
>>>>>> * ERROR 2018-04-27 08:00:17,796 Unexpected error occurred in
>>>>>> scheduled task. (TaskUtils.java [taskScheduler-25])
>>>>>> java.lang.NullPointerException
>>>>>> at
>>>>>> org.hisp.dhis.commons.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:53)
>>>>>> at
>>>>>> org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.applyAggregationLevels(DefaultAnalyticsTableService.java:242)
>>>>>> at
>>>>>> org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(DefaultAnalyticsTableService.java:137)
>>>>>> at
>>>>>> org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator.generateTables(DefaultAnalyticsTableGenerator.java:112)
>>>>>> at
>>>>>> org.hisp.dhis.webapi.controller.ResourceTableController.lambda$analytics$0(ResourceTableController.java:112)
>>>>>> at
>>>>>> org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
>>>>>> at
>>>>>> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
>>>>>> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
>>>>>> at
>>>>>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
>>>>>> at
>>>>>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
>>>>>> at
>>>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>>>>>> at
>>>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>>>>>> at java.lang.Thread.run(Thread.java:748)
>>>>>> * INFO  2018-04-27 08:00:18,597 Email sent using host: 127.0.0.1:25
>>>>>> with TLS: true (EmailMessageSender.java [taskScheduler-10])
>>>>>>
>>>>>> Version:2.28Build revision:86937e9
>>>>>> Any idea what this might be caused by?
>>>>>>
>>>>>> Regards,
>>>>>> Jason
>>>>>>
>>>>>> --
>>>>>> Jason P. Pickering
>>>>>> email: jason.p.pickering@xxxxxxxxx
>>>>>> tel:+46764147049
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Jason P. Pickering
>>>>> email: jason.p.pickering@xxxxxxxxx
>>>>> tel:+46764147049
>>>>>
>>>>> _______________________________________________
>>>>> 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
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>>
>>>>
>>>> *David Huser*
>>>> DHIS2 Support Specialist
>>>> dhuser@xxxxxxxxxxxxxx | https://baosystems.com |  2900 K Street, Suite
>>>> 507, Washington D.C. 20007
>>>>
>>>
>>>
>>>
>>> --
>>> Jason P. Pickering
>>> email: jason.p.pickering@xxxxxxxxx
>>> tel:+46764147049
>>>
>>
>>
>>
>> --
>>
>>
>> *David Huser*
>> DHIS2 Support Specialist
>> dhuser@xxxxxxxxxxxxxx | https://baosystems.com |  2900 K Street, Suite
>> 507, Washington D.C. 20007
>>
>
>
>
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+46764147049
> _______________________________________________
> 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
>

References