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.picker...@gmail.com> 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 <dhu...@baosystems.com> > 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.picker...@gmail.com> 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.picker...@gmail.com> 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.picker...@gmail.com >>>> tel:+46764147049 >>>> >>> >>> >>> >>> -- >>> Jason P. Pickering >>> email: jason.p.picker...@gmail.com >>> tel:+46764147049 >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~dhis2-devs >>> Post to : dhis2-devs@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> >> >> -- >> >> >> *David Huser* >> DHIS2 Support Specialist >> dhu...@baosystems.com | https://baosystems.com | 2900 K Street, Suite >> 507, Washington D.C. 20007 >> > > > > -- > Jason P. Pickering > email: jason.p.picker...@gmail.com > tel:+46764147049 > -- *David Huser* DHIS2 Support Specialist dhu...@baosystems.com | https://baosystems.com | 2900 K Street, Suite 507, Washington D.C. 20007
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp