Hi Team,
I am getting a FK error , while completing a user task . As per my analysis , after completion of subsequent Service task , camunda tries to delete execution from ACT_RU_EXECUTION , but it restricts it because one of the variables is still present in ACT_RU_VARIABLE (although REV_ column has different value )
I have tried to make service tasks before and after user task as “Async = True” . But it is not working.
Please suggest what can be done.
Thanks !
@Sonali Which database are you using? And could you please upload the bpmn file? Also please provide complete error stack trace 
Thanks for responding @aravindhrs
We are using Oracle DB .
Error Stack Trace :
“type”: “RestException”,
“message”: “Cannot complete task 3814614: ENGINE-03004 Exception while executing Database Operation ‘DELETE ExecutionEntity[3813959]’ with message ‘\r\n### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (COM_BPM_UAT.ACT_FK_VAR_EXE) violated - child record found\n\r\n### The error may involve org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.deleteExecution-Inline\r\n### The error occurred while setting parameters\r\n### SQL: delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ?\r\n### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (CCS_BPM_UAT.ACT_FK_VAR_EXE) violated - child record found\n’. Flush summary: \n [\n INSERT HistoricVariableInstanceEntity[3814711]\n INSERT HistoricVariableInstanceEntity[3814713]\n INSERT HistoricVariableInstanceEntity[3814715]\n INSERT HistoricVariableInstanceEntity[3814717]\n INSERT HistoricVariableInstanceEntity[3814719]\n INSERT HistoricVariableInstanceEntity[3814721]\n INSERT HistoricVariableInstanceEntity[3814723]\n INSERT HistoricVariableInstanceEntity[3814725]\n INSERT HistoricVariableInstanceEntity[3814727]\n INSERT HistoricVariableInstanceEntity[3814729]\n INSERT HistoricVariableInstanceEntity[3814731]\n INSERT HistoricVariableInstanceEntity[3814733]\n INSERT HistoricVariableInstanceEntity[3814735]\n INSERT HistoricVariableInstanceEntity[3814737]\n INSERT HistoricVariableInstanceEntity[3814739]\n INSERT HistoricVariableInstanceEntity[3814741]\n INSERT HistoricVariableInstanceEntity[3814743]\n INSERT HistoricVariableInstanceEntity[3814745]\n INSERT HistoricVariableInstanceEntity[3814747]\n INSERT HistoricVariableInstanceEntity[3814752]\n INSERT HistoricVariableInstanceEntity[3814768]\n INSERT HistoricJobLogEventEntity[3814770]\n INSERT HistoricJobLogEventEntity[3814771]\n INSERT HistoricVariableUpdateEventEntity[3814712]\n INSERT HistoricVariableUpdateEventEntity[3814714]\n INSERT HistoricVariableUpdateEventEntity[3814716]\n INSERT HistoricVariableUpdateEventEntity[3814718]\n INSERT HistoricVariableUpdateEventEntity[3814720]\n INSERT HistoricVariableUpdateEventEntity[3814722]\n INSERT HistoricVariableUpdateEventEntity[3814724]\n INSERT HistoricVariableUpdateEventEntity[3814726]\n INSERT HistoricVariableUpdateEventEntity[3814728]\n INSERT HistoricVariableUpdateEventEntity[3814730]\n INSERT HistoricVariableUpdateEventEntity[3814732]\n INSERT HistoricVariableUpdateEventEntity[3814734]\n INSERT HistoricVariableUpdateEventEntity[3814736]\n INSERT HistoricVariableUpdateEventEntity[3814738]\n INSERT HistoricVariableUpdateEventEntity[3814740]\n INSERT HistoricVariableUpdateEventEntity[3814742]\n INSERT HistoricVariableUpdateEventEntity[3814744]\n INSERT HistoricVariableUpdateEventEntity[3814746]\n INSERT HistoricVariableUpdateEventEntity[3814748]\n INSERT HistoricVariableUpdateEventEntity[3814753]\n INSERT HistoricVariableUpdateEventEntity[3814766]\n INSERT HistoricVariableUpdateEventEntity[3814769]\n INSERT HistoricVariableUpdateEventEntity[3814774]\n INSERT HistoricVariableUpdateEventEntity[3814778]\n INSERT HistoricActivityInstanceEventEntity[ExclusiveGateway_1ndadrf:3814749]\n INSERT HistoricActivityInstanceEventEntity[ServiceTask_14yy81e:3814751]\n INSERT ByteArrayEntity[3814765]\n INSERT ByteArrayEntity[3814767]\n INSERT ByteArrayEntity[3814773]\n INSERT ByteArrayEntity[3814776]\n INSERT ByteArrayEntity[3814777]\n INSERT ByteArrayEntity[3814779]\n DELETE TimerEntity[3814242]\n DELETE TimerEntity[3814244]\n UPDATE VariableInstanceEntity[3814604]\n DELETE VariableInstanceEntity[3813434]\n DELETE VariableInstanceEntity[3813435]\n DELETE VariableInstanceEntity[3813450]\n DELETE VariableInstanceEntity[3813451]\n DELETE VariableInstanceEntity[3813463]\n DELETE VariableInstanceEntity[3813906]\n DELETE VariableInstanceEntity[3813907]\n DELETE VariableInstanceEntity[3813918]\n DELETE VariableInstanceEntity[3813925]\n DELETE VariableInstanceEntity[3813926]\n DELETE VariableInstanceEntity[3813927]\n DELETE VariableInstanceEntity[3813940]\n DELETE VariableInstanceEntity[3813942]\n DELETE VariableInstanceEntity[3813944]\n DELETE VariableInstanceEntity[3813946]\n DELETE VariableInstanceEntity[3813948]\n DELETE VariableInstanceEntity[3813950]\n DELETE VariableInstanceEntity[3813952]\n DELETE VariableInstanceEntity[3813954]\n DELETE VariableInstanceEntity[3813960]\n DELETE VariableInstanceEntity[3813961]\n DELETE VariableInstanceEntity[3813962]\n DELETE VariableInstanceEntity[3813963]\n DELETE VariableInstanceEntity[3813964]\n DELETE VariableInstanceEntity[3813965]\n DELETE VariableInstanceEntity[3813966]\n DELETE VariableInstanceEntity[3813967]\n DELETE VariableInstanceEntity[3813968]\n DELETE VariableInstanceEntity[3813969]\n DELETE VariableInstanceEntity[3813970]\n DELETE VariableInstanceEntity[3813991]\n DELETE VariableInstanceEntity[3814068]\n DELETE VariableInstanceEntity[3814070]\n DELETE VariableInstanceEntity[3814072]\n DELETE VariableInstanceEntity[3814074]\n DELETE VariableInstanceEntity[3814077]\n DELETE VariableInstanceEntity[3814085]\n DELETE VariableInstanceEntity[3814088]\n DELETE VariableInstanceEntity[3814090]\n DELETE VariableInstanceEntity[3814092]\n DELETE VariableInstanceEntity[3814094]\n DELETE VariableInstanceEntity[3814096]\n DELETE VariableInstanceEntity[3814098]\n DELETE VariableInstanceEntity[3814100]\n DELETE VariableInstanceEntity[3814112]\n DELETE VariableInstanceEntity[3814113]\n DELETE VariableInstanceEntity[3814114]\n DELETE VariableInstanceEntity[3814116]\n DELETE VariableInstanceEntity[3814117]\n DELETE VariableInstanceEntity[3814119]\n DELETE VariableInstanceEntity[3814120]\n DELETE VariableInstanceEntity[3814121]\n DELETE VariableInstanceEntity[3814122]\n DELETE VariableInstanceEntity[3814123]\n DELETE VariableInstanceEntity[3814124]\n DELETE VariableInstanceEntity[3814125]\n DELETE VariableInstanceEntity[3814126]\n DELETE VariableInstanceEntity[3814127]\n DELETE VariableInstanceEntity[3814128]\n DELETE VariableInstanceEntity[3814129]\n DELETE VariableInstanceEntity[3814158]\n DELETE VariableInstanceEntity[3814160]\n DELETE VariableInstanceEntity[3814166]\n DELETE VariableInstanceEntity[3814167]\n DELETE VariableInstanceEntity[3814168]\n DELETE VariableInstanceEntity[3814170]\n DELETE VariableInstanceEntity[3814171]\n DELETE VariableInstanceEntity[3814173]\n DELETE VariableInstanceEntity[3814174]\n DELETE VariableInstanceEntity[3814175]\n DELETE VariableInstanceEntity[3814176]\n DELETE VariableInstanceEntity[3814177]\n DELETE VariableInstanceEntity[3814178]\n DELETE VariableInstanceEntity[3814179]\n DELETE VariableInstanceEntity[3814180]\n DELETE VariableInstanceEntity[3814181]\n DELETE VariableInstanceEntity[3814182]\n DELETE VariableInstanceEntity[3814183]\n DELETE VariableInstanceEntity[3814184]\n DELETE VariableInstanceEntity[3814185]\n DELETE VariableInstanceEntity[3814225]\n DELETE VariableInstanceEntity[3814230]\n DELETE VariableInstanceEntity[3814240]\n DELETE VariableInstanceEntity[3814608]\n DELETE VariableInstanceEntity[3814610]\n DELETE ByteArrayEntity[3813990]\n DELETE ByteArrayEntity[3813994]\n DELETE ByteArrayEntity[3814076]\n DELETE ByteArrayEntity[3814081]\n DELETE ByteArrayEntity[3814115]\n DELETE ByteArrayEntity[3814118]\n DELETE ByteArrayEntity[3814216]\n DELETE ByteArrayEntity[3814250]\n DELETE ByteArrayEntity[3814618]\n DELETE ByteArrayEntity[3814621]\n DELETE TaskEntity[3814246]\n DELETE TaskEntity[3814614]\n DELETE ExecutionEntity[3813983]\n DELETE ExecutionEntity[3813959]\n DELETE ExecutionEntity[3813957]\n DELETE ExecutionEntity[3813932]\n DELETE ExecutionEntity[3813924]\n DELETE ExecutionEntity[3813922]\n DELETE ExecutionEntity[3813911]\n DELETE ExecutionEntity[3813905]\n DELETE ExecutionEntity[3814238]\n DELETE ExecutionEntity[3814209]\n DELETE ExecutionEntity[3814165]\n DELETE ExecutionEntity[3814163]\n DELETE ExecutionEntity[3814151]\n DELETE ExecutionEntity[3814111]\n DELETE ExecutionEntity[3814109]\n DELETE ExecutionEntity[3813455]\n DELETE ExecutionEntity[3813449]\n DELETE ExecutionEntity[3813447]\n DELETE ExecutionEntity[3813439]\n DELETE ExecutionEntity[3813433]\n UPDATE HistoricActivityInstanceEventEntity[SubProcess_0igikuz:3813933]\n UPDATE HistoricActivityInstanceEventEntity[SubProcess_0rrv1fa:3814152]\n UPDATE HistoricActivityInstanceEventEntity[SubProcess_0uc5kvy:3813984]\n UPDATE HistoricActivityInstanceEventEntity[SubProcess_18r4hif:3813456]\n UPDATE HistoricActivityInstanceEventEntity[SubProcess_1cl9j1d:3814210]\n UPDATE HistoricActivityInstanceEventEntity[T_Order_Manager_Task:3814239]\n UPDATE HistoricActivityInstanceEventEntity[Task_09jqi7s:3813448]\n UPDATE HistoricActivityInstanceEventEntity[Task_0ci5y7n:3814164]\n UPDATE HistoricActivityInstanceEventEntity[Task_0hyoqlq:3814613]\n UPDATE HistoricActivityInstanceEventEntity[Task_0qrkco7:3813440]\n UPDATE HistoricActivityInstanceEventEntity[Task_0qrkco7:3813912]\n UPDATE HistoricActivityInstanceEventEntity[Task_1465h1l:3813923]\n UPDATE HistoricActivityInstanceEventEntity[Task_1g2ici5:3813958]\n UPDATE HistoricActivityInstanceEventEntity[Task_1r1fw8o:3814110]\n UPDATE HistoricProcessInstanceEventEntity[3813433]\n UPDATE HistoricProcessInstanceEventEntity[3813449]\n UPDATE HistoricProcessInstanceEventEntity[3813905]\n UPDATE HistoricProcessInstanceEventEntity[3813924]\n UPDATE HistoricProcessInstanceEventEntity[3813959]\n UPDATE HistoricProcessInstanceEventEntity[3814111]\n UPDATE HistoricProcessInstanceEventEntity[3814165]\n UPDATE HistoricTaskInstanceEventEntity[3814246]\n UPDATE HistoricTaskInstanceEventEntity[3814614]\n UPDATE HistoricVariableInstanceEntity[3813991]\n UPDATE HistoricVariableInstanceEntity[3814604]\n]”
}
@aravindhrs - Also , I am not sure why Camunda is trying to delete execution during Post Operation service task , there is one more service task after that …my execution is not going there and throwing exception before that.
@Sonali Whenever the execution is completed for an activity, the records on the runtime tables for the specific entity (task instance, variable instance, etc) will be removed and stored in history tables.
Which version of camunda platform you are using? Have you done the camunda platform version upgrade? (updated)
We are using Camunda Version 7.12.0 , oracle DB 11.2.
How will I know the version of Camunda DB?
Not camunda db, I meant to camunda platform. Was there any camunda platform done from previous versions to 7.12?
