Analytics error: Process failed: Exception during execution

Hi,
We recently created an event and imported some data values for it. When we try to run analytics, the following error shows up: Process failed: Exception during execution
I tried to clear analytics tables and run analytics again but its not improving.

When I went through the log files, these are the snippets I could identify to be the problem:

[Level: ERROR, category: ANALYTICS_TABLE, time: Wed Nov 20 15:06:51 WAT 2019, message: Process failed: Exception during execution] (InMemoryNotifier.java [taskScheduler-11])

  • INFO 2019-11-20 15:06:51,322 ‘system-process’ create org.hisp.dhis.message.MessageConversation, name: Analytics table process failed, uid: V6HuTtSrsua (AuditLogUtil.java [taskScheduler-11])
  • INFO 2019-11-20 15:06:51,329 no recipient (SmsMessageSender.java [taskScheduler-26])
  • INFO 2019-11-20 15:06:51,356 ‘system-process’ create org.hisp.dhis.message.MessageConversation, name: Job ‘inMemoryAnalyticsJob’ failed, uid: oJ3wxxN7wsv (AuditLogUtil.java [taskScheduler-11])
  • INFO 2019-11-20 15:06:51,359 no recipient (SmsMessageSender.java [taskScheduler-6])
  • ERROR 2019-11-20 15:06:51,371 Job ‘inMemoryAnalyticsJob’ failed (DefaultJobInstance.java [taskScheduler-11])
    java.lang.RuntimeException: Exception during execution
    at org.hisp.dhis.commons.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:63)
    at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.populateTables(DefaultAnalyticsTableService.java:254)
    at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(DefaultAnalyticsTableService.java:149)
    at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator.generateTables(DefaultAnalyticsTableGenerator.java:114)
    at org.hisp.dhis.analytics.table.scheduling.AnalyticsTableJob.execute(AnalyticsTableJob.java:70)
    at org.hisp.dhis.scheduling.DefaultJobInstance.executeJob(DefaultJobInstance.java:155)
    at org.hisp.dhis.scheduling.DefaultJobInstance.execute(DefaultJobInstance.java:69)
    at org.hisp.dhis.scheduling.DefaultSchedulingManager.lambda$internalExecuteJobConfiguration$3(DefaultSchedulingManager.java:280)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    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:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
    Caused by: java.util.concurrent.ExecutionException: org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL

And this:

ERROR: object value separator ‘,’ expected (at offset 49)
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:192)
at org.hisp.dhis.commons.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:59)
… 17 more

1:18 PM

Process failed: Exception during execution

I have attached the log file for your reference. Please advise on how to resolve this.
Thank you.log files 20-11-19.pdf (1.1 MB)

1 Like

Hello, please let me know which version of the application is the problem related to.

Thanks

1 Like

Hello @luciano,
Thanks for the reply. This was encountered on version 2.31.

1 Like