← Back to team overview

dhis2-users team mailing list archive

Analytics table process failed - ConcurrentUtils.waitForCompletion - NullPointerException

 

Hello,
 
From some time, our server don’t finish the analytics properly ( even if in the interface, a “analytics failed” message is shown, most of the tables/graphs are updated but, for example, old data are not always deleted/updated (not sure 100% if related)).
 
Please, see attached, the log and the messageConversation info.
 
Any idea ? 
 
Thanks !
 
Ramón José JIMÉNEZ POMARETA
IT Consultant
Innovative and Intensified Disease Management Unit 
Department of Neglected Tropical Diseases (CDS/NTD/IDM)
Leishmaniasis Control Programme
WHO/HQ  Geneva
Avenue Appia 20
CH-1211 Geneva 27
pomaretar@xxxxxxx
 
[who]
 


PNG image

* INFO  2018-04-09 16:08:31,432 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Mon Apr 09 16:08:31 CEST 2018, message: Applying aggregation levels] (InMemoryNotifier.java [taskScheduler-11])
* INFO  2018-04-09 16:08:31,432 [Level: ERROR, category: ANALYTICSTABLE_UPDATE, time: Mon Apr 09 16:08:31 CEST 2018, message: Process failed: null] (InMemoryNotifier.java [taskScheduler-11])
* INFO  2018-04-09 16:08:31,488 'system-process' create org.hisp.dhis.message.MessageConversation, name: Analytics table process failed, uid: nA5vaakt6OM (AuditLogUtil.java [taskScheduler-11])
* INFO  2018-04-09 16:08:31,493 no recipient (SmsMessageSender.java [taskScheduler-11])
* ERROR 2018-04-09 16:08:31,502 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-11])
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:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:745)
 messageid |         created         |                messagetext                 | internal | metadata |            subject             | priority | status | messagetype
-----------+-------------------------+--------------------------------------------+----------+----------+--------------------------------+----------+--------+-------------
    225158 | 2018-04-09 16:08:31.488 | Analytics table process failed            +| f        |          | Analytics table process failed | NONE     | NONE   | SYSTEM
           |                         |                                           +|          |          |                                |          |        |
           |                         | System title: WHO Integrated data platform+|          |          |                                |          |        |
           |                         | Base URL: null                            +|          |          |                                |          |        |
           |                         | Time: 2018-04-09T16:08:31.484+02:00       +|          |          |                                |          |        |
           |                         | Message: null                             +|          |          |                                |          |        |
           |                         |                                           +|          |          |                                |          |        |
           |                         | Cause:                                     |          |          |                                |          |        |
(1 row)