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 pomare...@who.int [who]
* 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)
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp