← Back to team overview

dhis2-devs team mailing list archive

Re: Error in analytics table generation

 

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.a
>>>>> pplyAggregationLevels(DefaultAnalyticsTableService.java:242)
>>>>> at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.u
>>>>> pdate(DefaultAnalyticsTableService.java:137)
>>>>> at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator
>>>>> .generateTables(DefaultAnalyticsTableGenerator.java:112)
>>>>> at org.hisp.dhis.webapi.controller.ResourceTableController.lamb
>>>>> da$analytics$0(ResourceTableController.java:112)
>>>>> at org.springframework.scheduling.support.DelegatingErrorHandli
>>>>> ngRunnable.run(DelegatingErrorHandlingRunnable.java:54)
>>>>> at java.util.concurrent.Executors$RunnableAdapter.call(Executor
>>>>> s.java:511)
>>>>> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
>>>>> at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFu
>>>>> tureTask.access$201(ScheduledThreadPoolExecutor.java:180)
>>>>> at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFu
>>>>> tureTask.run(ScheduledThreadPoolExecutor.java:293)
>>>>> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool
>>>>> Executor.java:1149)
>>>>> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo
>>>>> lExecutor.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

Follow ups

References