dhis2-devs team mailing list archive

[David Huser <dhuser@xxxxxxxxxxxxxx>]

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