Hi @here got this error when running analytics. Any fix around this?
ERROR 2023-06-08T08:23:20,984 [ANALYTICS_TABLE VOL6oRHxvPv] Item failed after 0.465s: java.lang.NullPointerException (ControlledJobProgress.java [taskScheduler-14]) UID:VOL6oRHxvPv java.lang.NullPointerException: null * ERROR 2023-06-08T08:23:20,984 processing aborted: cancelled as failing item caused request for cancellation (NotificationLoggerUtil.java [taskScheduler-14]) UID:VOL6oRHxvPv * ERROR 2023-06-08T08:23:20,984 [ANALYTICS_TABLE VOL6oRHxvPv] Stage failed after 0.466s: processing aborted: cancelled as failing item caused request for cancellation (ControlledJobProgress.java [taskScheduler-14]) UID:VOL6oRHxvPv java.lang.RuntimeException: processing aborted: cancelled as failing item caused request for cancellation at org.hisp.dhis.scheduling.ControlledJobProgress.cancellationAsAbort(ControlledJobProgress.java:339) ~[dhis-service-core-2.38.2.1-SNAPSHOT.jar:?] at org.hisp.dhis.scheduling.ControlledJobProgress.failedStage(ControlledJobProgress.java:211) ~[dhis-service-core-2.38.2.1-SNAPSHOT.jar:?] at org.hisp.dhis.scheduling.JobProgress.runStage(JobProgress.java:309) ~[dhis-api-2.38.2.1-SNAPSHOT.jar:?] at org.hisp.dhis.scheduling.JobProgress.runStage(JobProgress.java:254) ~[dhis-api-2.38.2.1-SNAPSHOT.jar:?] at org.hisp.dhis.scheduling.JobProgress.runStage(JobProgress.java:243) ~[dhis-api-2.38.2.1-SNAPSHOT.jar:?] at org.hisp.dhis.scheduling.JobProgress.runStage(JobProgress.java:225) ~[dhis-api-2.38.2.1-SNAPSHOT.jar:?] at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator.generateResourceTablesInternal(DefaultAnalyticsTableGenerator.java:201) ~[dhis-service-analytics-2.38.2.1-SNAPSHOT.jar:?] at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator.generateTables(DefaultAnalyticsTableGenerator.java:103) ~[dhis-service-analytics-2.38.2.1-SNAPSHOT.jar:?] at org.hisp.dhis.analytics.table.scheduling.AnalyticsTableJob.execute(AnalyticsTableJob.java:82) ~[dhis-service-analytics-2.38.2.1-SNAPSHOT.jar:?] at org.hisp.dhis.scheduling.AbstractSchedulingManager.execute(AbstractSchedulingManager.java:277) ~[dhis-service-core-2.38.2.1-SNAPSHOT.jar:?] at org.hisp.dhis.scheduling.DefaultSchedulingManager.lambda$executeNow$4(DefaultSchedulingManager.java:184) ~[dhis-service-core-2.38.2.1-SNAPSHOT.jar:?] at org.hisp.dhis.scheduling.DefaultSchedulingManager.lambda$runIfPossible$5(DefaultSchedulingManager.java:212) ~[dhis-service-core-2.38.2.1-SNAPSHOT.jar:?] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?] at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?] at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) [spring-context-5.3.23.jar:5.3.23] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?] at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304) [?:?] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?] at java.lang.Thread.run(Thread.java:829) [?:?] * ERROR 2023-06-08T08:23:20,986 Analytics table process failed: java.util.concurrent.CancellationException at org.hisp.dhis.scheduling.ControlledJobProgress.startingStage(ControlledJobProgress.java:182) at org.hisp.dhis.resourcetable.DefaultResourceTableService.createAllSqlViews(DefaultResourceTableService.java:218) at jdk.internal.reflect.GeneratedMethodAccessor2443.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208) at com.sun.proxy.$Proxy345.createAllSqlViews(Unknown Source) at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator.generateResourceTablesInternal(DefaultAnalyticsTableGenerator.java:203) at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator.generateTables(DefaultAnalyticsTableGenerator.java:103) at org.hisp.dhis.analytics.table.scheduling.AnalyticsTableJob.execute(AnalyticsTableJob.java:82) at org.hisp.dhis.scheduling.AbstractSchedulingManager.execute(AbstractSchedulingManager.java:277) at org.hisp.dhis.scheduling.DefaultSchedulingManager.lambda$executeNow$4(DefaultSchedulingManager.java:184) at org.hisp.dhis.scheduling.DefaultSchedulingManager.lambda$runIfPossible$5(DefaultSchedulingManager.java:212) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) (DefaultAnalyticsTableGenerator.java [taskScheduler-14]) UID:VOL6oRHxvPv java.util.concurrent.CancellationException: null at org.hisp.dhis.scheduling.ControlledJobProgress.startingStage(ControlledJobProgress.java:182) ~[dhis-service-core-2.38.2.1-SNAPSHOT.jar:?] at org.hisp.dhis.resourcetable.DefaultResourceTableService.createAllSqlViews(DefaultResourceTableService.java:218) ~[dhis-service-administration-2.38.2.1-SNAPSHOT.jar:?] at jdk.internal.reflect.GeneratedMethodAccessor2443.invoke(Unknown Source) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?] at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) ~[spring-aop-5.3.23.jar:5.3.23] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208) ~[spring-aop-5.3.23.jar:5.3.23] at com.sun.proxy.$Proxy345.createAllSqlViews(Unknown Source) ~[?:?] at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator.generateResourceTablesInternal(DefaultAnalyticsTableGenerator.java:203) ~[dhis-service-analytics-2.38.2.1-SNAPSHOT.jar:?] at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator.generateTables(DefaultAnalyticsTableGenerator.java:103) ~[dhis-service-analytics-2.38.2.1-SNAPSHOT.jar:?] at org.hisp.dhis.analytics.table.scheduling.AnalyticsTableJob.execute(AnalyticsTableJob.java:82) ~[dhis-service-analytics-2.38.2.1-SNAPSHOT.jar:?] at org.hisp.dhis.scheduling.AbstractSchedulingManager.execute(AbstractSchedulingManager.java:277) ~[dhis-service-core-2.38.2.1-SNAPSHOT.jar:?] at org.hisp.dhis.scheduling.DefaultSchedulingManager.lambda$executeNow$4(DefaultSchedulingManager.java:184) ~[dhis-service-core-2.38.2.1-SNAPSHOT.jar:?] at org.hisp.dhis.scheduling.DefaultSchedulingManager.lambda$runIfPossible$5(DefaultSchedulingManager.java:212) ~[dhis-service-core-2.38.2.1-SNAPSHOT.jar:?] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?] at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?] at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) [spring-context-5.3.23.jar:5.3.23] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?] at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304) [?:?] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?] at java.lang.Thread.run(Thread.java:829) [?:?] * ERROR 2023-06-08T08:23:21,058 Process failed: java.util.concurrent.CancellationException (NotificationLoggerUtil.java [taskScheduler-14]) UID:VOL6oRHxvPv * ERROR 2023-06-08T08:23:21,062 Process failed: java.util.concurrent.CancellationException (NotificationLoggerUtil.java [taskScheduler-14]) UID:VOL6oRHxvPv * ERROR 2023-06-08T08:23:21,062 Job failed: ‘inMemoryAnalyticsJob’ (AbstractSchedulingManager.java [taskScheduler-14]) UID:VOL6oRHxvPv java.util.concurrent.CancellationException: null at org.hisp.dhis.scheduling.ControlledJobProgress.startingStage(ControlledJobProgress.java:182) ~[dhis-service-core-2.38.2.1-SNAPSHOT.jar:?] at org.hisp.dhis.resourcetable.DefaultResourceTableService.createAllSqlViews(DefaultResourceTableService.java:218) ~[dhis-service-administration-2.38.2.1-SNAPSHOT.jar:?] at jdk.internal.reflect.GeneratedMethodAccessor2443.invoke(Unknown Source) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?] at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) ~[spring-aop-5.3.23.jar:5.3.23] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208) ~[spring-aop-5.3.23.jar:5.3.23] at com.sun.proxy.$Proxy345.createAllSqlViews(Unknown Source) ~[?:?] at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator.generateResourceTablesInternal(DefaultAnalyticsTableGenerator.java:203) ~[dhis-service-analytics-2.38.2.1-SNAPSHOT.jar:?] at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator.generateTables(DefaultAnalyticsTableGenerator.java:103) ~[dhis-service-analytics-2.38.2.1-SNAPSHOT.jar:?] at org.hisp.dhis.analytics.table.scheduling.AnalyticsTableJob.execute(AnalyticsTableJob.java:82) ~[dhis-service-analytics-2.38.2.1-SNAPSHOT.jar:?] at org.hisp.dhis.scheduling.AbstractSchedulingManager.execute(AbstractSchedulingManager.java:277) ~[dhis-service-core-2.38.2.1-SNAPSHOT.jar:?] at org.hisp.dhis.scheduling.DefaultSchedulingManager.lambda$executeNow$4(DefaultSchedulingManager.java:184) ~[dhis-service-core-2.38.2.1-SNAPSHOT.jar:?] at org.hisp.dhis.scheduling.DefaultSchedulingManager.lambda$runIfPossible$5(DefaultSchedulingManager.java:212) ~[dhis-service-core-2.38.2.1-SNAPSHOT.jar:?] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?] at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?] at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) [spring-context-5.3.23.jar:5.3.23] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?] at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304) [?:?] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?] at java.lang.Thread.run(Thread.java:829) [?:?] * ERROR 2023-06-08T08:23:21,065 java.util.concurrent.CancellationException at org.hisp.dhis.scheduling.ControlledJobProgress.startingStage(ControlledJobProgress.java:182) at org.hisp.dhis.resourcetable.DefaultResourceTableService.createAllSqlViews(DefaultResourceTableService.java:218) at jdk.internal.reflect.GeneratedMethodAccessor2443.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208) at com.sun.proxy.$Proxy345.createAllSqlViews(Unknown Source) at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator.generateResourceTablesInternal(DefaultAnalyticsTableGenerator.java:203) at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator.generateTables(DefaultAnalyticsTableGenerator.java:103) at org.hisp.dhis.analytics.table.scheduling.AnalyticsTableJob.execute(AnalyticsTableJob.java:82) at org.hisp.dhis.scheduling.AbstractSchedulingManager.execute(AbstractSchedulingManager.java:277) at org.hisp.dhis.scheduling.DefaultSchedulingManager.lambda$executeNow$4(DefaultSchedulingManager.java:184) at org.hisp.dhis.scheduling.DefaultSchedulingManager.lambda$runIfPossible$5(DefaultSchedulingManager.java:212) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) (AbstractSchedulingManager.java [taskScheduler-14]) UID:VOL6oRHxvPv