← Back to team overview

dhis2-devs team mailing list archive

Re: Error in analytics table generation

 

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

Follow ups

References