Issue with analytics

Support - Assistance technique
1

Hello there,

We are facing issue to generate the analytics.
Here is the attached screenshot and error logs.

image
image1203×330 54.3 KB

34814 sec. (AbstractJdbcTableManager.java [ForkJoinPool-24-worker-3])

  • ERROR 2024-03-05T17:41:16,605 processing aborted: skipped stage, failing item caused abort. parallel processing aborted after 3 successful and 1 failed items (NotificationLoggerUtil.java [taskScheduler-7]) UID:XE7AttncXs4
  • ERROR 2024-03-05T17:41:16,616 [ANALYTICS_TABLE XE7AttncXs4] Stage failed after 1.161s: processing aborted: skipped stage, failing item caused abort. parallel processing aborted after 3 successful and 1 failed items (ControlledJobProgress.java [taskScheduler-7]) UID:XE7AttncXs4
    java.lang.RuntimeException: processing aborted: skipped stage, failing item caused abort. parallel processing aborted after 3 successful and 1 failed items
    at org.hisp.dhis.scheduling.ControlledJobProgress.cancellationAsAbort(ControlledJobProgress.java:347) ~[dhis-service-core-2.40.3.jar:?]
    at org.hisp.dhis.scheduling.ControlledJobProgress.failedStage(ControlledJobProgress.java:210) ~[dhis-service-core-2.40.3.jar:?]
    at org.hisp.dhis.scheduling.JobProgress.autoSkipStage(JobProgress.java:354) ~[dhis-api-2.40.3.jar:?]
    at org.hisp.dhis.scheduling.JobProgress.runStageInParallel(JobProgress.java:480) ~[dhis-api-2.40.3.jar:?]
    at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.populateTables(DefaultAnalyticsTableService.java:213) ~[dhis-service-analytics-2.40.3.jar:?]
    at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(DefaultAnalyticsTableService.java:136) ~[dhis-service-analytics-2.40.3.jar:?]
    at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator.generateTables(DefaultAnalyticsTableGenerator.java:105) ~[dhis-service-analytics-2.40.3.jar:?]
    at org.hisp.dhis.analytics.table.scheduling.AnalyticsTableJob.execute(AnalyticsTableJob.java:69) ~[dhis-service-analytics-2.40.3.jar:?]
    at org.hisp.dhis.scheduling.AbstractSchedulingManager.execute(AbstractSchedulingManager.java:292) ~[dhis-service-core-2.40.3.jar:?]
    at org.hisp.dhis.scheduling.DefaultSchedulingManager.lambda$executeNow$6(DefaultSchedulingManager.java:201) ~[dhis-service-core-2.40.3.jar:?]
    at org.glowroot.agent.plugin.executor.RunnableWrapper.run(RunnableWrapper.java:35) [?:0.14.0]
    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) [spring-context-5.3.31.jar:5.3.31]
    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) [?:?]
  • INFO 2024-03-05T17:41:16,617 Populated analytics tables: 00:00:01.460 (Clock.java [taskScheduler-7]) UID:XE7AttncXs4
  • ERROR 2024-03-05T17:41:16,617 Process failed: java.util.concurrent.CancellationException (NotificationLoggerUtil.java [taskScheduler-7]) UID:XE7AttncXs4
  • ERROR 2024-03-05T17:41:16,618 Job failed: ‘inMemoryAnalyticsJob’ (AbstractSchedulingManager.java [taskScheduler-7]) UID:XE7AttncXs4
    java.util.concurrent.CancellationException: null
    at org.hisp.dhis.scheduling.ControlledJobProgress.startingStage(ControlledJobProgress.java:180) ~[dhis-service-core-2.40.3.jar:?]
    at org.hisp.dhis.scheduling.JobProgress.startingStage(JobProgress.java:172) ~[dhis-api-2.40.3.jar:?]
    at org.hisp.dhis.scheduling.JobProgress.startingStage(JobProgress.java:176) ~[dhis-api-2.40.3.jar:?]
    at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(DefaultAnalyticsTableService.java:139) ~[dhis-service-analytics-2.40.3.jar:?]
    at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator.generateTables(DefaultAnalyticsTableGenerator.java:105) ~[dhis-service-analytics-2.40.3.jar:?]
    at org.hisp.dhis.analytics.table.scheduling.AnalyticsTableJob.execute(AnalyticsTableJob.java:69) ~[dhis-service-analytics-2.40.3.jar:?]
    at org.hisp.dhis.scheduling.AbstractSchedulingManager.execute(AbstractSchedulingManager.java:292) ~[dhis-service-core-2.40.3.jar:?]
    at org.hisp.dhis.scheduling.DefaultSchedulingManager.lambda$executeNow$6(DefaultSchedulingManager.java:201) ~[dhis-service-core-2.40.3.jar:?]
    at org.glowroot.agent.plugin.executor.RunnableWrapper.run(RunnableWrapper.java:35) [?:0.14.0]
    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) [spring-context-5.3.31.jar:5.3.31]
    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) [?:?]
  • ERROR 2024-03-05T17:41:16,618 java.util.concurrent.CancellationException
    at org.hisp.dhis.scheduling.ControlledJobProgress.startingStage(ControlledJobProgress.java:180)
    at org.hisp.dhis.scheduling.JobProgress.startingStage(JobProgress.java:172)
    at org.hisp.dhis.scheduling.JobProgress.startingStage(JobProgress.java:176)
    at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(DefaultAnalyticsTableService.java:139)
    at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator.generateTables(DefaultAnalyticsTableGenerator.java:105)
    at org.hisp.dhis.analytics.table.scheduling.AnalyticsTableJob.execute(AnalyticsTableJob.java:69)
    at org.hisp.dhis.scheduling.AbstractSchedulingManager.execute(AbstractSchedulingManager.java:292)
    at org.hisp.dhis.scheduling.DefaultSchedulingManager.lambda$executeNow$6(DefaultSchedulingManager.java:201)
    at org.glowroot.agent.plugin.executor.RunnableWrapper.run(RunnableWrapper.java:35)
    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-7]) UID:XE7AttncXs4

Thanks

2

Hello There,

I have downgraded the postgesql version 13, earlier it was 14 and now analytics working fine. Don’t know what was the issue. Fyi, we are using dhis2 version 2.40.3.

Thanks

1 Like