Scheduler RUNNING ERROR

0
My project application has multiple Schedule events and Task queues in execution, and I often encounter the following errors without knowing where the problem is. How do I need to investigate it.   ERROR LOGS:   ERROR - TaskQueue: Failed to execute task 'SPV_API.ACT_GetAssociateToSPV()' from task queue 'TaskQueueScheduler.ScheduleQueue_3'.com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"current_activity_id":"b5340954-3905-4366-809f-4a67aac023dd","current_activity":{"type":"End"},"name":"SPV_API.ACT_GetAssociateToSPV","type":"Microflow"}', all database changes executed by this action were rolled back    at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:109) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"current_activity_id":"b5340954-3905-4366-809f-4a67aac023dd","current_activity":{"type":"End"},"name":"SPV_API.ACT_GetAssociateToSPV","type":"Microflow"}', all database changes executed by this action were rolled back    at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:23) Caused by: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"current_activity_id":"b5340954-3905-4366-809f-4a67aac023dd","current_activity":{"type":"End"},"name":"SPV_API.ACT_GetAssociateToSPV","type":"Microflow"}', all database changes executed by this action were rolled back    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.processErrorState(CoreActionHandlerImpl.scala:153) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: Autocommitted objects detected at end of transaction for system session for entities:  - SPV_Main.SPVPriceType: 1 instances - SPV_Main.WorkSpace: 1 instances - SPV_Main.SPVProjected: 1 instances    at com.mendix.basis.action.RequestScope.$anonfun$endTransaction$3(RequestScope.scala:163)    at scala.Option.foreach(Option.scala:437)    at com.mendix.basis.action.RequestScope.verifyNoAutoCommitsExist$1(RequestScope.scala:156)    at com.mendix.basis.action.RequestScope.$anonfun$endTransaction$7(RequestScope.scala:171)    at com.mendix.basis.action.RequestScope.$anonfun$endTransaction$7$adapted(RequestScope.scala:166)    at scala.Option.foreach(Option.scala:437)    at com.mendix.basis.action.RequestScope.endTransaction(RequestScope.scala:166)    at com.mendix.basis.action.ContextImpl.endTransaction(ContextImpl.scala:76)    at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.scala:131)    at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:58)    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71)    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:48)    at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.java:57)    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.$anonfun$runMonitoredAction$1(CoreActionHandlerImpl.scala:59)    at com.mendix.basis.actionmanagement.ActionMonitoring$.$anonfun$monitor$1(ActionMonitoring.scala:52)    at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20)    at com.mendix.basis.actionmanagement.ActionMonitoring$.monitor(ActionMonitoring.scala:52)    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.runMonitoredAction(CoreActionHandlerImpl.scala:59)    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:46)    at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.java:57)    at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeSync$2(ActionManager.scala:105)    at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20)    at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:104)    at com.mendix.basis.actionmanagement.MicroflowCallBuilderImpl.execute(MicroflowCallBuilderImpl.scala:64)    at com.mendix.modules.queue.MicroflowTask.$anonfun$execute$1(MicroflowTask.scala:34)    at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.scala:18)    at scala.util.Try$.apply(Try.scala:217)    at com.mendix.modules.queue.MicroflowTask.execute(MicroflowTask.scala:31)    at com.mendix.modules.queue.TaskDispatcher.executeTask(TaskDispatcher.scala:232)    at com.mendix.modules.queue.TaskDispatcher.$anonfun$dispatchTask$2(TaskDispatcher.scala:212)    at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.scala:18)    at com.mendix.modules.queue.MendixTaskQueueMetrics$QueueBasedMetricsImpl.$anonfun$timeTaskExecution$1(TaskQueueMetrics.scala:44)    at io.micrometer.core.instrument.composite.CompositeTimer.record(CompositeTimer.java:69)    at com.mendix.metrics.micrometer.MicrometerTimer.record(MicrometerTimer.scala:29)    at com.mendix.modules.queue.MendixTaskQueueMetrics$QueueBasedMetricsImpl.timeTaskExecution(TaskQueueMetrics.scala:44)    at com.mendix.modules.queue.TaskDispatcher.$anonfun$dispatchTask$1(TaskDispatcher.scala:212)    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)
asked
1 answers
0

Hello Shandong,

 

A start is to manually trigger the taskqueue and debug the flows, especially the flow that is throwing the error : ACT_GetAssociateToSPV

 

Hope this helps,

 

Good luck!

answered