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 moreProcess 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)