Hi @filiphr, Thank you very much. Unfortunately when the duplicate active tasks got created, no logs related were found. The exceptions came later when we try to claim the task or execute the task. Please see them below.
For Claim Task:
{
"instant":{
"epochSecond":1724155000,
"nanoOfSecond":620888230
},
"thread":"https-jsse-nio-8080-exec-9",
"level":"ERROR",
"loggerName":"org.flowable.common.engine.impl.interceptor.CommandContext",
"message":"Error while closing command context",
"thrown":{
"commonElementCount":0,
"localizedMessage":"\n### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (FLOWABLE.SYS_C008559) violated\n\n### The error may exist in org/flowable/db/mapping/entity/ActivityInstance.xml\n### The error may involve org.flowable.engine.impl.persistence.entity.ActivityInstanceEntityImpl.insertActivityInstance-Inline\n### The error occurred while setting parameters\n### SQL: insert into ACT_RU_ACTINST ( ID_, REV_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_ID_, TASK_ID_, CALL_PROC_INST_ID_, ACT_NAME_, ACT_TYPE_, ASSIGNEE_, START_TIME_, END_TIME_, TRANSACTION_ORDER_, DURATION_, DELETE_REASON_, TENANT_ID_ ) values ( ?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )\n### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (FLOWABLE.SYS_C008559) violated\n",
"message":"\n### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (FLOWABLE.SYS_C008559) violated\n\n### The error may exist in org/flowable/db/mapping/entity/ActivityInstance.xml\n### The error may involve org.flowable.engine.impl.persistence.entity.ActivityInstanceEntityImpl.insertActivityInstance-Inline\n### The error occurred while setting parameters\n### SQL: insert into ACT_RU_ACTINST ( ID_, REV_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_ID_, TASK_ID_, CALL_PROC_INST_ID_, ACT_NAME_, ACT_TYPE_, ASSIGNEE_, START_TIME_, END_TIME_, TRANSACTION_ORDER_, DURATION_, DELETE_REASON_, TENANT_ID_ ) values ( ?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )\n### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (FLOWABLE.SYS_C008559) violated\n",
"name":"org.apache.ibatis.exceptions.PersistenceException",
"cause":{
"commonElementCount":193,
"localizedMessage":"ORA-00001: unique constraint (FLOWABLE.SYS_C008559) violated\n",
"message":"ORA-00001: unique constraint (FLOWABLE.SYS_C008559) violated\n",
"name":"java.sql.SQLIntegrityConstraintViolationException",
"cause":{
"commonElementCount":193,
"localizedMessage":"ORA-00001: unique constraint (FLOWABLE.SYS_C008559) violated\n",
"message":"ORA-00001: unique constraint (FLOWABLE.SYS_C008559) violated\n",
"name":"oracle.jdbc.OracleDatabaseException",
"extendedStackTrace":[
{
"class":"oracle.jdbc.driver.T4CTTIoer11",
"method":"processError",
"file":"T4CTTIoer11.java",
"line":513,
"exact":false,
"location":"ojdbc10-19.18.0.0.jar!/",
"version":"19.18.0.0.0"
},
{
"class":"oracle.jdbc.driver.T4CTTIoer11",
"method":"processError",
"file":"T4CTTIoer11.java",
"line":461,
"exact":false,
"location":"ojdbc10-19.18.0.0.jar!/",
"version":"19.18.0.0.0"
},
{
"class":"oracle.jdbc.driver.T4C8Oall",
"method":"processError",
"file":"T4C8Oall.java",
"line":1104,
"exact":false,
"location":"ojdbc10-19.18.0.0.jar!/",
"version":"19.18.0.0.0"
},
{
"class":"oracle.jdbc.driver.T4CTTIfun",
"method":"receive",
"file":"T4CTTIfun.java",
"line":553,
"exact":false,
"location":"ojdbc10-19.18.0.0.jar!/",
"version":"19.18.0.0.0"
}
For task execution:
{
"thread":"https-jsse-nio-8080-exec-1",
"level":"ERROR",
"message":"FlowableException caught",
"thrown":{
"commonElementCount":0,
"localizedMessage":"UserTask should not be signalled before complete",
"message":"UserTask should not be signalled before complete",
"name":"org.flowable.common.engine.api.FlowableException",
"extendedStackTrace":[
{
"class":"org.flowable.engine.impl.bpmn.behavior.UserTaskActivityBehavior",
"method":"trigger",
"file":"UserTaskActivityBehavior.java",
"line":322,
"exact":false,
"location":"flowable-engine-7.0.0.jar!/",
"version":"7.0.0"
},
{
"class":"org.flowable.engine.impl.agenda.TriggerExecutionOperation",
"method":"run",
"file":"TriggerExecutionOperation.java",
"line":59,
"exact":false,
"location":"flowable-engine-7.0.0.jar!/",
"version":"7.0.0"
},
{
"class":"org.flowable.common.engine.impl.AbstractEngineConfiguration",
"method":"lambda$new$0",
"file":"AbstractEngineConfiguration.java",
"line":195,
"exact":false,
"location":"flowable-engine-common-7.0.0.jar!/",
"version":"7.0.0"
},
{
"class":"org.flowable.engine.impl.interceptor.CommandInvoker",
"method":"executeOperation",
"file":"CommandInvoker.java",
"line":130,
"exact":false,
"location":"flowable-engine-7.0.0.jar!/",
"version":"7.0.0"
},
{
"class":"org.flowable.engine.impl.interceptor.CommandInvoker",
"method":"executeOperations",
"file":"CommandInvoker.java",
"line":114,
"exact":false,
"location":"flowable-engine-7.0.0.jar!/",
"version":"7.0.0"
},
{
"class":"org.flowable.engine.impl.interceptor.CommandInvoker",
"method":"execute",
"file":"CommandInvoker.java",
"line":72,
"exact":false,
"location":"flowable-engine-7.0.0.jar!/",
"version":"7.0.0"
},
{
"class":"org.flowable.engine.impl.interceptor.BpmnOverrideContextInterceptor",
"method":"execute",
"file":"BpmnOverrideContextInterceptor.java",
"line":26,
"exact":false,
"location":"flowable-engine-7.0.0.jar!/",
"version":"7.0.0"
},
{
"class":"org.flowable.common.engine.impl.interceptor.TransactionContextInterceptor",
"method":"execute",
"file":"TransactionContextInterceptor.java",
"line":53,
"exact":false,
"location":"flowable-engine-common-7.0.0.jar!/",
"version":"7.0.0"
},
{
"class":"org.flowable.common.engine.impl.interceptor.CommandContextInterceptor",
"method":"execute",
"file":"CommandContextInterceptor.java",
"line":105,
"exact":false,
"location":"flowable-engine-common-7.0.0.jar!/",
"version":"7.0.0"
},
{
"class":"org.flowable.common.spring.SpringTransactionInterceptor",
"method":"execute",
"file":"SpringTransactionInterceptor.java",
"line":52,
"exact":false,
"location":"flowable-spring-common-7.0.0.jar!/",
"version":"7.0.0"
},
{
"class":"org.flowable.common.engine.impl.interceptor.LogInterceptor",
"method":"execute",
"file":"LogInterceptor.java",
"line":30,
"exact":false,
"location":"flowable-engine-common-7.0.0.jar!/",
"version":"7.0.0"
},
{
"class":"org.flowable.common.engine.impl.cfg.CommandExecutorImpl",
"method":"execute",
"file":"CommandExecutorImpl.java",
"line":56,
"exact":false,
"location":"flowable-engine-common-7.0.0.jar!/",
"version":"7.0.0"
},
{
"class":"org.flowable.common.engine.impl.cfg.CommandExecutorImpl",
"method":"execute",
"file":"CommandExecutorImpl.java",
"line":51,
"exact":false,
"location":"flowable-engine-common-7.0.0.jar!/",
"version":"7.0.0"
},
{
"class":"org.flowable.engine.impl.TaskServiceImpl",
"method":"complete",
"file":"TaskServiceImpl.java",
"line":223,
"exact":false,
"location":"flowable-engine-7.0.0.jar!/",
"version":"7.0.0"
}