Task queue is not getting executed in 9.24.25

0
Hi All,   Hope you are doing good.    I have recently moved one of my application from 8.18.19 to 9.24.25. We have a task queue microflow that needs to be executed when we click on the button, but it is not being processed when the click is supposed to complete the microflow process. I see that other system-based task queues are showing the following error, and my custom task queue microflow is not progressing to the running stage. Can you please let me know why my custom task queue is not being executed? I assume this is happening because the other system task queues have stopped due to a deadlock.   com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"type":"DeleteAction"}', all database changes executed by this action were rolled back at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:110) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"type":"DeleteAction"}', 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 '{"type":"DeleteAction"}', all database changes executed by this action were rolled back at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.processErrorState(CoreActionHandlerImpl.scala:153) Caused by: com.mendix.datastorage.exception.UpdateConflictException at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.withPreparedStatement(JdbcDataStore.scala:1102) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.$anonfun$execModificationQueries$1(JdbcDataStore.scala:848) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.$anonfun$execModificationQueries$1$adapted(JdbcDataStore.scala:848) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.$anonfun$executeWithUcViolationHandling$1(JdbcDataStore.scala:1014) at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.scala:18)     Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 53) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:261)
asked
1 answers
0

In this Q&A of 2 years ago where someone had a similar issue, the solution was as follows:

 

- Put "Concurrent execution > Disallow" to yes and adapt Error message

- Disable during action buttons that use this microflow

 

Try and see if this works for your situation as well

answered