Hello Flowable Team,
We are seeing an error while updating Process instance variables in Flowable through Postman calling below endpoint method.
FlowableClient.Bpmn.ProcessInstanceVariables.ProcessInstanceVariablesClient.UpdateProcessInstanceVariableAsync
Error:
{“message”:“Internal server error”,“exception”:“\n### Error updating database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The DELETE statement conflicted with the REFERENCE constraint “ACT_FK_EVENT_EXEC”. The conflict occurred in database “database”, table “Flowable.ACT_RU_EVENT_SUBSCR”, column ‘EXECUTION_ID_’.\n### The error may exist in org/flowable/db/mapping/entity/Execution.xml\n### The error may involve org.flowable.engine.impl.persistence.entity.ExecutionEntityImpl.deleteExecution-Inline\n### The error occurred while setting parameters\n### SQL: delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ?\n### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The DELETE statement conflicted with the REFERENCE constraint “ACT_FK_EVENT_EXEC”. The conflict occurred in database “database”, table “Flowable.ACT_RU_EVENT_SUBSCR”, column ‘EXECUTION_ID_’.”}
We really appreciate your help.
Thanks
Vivek