删除activiti工作流的业务数据(5.22.0)

1、按顺序删除activiti工作流的业务数据

DELETE FROM `act_hi_detail` WHERE 1=1;
DELETE FROM `act_hi_comment` WHERE 1=1;
DELETE FROM `act_hi_identitylink` WHERE 1=1;
DELETE FROM `act_hi_procinst` WHERE 1=1;
DELETE FROM `act_hi_varinst` WHERE 1=1;
DELETE FROM `act_hi_taskinst` WHERE 1=1;
DELETE FROM `act_hi_actinst` WHERE 1=1;
DELETE FROM `act_ru_identitylink` WHERE 1=1;
DELETE FROM `act_ru_task` WHERE 1=1;
DELETE FROM `act_ru_variable` WHERE 1=1;
DELETE FROM `act_ru_execution` WHERE 1=1;

2、删除activiti工作流的模型定义表【慎重

DELETE FROM `act_re_procdef` WHERE 1=1;
DELETE FROM `act_ge_bytearray` WHERE 1=1;
DELETE FROM `act_re_deployment` WHERE 1=1;

已标记关键词 清除标记
2020-03-05 17:25:21,008 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - ==> Preparing: select * from ( select a.*, ROWNUM rnum from ( select RES.* from ACT_RU_JOB RES LEFT OUTER JOIN ACT_RU_EXECUTION PI ON PI.ID_ = RES.PROCESS_INSTANCE_ID_ where (RES.RETRIES_ > 0) and (RES.DUEDATE_ is null or RES.DUEDATE_ <= ?) and (RES.LOCK_OWNER_ is null or RES.LOCK_EXP_TIME_ <= ?) and ( (RES.EXECUTION_ID_ is null) or (PI.SUSPENSION_STATE_ = 1) ) ) a where ROWNUM < ?) where rnum >= ? 2020-03-05 17:25:21,008 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - ==> Parameters: 2020-03-05 17:25:04.781(Timestamp), 2020-03-05 17:25:04.781(Timestamp), 2(Integer), 1(Integer) 2020-03-05 17:25:21,037 DEBUG [impl.persistence.entity.TaskEntity.selectTask] - ==> Preparing: select * from ACT_RU_TASK where ID_ = ? 2020-03-05 17:25:21,051 DEBUG [impl.persistence.entity.TaskEntity.selectTask] - ==> Parameters: e10fc0d1e5a4472f8e3799780d806796(String) 2020-03-05 17:25:21,101 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - <== Total: 0 2020-03-05 17:25:21,321 DEBUG [impl.persistence.entity.TaskEntity.selectTask] - <== Total: 1 2020-03-05 17:25:21,337 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecution] - ==> Preparing: select * from ACT_RU_EXECUTION where ID_ = ? 2020-03-05 17:25:21,349 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecution] - ==> Parameters: a32f7be1df484268a5137525f7482fc8(String) 2020-03-05 17:25:21,598 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecution] - <== Total: 1 2020-03-05 17:25:21,618 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - ==> Preparing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null 2020-03-05 17:25:21,632 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - ==> Parameters: a32f7be1df484268a5137525f7482fc8(String) 2020-03-05 17:25:21,875 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - <== Total: 2 2020-03-05 17:25:21,893 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecution] - ==> Preparing: select * from ACT_RU_EXECUTION where ID_ = ? 2020-03-05 17:25:21,906 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecution] - ==> Parameters: 66c63afb27a44c1688b44a0f6a216f5d(String) 2020-03-05 17:25:22,152 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecution] - <== Total: 1 2020-03-05 17:25:22,172 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - ==> Preparing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null 2020-03-05 17:25:22,186 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - ==> Parameters: 66c63afb27a44c1688b44a0f6a216f5d(String) 2020-03-05 17:25:22,478 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - <== Total: 3 2020-03-05 17:25:22,496 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecution] - ==> Preparing: select * from ACT_RU_EXECUTION where ID_ = ? 2020-03-05 17:25:22,508 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecution] - ==> Parameters: b7a34a039dc74635bba47d4763cd5c9a(String) 2020-03-05 17:25:22,814 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecution] - <== Total: 1 2020-03-05 17:25:22,833 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - ==> Preparing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null 2020-03-05 17:25:22,846 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - ==> Parameters: b7a34a039dc74635bba47d4763cd5c9a(String) 2020-03-05 17:25:23,506 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - <== Total: 13 2020-03-05 17:25:23,608 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - ==> Preparing: select * from ( select a.*, ROWNUM rnum from ( select RES.* from ACT_HI_ACTINST RES WHERE RES.EXECUTION_ID_ = ? and RES.ACT_ID_ = ? and RES.END_TIME_ is null order by RES.ID_ asc ) a where ROWNUM < ?) where rnum >= ? 2020-03-05 17:25:23,633 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - ==> Parameters: a32f7be1df484268a5137525f7482fc8(String), jhbmsh(String), 2(Integer), 1(Integer) 2020-03-05 17:25:23,870 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - <== Total: 0 2020-03-05 17:25:23,936 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - ==> Preparing: select * from ( select a.*, ROWNUM rnum from ( select RES.* from ACT_HI_ACTINST RES WHERE RES.EXECUTION_ID_ = ? and RES.ACT_ID_ = ? and RES.END_TIME_ is null order by RES.ID_ asc ) a where ROWNUM < ?) where rnum >= ? 2020-03-05 17:25:23,959 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - ==> Parameters: 66c63afb27a44c1688b44a0f6a216f5d(String), jhbmsh(String), 2(Integer), 1(Integer) 2020-03-05 17:25:24,536 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - <== Total: 1 2020-03-05 17:25:24,557 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - ==> Preparing: select * from ACT_HI_VARINST where ID_ = ? 2020-03-05 17:25:24,572 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - ==> Parameters: ca712ffb55ed4eaebd637337c36e402e(String) 2020-03-05 17:25:24,813 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - <== Total: 1 2020-03-05 17:25:24,834 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByProcessInstance] - ==> Preparing: select * from ACT_RU_IDENTITYLINK where PROC_INST_ID_ = ? 2020-03-05 17:25:24,847 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByProcessInstance] - ==> Parameters: b7a34a039dc74635bba47d4763cd5c9a(String) 2020-03-05 17:25:24,874 WARN [org.springframework.scheduling.quartz.LocalDataSourceJobStore] - This scheduler instance (SC-2018112819301583393050864) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. 2020-03-05 17:25:25,075 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByProcessInstance] - <== Total: 3 2020-03-05 17:25:25,097 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByParentTaskId] - ==> Preparing: select * from ACT_RU_TASK where PARENT_TASK_ID_ = ? 2020-03-05 17:25:25,110 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByParentTaskId] - ==> Parameters: e10fc0d1e5a4472f8e3799780d806796(String) 2020-03-05 17:25:25,324 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByParentTaskId] - <== Total: 0 2020-03-05 17:25:25,341 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByTask] - ==> Preparing: select * from ACT_RU_IDENTITYLINK where TASK_ID_ = ? 2020-03-05 17:25:25,354 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByTask] - ==> Parameters: e10fc0d1e5a4472f8e3799780d806796(String) 2020-03-05 17:25:25,510 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByTask] - <== Total: 0 2020-03-05 17:25:25,527 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByTaskId] - ==> Preparing: select * from ACT_RU_VARIABLE where TASK_ID_ = ? 2020-03-05 17:25:25,542 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByTaskId] - ==> Parameters: e10fc0d1e5a4472f8e3799780d806796(String) 2020-03-05 17:25:25,718 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByTaskId] - <== Total: 0 2020-03-05 17:25:25,734 DEBUG [impl.persistence.entity.HistoricTaskInstanceEntity.selectHistoricTaskInstance] - ==> Preparing: select * from ACT_HI_TASKINST where ID_ = ? 2020-03-05 17:25:25,747 DEBUG [impl.persistence.entity.HistoricTaskInstanceEntity.selectHistoricTaskInstance] - ==> Parameters: e10fc0d1e5a4472f8e3799780d806796(String) 2020-03-05 17:25:26,030 DEBUG [impl.persistence.entity.HistoricTaskInstanceEntity.selectHistoricTaskInstance] - <== Total: 1 2020-03-05 17:25:26,051 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - ==> Preparing: select distinct T.* from ACT_RU_TASK T where T.EXECUTION_ID_ = ? 2020-03-05 17:25:26,063 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - ==> Parameters: a32f7be1df484268a5137525f7482fc8(String) 2020-03-05 17:25:26,149 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - ==> Preparing: select * from ( select a.*, ROWNUM rnum from ( select RES.* from ACT_RU_JOB RES LEFT OUTER JOIN ACT_RU_EXECUTION PI ON PI.ID_ = RES.PROCESS_INSTANCE_ID_ where (RES.RETRIES_ > 0) and (RES.DUEDATE_ is null or RES.DUEDATE_ <= ?) and (RES.LOCK_OWNER_ is null or RES.LOCK_EXP_TIME_ <= ?) and ( (RES.EXECUTION_ID_ is null) or (PI.SUSPENSION_STATE_ = 1) ) ) a where ROWNUM < ?) where rnum >= ? 2020-03-05 17:25:26,149 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - ==> Parameters: 2020-03-05 17:25:26.149(Timestamp), 2020-03-05 17:25:26.149(Timestamp), 2(Integer), 1(Integer) 2020-03-05 17:25:26,225 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - <== Total: 0 2020-03-05 17:25:26,347 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - <== Total: 1 2020-03-05 17:25:26,409 DEBUG [impl.persistence.entity.ByteArrayEntity.selectByteArray] - ==> Preparing: select * from ACT_GE_BYTEARRAY where ID_ = ? 2020-03-05 17:25:26,421 DEBUG [impl.persistence.entity.ByteArrayEntity.selectByteArray] - ==> Parameters: 0b5bf947cc4f4b39a3cbe4f92361c92d(String) 2020-03-05 17:25:26,679 DEBUG [impl.persistence.entity.ByteArrayEntity.selectByteArray] - <== Total: 1 2020-03-05 17:25:26,749 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - ==> Preparing: select * from ACT_HI_VARINST where ID_ = ? 2020-03-05 17:25:26,767 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - ==> Parameters: 32b25168f8d142099f15776efb4d0942(String) 2020-03-05 17:25:26,998 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - <== Total: 1 2020-03-05 17:25:27,061 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - ==> Preparing: select * from ACT_HI_VARINST where ID_ = ? 2020-03-05 17:25:27,075 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - ==> Parameters: 95bf1206fafb4d94a382912c0e3d49d7(String) 2020-03-05 17:25:27,311 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - <== Total: 1 2020-03-05 17:25:27,331 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecutionsByParentExecutionId] - ==> Preparing: select * from ACT_RU_EXECUTION where PARENT_ID_ = ? 2020-03-05 17:25:27,344 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecutionsByParentExecutionId] - ==> Parameters: 66c63afb27a44c1688b44a0f6a216f5d(String) 2020-03-05 17:25:27,606 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecutionsByParentExecutionId] - <== Total: 1 2020-03-05 17:25:27,623 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecutionsByParentExecutionId] - ==> Preparing: select * from ACT_RU_EXECUTION where PARENT_ID_ = ? 2020-03-05 17:25:27,639 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecutionsByParentExecutionId] - ==> Parameters: a32f7be1df484268a5137525f7482fc8(String) 2020-03-05 17:25:27,838 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecutionsByParentExecutionId] - <== Total: 0 2020-03-05 17:25:27,849 DEBUG [engine.impl.persistence.entity.ExecutionEntity] - inactive concurrent executions in 'Activity(jhbmsh)': [ConcurrentExecution[a32f7be1df484268a5137525f7482fc8]] 2020-03-05 17:25:27,857 DEBUG [engine.impl.persistence.entity.ExecutionEntity] - other concurrent executions: [] 2020-03-05 17:25:27,866 DEBUG [engine.impl.persistence.entity.ExecutionEntity] - transitions to take concurrent: [(jhbmsh)--sid-29EF82D1-53D5-4ADD-AAF2-B2E4CB2857FB-->(flbmsh), (jhbmsh)--sid-2160AC73-3470-4599-AA6D-39C99E731D3E-->(end)] 2020-03-05 17:25:27,874 DEBUG [engine.impl.persistence.entity.ExecutionEntity] - active concurrent executions: [] 2020-03-05 17:25:27,880 DEBUG [engine.impl.persistence.entity.ExecutionEntity] - recyclable executions for reuse: [ConcurrentExecution[a32f7be1df484268a5137525f7482fc8]] 2020-03-05 17:25:27,888 DEBUG [engine.impl.persistence.entity.ExecutionEntity] - recycled ConcurrentExecution[a32f7be1df484268a5137525f7482fc8] to take transition (jhbmsh)--sid-29EF82D1-53D5-4ADD-AAF2-B2E4CB2857FB-->(flbmsh) 2020-03-05 17:25:27,901 DEBUG [engine.impl.persistence.entity.ExecutionEntity] - Child execution ScopeExecution[dae048adf18e4137bd7503498bdf3b7a] created with parent 2020-03-05 17:25:27,912 DEBUG [engine.impl.persistence.entity.ExecutionEntity] - new ScopeExecution[dae048adf18e4137bd7503498bdf3b7a] with parent ScopeExecution[66c63afb27a44c1688b44a0f6a216f5d] created to take transition (jhbmsh)--sid-2160AC73-3470-4599-AA6D-39C99E731D3E-->(end) 2020-03-05 17:25:28,011 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecutionsByParentExecutionId] - ==> Preparing: select * from ACT_RU_EXECUTION where PARENT_ID_ = ? 2020-03-05 17:25:28,025 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecutionsByParentExecutionId] - ==> Parameters: b7a34a039dc74635bba47d4763cd5c9a(String) 2020-03-05 17:25:28,284 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecutionsByParentExecutionId] - <== Total: 1 2020-03-05 17:25:28,309 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - ==> Preparing: select distinct T.* from ACT_RU_TASK T where T.EXECUTION_ID_ = ? 2020-03-05 17:25:28,659 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - ==> Parameters: dae048adf18e4137bd7503498bdf3b7a(String) 2020-03-05 17:25:28,886 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - <== Total: 0 2020-03-05 17:25:28,907 DEBUG [impl.persistence.entity.JobEntity.selectJobsByExecutionId] - ==> Preparing: select * from ACT_RU_JOB J where J.EXECUTION_ID_ = ? 2020-03-05 17:25:28,923 DEBUG [impl.persistence.entity.JobEntity.selectJobsByExecutionId] - ==> Parameters: dae048adf18e4137bd7503498bdf3b7a(String) 2020-03-05 17:25:29,123 DEBUG [impl.persistence.entity.JobEntity.selectJobsByExecutionId] - <== Total: 0 2020-03-05 17:25:29,144 DEBUG [impl.persistence.entity.EventSubscriptionEntity.selectEventSubscriptionsByExecution] - ==> Preparing: select * from ACT_RU_EVENT_SUBSCR where (EXECUTION_ID_ = ?) 2020-03-05 17:25:29,157 DEBUG [impl.persistence.entity.EventSubscriptionEntity.selectEventSubscriptionsByExecution] - ==> Parameters: dae048adf18e4137bd7503498bdf3b7a(String) 2020-03-05 17:25:29,328 DEBUG [impl.persistence.entity.EventSubscriptionEntity.selectEventSubscriptionsByExecution] - <== Total: 0 2020-03-05 17:25:29,347 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - ==> Preparing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null 2020-03-05 17:25:29,360 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - ==> Parameters: dae048adf18e4137bd7503498bdf3b7a(String) 2020-03-05 17:25:29,542 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - <== Total: 0 2020-03-05 17:25:29,608 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - ==> Preparing: select * from ( select a.*, ROWNUM rnum from ( select RES.* from ACT_HI_ACTINST RES WHERE RES.EXECUTION_ID_ = ? and RES.END_TIME_ is null order by RES.ID_ asc ) a where ROWNUM < ?) where rnum >= ? 2020-03-05 17:25:29,628 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - ==> Parameters: dae048adf18e4137bd7503498bdf3b7a(String), 2147483647(Integer), 1(Integer) 2020-03-05 17:25:29,845 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - <== Total: 0 2020-03-05 17:25:29,867 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - ==> Preparing: select distinct T.* from ACT_RU_TASK T where T.EXECUTION_ID_ = ? 2020-03-05 17:25:29,880 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - ==> Parameters: 66c63afb27a44c1688b44a0f6a216f5d(String) 2020-03-05 17:25:30,085 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - <== Total: 0 2020-03-05 17:25:30,105 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByProcessInstance] - ==> Preparing: select * from ACT_RU_IDENTITYLINK where PROC_INST_ID_ = ? 2020-03-05 17:25:30,120 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByProcessInstance] - ==> Parameters: dae048adf18e4137bd7503498bdf3b7a(String) 2020-03-05 17:25:30,280 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByProcessInstance] - <== Total: 0 2020-03-05 17:25:30,301 DEBUG [engine.impl.persistence.entity.ExecutionEntity] - Child execution ScopeExecution[7e9d7306afd1405a9730796c25492472] created with parent 2020-03-05 17:25:30,309 DEBUG [engine.impl.persistence.entity.ExecutionEntity] - initializing ScopeExecution[7e9d7306afd1405a9730796c25492472] 2020-03-05 17:25:30,363 DEBUG [engine.impl.persistence.entity.ExecutionEntity] - Child execution ScopeExecution[024014e14ffb4e95b07060e129af8f1f] created with parent 2020-03-05 17:25:30,380 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - ==> Preparing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null 2020-03-05 17:25:30,394 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - ==> Parameters: 024014e14ffb4e95b07060e129af8f1f(String) 2020-03-05 17:25:30,571 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - <== Total: 0 2020-03-05 17:25:30,646 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - ==> Preparing: select * from ( select a.*, ROWNUM rnum from ( select RES.* from ACT_HI_ACTINST RES WHERE RES.EXECUTION_ID_ = ? and RES.ACT_ID_ = ? and RES.END_TIME_ is null order by RES.ID_ asc ) a where ROWNUM < ?) where rnum >= ? 2020-03-05 17:25:30,670 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - ==> Parameters: 024014e14ffb4e95b07060e129af8f1f(String), flbmsh(String), 2(Integer), 1(Integer) 2020-03-05 17:25:30,906 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - <== Total: 0 2020-03-05 17:25:30,980 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - ==> Preparing: select distinct T.* from ACT_RU_TASK T where T.EXECUTION_ID_ = ? 2020-03-05 17:25:30,993 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - ==> Parameters: 024014e14ffb4e95b07060e129af8f1f(String) 2020-03-05 17:25:31,266 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - ==> Preparing: select * from ( select a.*, ROWNUM rnum from ( select RES.* from ACT_RU_JOB RES LEFT OUTER JOIN ACT_RU_EXECUTION PI ON PI.ID_ = RES.PROCESS_INSTANCE_ID_ where (RES.RETRIES_ > 0) and (RES.DUEDATE_ is null or RES.DUEDATE_ <= ?) and (RES.LOCK_OWNER_ is null or RES.LOCK_EXP_TIME_ <= ?) and ( (RES.EXECUTION_ID_ is null) or (PI.SUSPENSION_STATE_ = 1) ) ) a where ROWNUM < ?) where rnum >= ? 2020-03-05 17:25:31,266 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - ==> Parameters: 2020-03-05 17:25:31.264(Timestamp), 2020-03-05 17:25:31.264(Timestamp), 2(Integer), 1(Integer) 2020-03-05 17:25:31,346 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - <== Total: 0 2020-03-05 17:25:31,494 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - <== Total: 0 2020-03-05 17:25:31,655 DEBUG [engine.impl.persistence.entity.ExecutionEntity] - destroying ConcurrentScopeExecution[66c63afb27a44c1688b44a0f6a216f5d] 2020-03-05 17:25:31,669 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - ==> Preparing: select * from ACT_HI_VARINST where ID_ = ? 2020-03-05 17:25:31,682 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - ==> Parameters: aa15f1aaa53243febef5fcfc2b0f6378(String) 2020-03-05 17:25:31,922 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - <== Total: 1 2020-03-05 17:25:31,962 DEBUG [impl.persistence.entity.JobEntity.selectJobsByExecutionId] - ==> Preparing: select * from ACT_RU_JOB J where J.EXECUTION_ID_ = ? 2020-03-05 17:25:31,975 DEBUG [impl.persistence.entity.JobEntity.selectJobsByExecutionId] - ==> Parameters: 66c63afb27a44c1688b44a0f6a216f5d(String) 2020-03-05 17:25:32,176 DEBUG [impl.persistence.entity.JobEntity.selectJobsByExecutionId] - <== Total: 0 2020-03-05 17:25:32,195 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByProcessInstance] - ==> Preparing: select * from ACT_RU_IDENTITYLINK where PROC_INST_ID_ = ? 2020-03-05 17:25:32,209 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByProcessInstance] - ==> Parameters: 66c63afb27a44c1688b44a0f6a216f5d(String) 2020-03-05 17:25:32,636 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByProcessInstance] - <== Total: 0 2020-03-05 17:25:32,661 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - ==> Preparing: select distinct T.* from ACT_RU_TASK T where T.EXECUTION_ID_ = ? 2020-03-05 17:25:32,676 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - ==> Parameters: b7a34a039dc74635bba47d4763cd5c9a(String) 2020-03-05 17:25:32,879 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - <== Total: 0 2020-03-05 17:25:32,896 DEBUG [impl.persistence.entity.JobEntity.selectJobsByExecutionId] - ==> Preparing: select * from ACT_RU_JOB J where J.EXECUTION_ID_ = ? 2020-03-05 17:25:32,910 DEBUG [impl.persistence.entity.JobEntity.selectJobsByExecutionId] - ==> Parameters: a32f7be1df484268a5137525f7482fc8(String) 2020-03-05 17:25:33,115 DEBUG [impl.persistence.entity.JobEntity.selectJobsByExecutionId] - <== Total: 0 2020-03-05 17:25:33,133 DEBUG [impl.persistence.entity.EventSubscriptionEntity.selectEventSubscriptionsByExecution] - ==> Preparing: select * from ACT_RU_EVENT_SUBSCR where (EXECUTION_ID_ = ?) 2020-03-05 17:25:33,147 DEBUG [impl.persistence.entity.EventSubscriptionEntity.selectEventSubscriptionsByExecution] - ==> Parameters: a32f7be1df484268a5137525f7482fc8(String) 2020-03-05 17:25:33,345 DEBUG [impl.persistence.entity.EventSubscriptionEntity.selectEventSubscriptionsByExecution] - <== Total: 0 2020-03-05 17:25:33,416 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - ==> Preparing: select * from ( select a.*, ROWNUM rnum from ( select RES.* from ACT_HI_ACTINST RES WHERE RES.EXECUTION_ID_ = ? and RES.END_TIME_ is null order by RES.ID_ asc ) a where ROWNUM < ?) where rnum >= ? 2020-03-05 17:25:33,437 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - ==> Parameters: a32f7be1df484268a5137525f7482fc8(String), 2147483647(Integer), 1(Integer) 2020-03-05 17:25:33,676 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - <== Total: 0 2020-03-05 17:25:33,713 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - ==> Preparing: select * from ACT_HI_VARINST where ID_ = ? 2020-03-05 17:25:33,725 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - ==> Parameters: 9a88efabbcef4344a7ae082e5135d645(String) 2020-03-05 17:25:33,968 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - <== Total: 1 2020-03-05 17:25:33,987 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - ==> Preparing: select * from ACT_HI_VARINST where ID_ = ? 2020-03-05 17:25:34,001 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - ==> Parameters: ccad23e5a3ae4791a0db8415196dfbe8(String) 2020-03-05 17:25:34,247 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - <== Total: 1 2020-03-05 17:25:34,274 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByProcessInstance] - ==> Preparing: select * from ACT_RU_IDENTITYLINK where PROC_INST_ID_ = ? 2020-03-05 17:25:34,290 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByProcessInstance] - ==> Parameters: a32f7be1df484268a5137525f7482fc8(String) 2020-03-05 17:25:34,462 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByProcessInstance] - <== Total: 0 2020-03-05 17:25:36,071 DEBUG [impl.persistence.entity.HistoricDetailEntity.bulkInsertHistoricDetailVariableInstanceUpdate_oracle] - ==> Preparing: INSERT ALL INTO ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SELECT * FROM dual 2020-03-05 17:25:36,377 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - ==> Preparing: select * from ( select a.*, ROWNUM rnum from ( select RES.* from ACT_RU_JOB RES LEFT OUTER JOIN ACT_RU_EXECUTION PI ON PI.ID_ = RES.PROCESS_INSTANCE_ID_ where (RES.RETRIES_ > 0) and (RES.DUEDATE_ is null or RES.DUEDATE_ <= ?) and (RES.LOCK_OWNER_ is null or RES.LOCK_EXP_TIME_ <= ?) and ( (RES.EXECUTION_ID_ is null) or (PI.SUSPENSION_STATE_ = 1) ) ) a where ROWNUM < ?) where rnum >= ? 2020-03-05 17:25:36,377 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - ==> Parameters: 2020-03-05 17:25:36.377(Timestamp), 2020-03-05 17:25:36.377(Timestamp), 2(Integer), 1(Integer) 2020-03-05 17:25:36,455 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - <== Total: 0 2020-03-05 17:25:36,614 DEBUG [impl.persistence.entity.HistoricDetailEntity.bulkInsertHistoricDetailVariableInstanceUpdate_oracle] - ==> Parameters: 8dcaeb292e504cee98af911229524979(String), VariableUpdate(String), b7a34a039dc74635bba47d4763cd5c9a(String), b7a34a039dc74635bba47d4763cd5c9a(String), null, null, flbmAssigneeList(String), 0(Integer), serializable(String), 2020-03-05 17:25:23.543(Timestamp), cc6836ebfe334fec91dbb7329c15bfd1(String), null, null, null, null, 9755d5dd0f7a49aa8778a6b1a499cb07(String), VariableUpdate(String), b7a34a039dc74635bba47d4763cd5c9a(String), b7a34a039dc74635bba47d4763cd5c9a(String), b93e9df098ae40da8b83ab758823266f(String), null, pass(String), 1(Integer), boolean(String), 2020-03-05 17:25:23.552(Timestamp), null, null, 1(Long), null, null, 8f3bd3bc2e0a40d98b7537ca470f2f61(String), VariableUpdate(String), b7a34a039dc74635bba47d4763cd5c9a(String), 66c63afb27a44c1688b44a0f6a216f5d(String), b93e9df098ae40da8b83ab758823266f(String), null, nrOfCompletedInstances(String), 1(Integer), integer(String), 2020-03-05 17:25:26.7(Timestamp), null, null, 1(Long), 1(String), null, 56100d82672d4bf99652a6d077d021cd(String), VariableUpdate(String), b7a34a039dc74635bba47d4763cd5c9a(String), 66c63afb27a44c1688b44a0f6a216f5d(String), b93e9df098ae40da8b83ab758823266f(String), null, nrOfActiveInstances(String), 1(Integer), integer(String), 2020-03-05 17:25:27.011(Timestamp), null, null, 0(Long), 0(String), null, a55c87971dad4b5dab889769bd8a4bbc(String), VariableUpdate(String), b7a34a039dc74635bba47d4763cd5c9a(String), 7e9d7306afd1405a9730796c25492472(String), 578a7c83fcbe454995939a1a0a1ba2f2(String), null, nrOfInstances(String), 0(Integer), integer(String), 2020-03-05 17:25:30.333(Timestamp), null, null, 1(Long), 1(String), null, f72352f58cac47549aa7e666feccbf6e(String), VariableUpdate(String), b7a34a039dc74635bba47d4763cd5c9a(String), 7e9d7306afd1405a9730796c25492472(String), 578a7c83fcbe454995939a1a0a1ba2f2(String), null, nrOfCompletedInstances(String), 0(Integer), integer(String), 2020-03-05 17:25:30.344(Timestamp), null, null, 0(Long), 0(String), null, 27f05823082647cdb5cca9cdf361adc4(String), VariableUpdate(String), b7a34a039dc74635bba47d4763cd5c9a(String), 7e9d7306afd1405a9730796c25492472(String), 578a7c83fcbe454995939a1a0a1ba2f2(String), null, nrOfActiveInstances(String), 0(Integer), integer(String), 2020-03-05 17:25:30.354(Timestamp), null, null, 1(Long), 1(String), null, df5596d20f0f40a9a80a76fc7569669b(String), VariableUpdate(String), b7a34a039dc74635bba47d4763cd5c9a(String), 024014e14ffb4e95b07060e129af8f1f(String), 578a7c83fcbe454995939a1a0a1ba2f2(String), null, loopCounter(String), 0(Integer), integer(String), 2020-03-05 17:25:30.586(Timestamp), null, null, 0(Long), 0(String), null, e4afcced22ab452998b859b450642d55(String), VariableUpdate(String), b7a34a039dc74635bba47d4763cd5c9a(String), 024014e14ffb4e95b07060e129af8f1f(String), 578a7c83fcbe454995939a1a0a1ba2f2(String), null, flbmAssignee(String), 0(Integer), string(String), 2020-03-05 17:25:30.926(Timestamp), null, null, null, scfl(String), null, dc64b76bb428492cb4c2e02eb34e2ed4(String), VariableUpdate(String), b7a34a039dc74635bba47d4763cd5c9a(String), b7a34a039dc74635bba47d4763cd5c9a(String), null, null, loopCounter(String), 0(Integer), integer(String), 2020-03-05 17:25:33.693(Timestamp), null, null, 0(Long), 0(String), null, 702030af6b9f46f59324986178556e24(String), VariableUpdate(String), b7a34a039dc74635bba47d4763cd5c9a(String), b7a34a039dc74635bba47d4763cd5c9a(String), null, null, jhbmAssignee(String), 0(Integer), string(String), 2020-03-05 17:25:33.702(Timestamp), null, null, null, scjh(String), null 2020-03-05 17:25:37,553 DEBUG [impl.persistence.entity.HistoricDetailEntity.bulkInsertHistoricDetailVariableInstanceUpdate_oracle] - <== Updates: 11 2020-03-05 17:25:38,455 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.bulkInsertHistoricVariableInstance_oracle] - ==> Preparing: INSERT ALL INTO ACT_HI_VARINST (ID_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_, CREATE_TIME_, LAST_UPDATED_TIME_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_VARINST (ID_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_, CREATE_TIME_, LAST_UPDATED_TIME_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_VARINST (ID_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_, CREATE_TIME_, LAST_UPDATED_TIME_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_VARINST (ID_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_, CREATE_TIME_, LAST_UPDATED_TIME_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_VARINST (ID_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_, CREATE_TIME_, LAST_UPDATED_TIME_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_VARINST (ID_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_, CREATE_TIME_, LAST_UPDATED_TIME_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_VARINST (ID_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_, CREATE_TIME_, LAST_UPDATED_TIME_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_VARINST (ID_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_, CREATE_TIME_, LAST_UPDATED_TIME_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SELECT * FROM dual 2020-03-05 17:25:38,855 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.bulkInsertHistoricVariableInstance_oracle] - ==> Parameters: 80be1bad33f04798bbb819b8e4bc7e72(String), b7a34a039dc74635bba47d4763cd5c9a(String), b7a34a039dc74635bba47d4763cd5c9a(String), null, flbmAssigneeList(String), 0(Integer), serializable(String), b8ed975def6b4a1fad9cb618c207aec5(String), null, null, null, null, 2020-03-05 17:25:23.541(Timestamp), 2020-03-05 17:25:23.541(Timestamp), 85da4781a4064ac483015e50581f40be(String), b7a34a039dc74635bba47d4763cd5c9a(String), 7e9d7306afd1405a9730796c25492472(String), null, nrOfInstances(String), 0(Integer), integer(String), null, null, 1(Long), 1(String), null, 2020-03-05 17:25:30.332(Timestamp), 2020-03-05 17:25:30.332(Timestamp), e92c275b73ba47f6937d59e24873c6f3(String), b7a34a039dc74635bba47d4763cd5c9a(String), 7e9d7306afd1405a9730796c25492472(String), null, nrOfCompletedInstances(String), 0(Integer), integer(String), null, null, 0(Long), 0(String), null, 2020-03-05 17:25:30.343(Timestamp), 2020-03-05 17:25:30.343(Timestamp), b6d91858263c4112b01b546d9820a0d8(String), b7a34a039dc74635bba47d4763cd5c9a(String), 7e9d7306afd1405a9730796c25492472(String), null, nrOfActiveInstances(String), 0(Integer), integer(String), null, null, 1(Long), 1(String), null, 2020-03-05 17:25:30.353(Timestamp), 2020-03-05 17:25:30.353(Timestamp), d5f306ba7fbe428cbb5511a592c70e1b(String), b7a34a039dc74635bba47d4763cd5c9a(String), 024014e14ffb4e95b07060e129af8f1f(String), null, loopCounter(String), 0(Integer), integer(String), null, null, 0(Long), 0(String), null, 2020-03-05 17:25:30.585(Timestamp), 2020-03-05 17:25:30.585(Timestamp), c56e783d9e6441718d451bf8a9b034f9(String), b7a34a039dc74635bba47d4763cd5c9a(String), 024014e14ffb4e95b07060e129af8f1f(String), null, flbmAssignee(String), 0(Integer), string(String), null, null, null, scfl(String), null, 2020-03-05 17:25:30.925(Timestamp), 2020-03-05 17:25:30.925(Timestamp), 751249edab7c4566b8c3d8e05ff44480(String), b7a34a039dc74635bba47d4763cd5c9a(String), b7a34a039dc74635bba47d4763cd5c9a(String), null, loopCounter(String), 0(Integer), integer(String), null, null, 0(Long), 0(String), null, 2020-03-05 17:25:33.692(Timestamp), 2020-03-05 17:25:33.692(Timestamp), d3f3d6908dde47698ff858499995a76f(String), b7a34a039dc74635bba47d4763cd5c9a(String), b7a34a039dc74635bba47d4763cd5c9a(String), null, jhbmAssignee(String), 0(Integer), string(String), null, null, null, scjh(String), null, 2020-03-05 17:25:33.701(Timestamp), 2020-03-05 17:25:33.701(Timestamp) 2020-03-05 17:25:39,516 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.bulkInsertHistoricVariableInstance_oracle] - <== Updates: 8 2020-03-05 17:25:39,553 DEBUG [impl.persistence.entity.HistoricTaskInstanceEntity.insertHistoricTaskInstance] - ==> Preparing: insert into ACT_HI_TASKINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, NAME_, PARENT_TASK_ID_, DESCRIPTION_, OWNER_, ASSIGNEE_, START_TIME_, CLAIM_TIME_, END_TIME_, DURATION_, DELETE_REASON_, TASK_DEF_KEY_, FORM_KEY_, PRIORITY_, DUE_DATE_, CATEGORY_, TENANT_ID_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) 2020-03-05 17:25:39,610 DEBUG [impl.persistence.entity.HistoricTaskInstanceEntity.insertHistoricTaskInstance] - ==> Parameters: 3d7ff2f6811d4722b492bcd7cb7de6af(String), rent_zczr:1:89f8f180b5d44c82bc0cba80cc6b21a3(String), b7a34a039dc74635bba47d4763cd5c9a(String), 024014e14ffb4e95b07060e129af8f1f(String), 法律部门审核(String), null, null, null, scfl(String), 2020-03-05 17:25:31.505(Timestamp), null, null, null, null, flbmsh(String), /rent/zczrshZybm(String), 50(Integer), null, null, (String) 2020-03-05 17:25:39,789 DEBUG [impl.persistence.entity.HistoricTaskInstanceEntity.insertHistoricTaskInstance] - <== Updates: 1 2020-03-05 17:25:40,053 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.bulkInsertHistoricActivityInstance_oracle] - ==> Preparing: INSERT ALL INTO ACT_HI_ACTINST ( ID_, 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_, DURATION_, TENANT_ID_ ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_ACTINST ( ID_, 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_, DURATION_, TENANT_ID_ ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SELECT * FROM dual 2020-03-05 17:25:40,157 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.bulkInsertHistoricActivityInstance_oracle] - ==> Parameters: 578a7c83fcbe454995939a1a0a1ba2f2(String), rent_zczr:1:89f8f180b5d44c82bc0cba80cc6b21a3(String), b7a34a039dc74635bba47d4763cd5c9a(String), 7e9d7306afd1405a9730796c25492472(String), flbmsh(String), 3d7ff2f6811d4722b492bcd7cb7de6af(String), null, 法律部门审核(String), userTask(String), scfl(String), 2020-03-05 17:25:30.32(Timestamp), null, null, (String), 1be546fd8af546b3ae2e6c286f0846e1(String), rent_zczr:1:89f8f180b5d44c82bc0cba80cc6b21a3(String), b7a34a039dc74635bba47d4763cd5c9a(String), 66c63afb27a44c1688b44a0f6a216f5d(String), end(String), null, null, 结束(String), endEvent(String), null, 2020-03-05 17:25:31.942(Timestamp), 2020-03-05 17:25:31.947(Timestamp), 5(Long), (String) 2020-03-05 17:25:40,407 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.bulkInsertHistoricActivityInstance_oracle] - <== Updates: 2 2020-03-05 17:25:40,425 DEBUG [impl.persistence.entity.HistoricIdentityLinkEntity.insertHistoricIdentityLink] - ==> Preparing: insert into ACT_HI_IDENTITYLINK (ID_, TYPE_, USER_ID_, GROUP_ID_, TASK_ID_, PROC_INST_ID_) values (?, ?, ?, ?, ?, ?) 2020-03-05 17:25:40,449 DEBUG [impl.persistence.entity.HistoricIdentityLinkEntity.insertHistoricIdentityLink] - ==> Parameters: 7283cdf8e0284a70b23f705ee1b97d5d(String), participant(String), scfl(String), null, null, b7a34a039dc74635bba47d4763cd5c9a(String) 2020-03-05 17:25:40,547 DEBUG [impl.persistence.entity.HistoricIdentityLinkEntity.insertHistoricIdentityLink] - <== Updates: 1 2020-03-05 17:25:40,792 DEBUG [impl.persistence.entity.ExecutionEntity.bulkInsertExecution_oracle] - ==> Preparing: INSERT ALL into ACT_RU_EXECUTION (ID_, REV_, PROC_INST_ID_, BUSINESS_KEY_, PROC_DEF_ID_, ACT_ID_, IS_ACTIVE_, IS_CONCURRENT_, IS_SCOPE_,IS_EVENT_SCOPE_, PARENT_ID_, SUPER_EXEC_, SUSPENSION_STATE_, CACHED_ENT_STATE_, TENANT_ID_, NAME_) VALUES (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) into ACT_RU_EXECUTION (ID_, REV_, PROC_INST_ID_, BUSINESS_KEY_, PROC_DEF_ID_, ACT_ID_, IS_ACTIVE_, IS_CONCURRENT_, IS_SCOPE_,IS_EVENT_SCOPE_, PARENT_ID_, SUPER_EXEC_, SUSPENSION_STATE_, CACHED_ENT_STATE_, TENANT_ID_, NAME_) VALUES (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SELECT * FROM dual 2020-03-05 17:25:40,899 DEBUG [impl.persistence.entity.ExecutionEntity.bulkInsertExecution_oracle] - ==> Parameters: 7e9d7306afd1405a9730796c25492472(String), b7a34a039dc74635bba47d4763cd5c9a(String), null, rent_zczr:1:89f8f180b5d44c82bc0cba80cc6b21a3(String), flbmsh(String), false(Boolean), false(Boolean), true(Boolean), false(Boolean), b7a34a039dc74635bba47d4763cd5c9a(String), null, 1(Integer), 6(Integer), (String), null, 024014e14ffb4e95b07060e129af8f1f(String), b7a34a039dc74635bba47d4763cd5c9a(String), null, rent_zczr:1:89f8f180b5d44c82bc0cba80cc6b21a3(String), flbmsh(String), true(Boolean), true(Boolean), false(Boolean), false(Boolean), 7e9d7306afd1405a9730796c25492472(String), null, 1(Integer), 7(Integer), (String), null 2020-03-05 17:25:41,139 DEBUG [impl.persistence.entity.ExecutionEntity.bulkInsertExecution_oracle] - <== Updates: 2 2020-03-05 17:25:41,171 DEBUG [impl.persistence.entity.TaskEntity.insertTask] - ==> Preparing: insert into ACT_RU_TASK (ID_, REV_, NAME_, PARENT_TASK_ID_, DESCRIPTION_, PRIORITY_, CREATE_TIME_, OWNER_, ASSIGNEE_, DELEGATION_, EXECUTION_ID_, PROC_INST_ID_, PROC_DEF_ID_, TASK_DEF_KEY_, DUE_DATE_, CATEGORY_, SUSPENSION_STATE_, TENANT_ID_, FORM_KEY_) values (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) 2020-03-05 17:25:41,224 DEBUG [impl.persistence.entity.TaskEntity.insertTask] - ==> Parameters: 3d7ff2f6811d4722b492bcd7cb7de6af(String), 法律部门审核(String), null, null, 50(Integer), 2020-03-05 17:25:30.97(Timestamp), null, scfl(String), null, 024014e14ffb4e95b07060e129af8f1f(String), b7a34a039dc74635bba47d4763cd5c9a(String), rent_zczr:1:89f8f180b5d44c82bc0cba80cc6b21a3(String), flbmsh(String), null, null, 1(Integer), (String), /rent/zczrshZybm(String) 2020-03-05 17:25:41,401 DEBUG [impl.persistence.entity.TaskEntity.insertTask] - <== Updates: 1 2020-03-05 17:25:41,421 DEBUG [impl.persistence.entity.IdentityLinkEntity.insertIdentityLink] - ==> Preparing: insert into ACT_RU_IDENTITYLINK (ID_, REV_, TYPE_, USER_ID_, GROUP_ID_, TASK_ID_, PROC_INST_ID_, PROC_DEF_ID_) values (?, 1, ?, ?, ?, ?, ?, ?) 2020-03-05 17:25:41,449 DEBUG [impl.persistence.entity.IdentityLinkEntity.insertIdentityLink] - ==> Parameters: 7283cdf8e0284a70b23f705ee1b97d5d(String), participant(String), scfl(String), null, null, b7a34a039dc74635bba47d4763cd5c9a(String), null 2020-03-05 17:25:41,488 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - ==> Preparing: select * from ( select a.*, ROWNUM rnum from ( select RES.* from ACT_RU_JOB RES LEFT OUTER JOIN ACT_RU_EXECUTION PI ON PI.ID_ = RES.PROCESS_INSTANCE_ID_ where (RES.RETRIES_ > 0) and (RES.DUEDATE_ is null or RES.DUEDATE_ <= ?) and (RES.LOCK_OWNER_ is null or RES.LOCK_EXP_TIME_ <= ?) and ( (RES.EXECUTION_ID_ is null) or (PI.SUSPENSION_STATE_ = 1) ) ) a where ROWNUM < ?) where rnum >= ? 2020-03-05 17:25:41,488 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - ==> Parameters: 2020-03-05 17:25:41.486(Timestamp), 2020-03-05 17:25:41.486(Timestamp), 2(Integer), 1(Integer) 2020-03-05 17:25:41,550 DEBUG [impl.persistence.entity.IdentityLinkEntity.insertIdentityLink] - <== Updates: 1 2020-03-05 17:25:41,565 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - <== Total: 0 2020-03-05 17:25:41,668 DEBUG [impl.persistence.entity.ByteArrayEntity.bulkInsertByteArray_oracle] - ==> Preparing: INSERT ALL into ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_) VALUES (?, 1, ?, ?, ?) into ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_) VALUES (?, 1, ?, ?, ?) into ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_) VALUES (?, 1, ?, ?, ?) SELECT * FROM dual 2020-03-05 17:25:41,721 DEBUG [impl.persistence.entity.ByteArrayEntity.bulkInsertByteArray_oracle] - ==> Parameters: 7bb43b3ae074482688f9cd47b9279dea(String), var-flbmAssigneeList(String), java.io.ByteArrayInputStream@12e26091(ByteArrayInputStream), null, b8ed975def6b4a1fad9cb618c207aec5(String), hist.var-flbmAssigneeList(String), java.io.ByteArrayInputStream@17175672(ByteArrayInputStream), null, cc6836ebfe334fec91dbb7329c15bfd1(String), hist.detail.var-flbmAssigneeList(String), java.io.ByteArrayInputStream@38920a(ByteArrayInputStream), null 2020-03-05 17:25:41,867 DEBUG [impl.persistence.entity.ByteArrayEntity.bulkInsertByteArray_oracle] - <== Updates: 3 2020-03-05 17:25:42,543 DEBUG [impl.persistence.entity.VariableInstanceEntity.bulkInsertVariableInstance_oracle] - ==> Preparing: INSERT ALL INTO ACT_RU_VARIABLE (ID_, REV_, TYPE_, NAME_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_RU_VARIABLE (ID_, REV_, TYPE_, NAME_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_RU_VARIABLE (ID_, REV_, TYPE_, NAME_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_RU_VARIABLE (ID_, REV_, TYPE_, NAME_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_RU_VARIABLE (ID_, REV_, TYPE_, NAME_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_RU_VARIABLE (ID_, REV_, TYPE_, NAME_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_RU_VARIABLE (ID_, REV_, TYPE_, NAME_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_RU_VARIABLE (ID_, REV_, TYPE_, NAME_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SELECT * FROM dual 2020-03-05 17:25:42,829 DEBUG [impl.persistence.entity.VariableInstanceEntity.bulkInsertVariableInstance_oracle] - ==> Parameters: 80be1bad33f04798bbb819b8e4bc7e72(String), serializable(String), flbmAssigneeList(String), b7a34a039dc74635bba47d4763cd5c9a(String), b7a34a039dc74635bba47d4763cd5c9a(String), null, 7bb43b3ae074482688f9cd47b9279dea(String), null, null, null, null, 85da4781a4064ac483015e50581f40be(String), integer(String), nrOfInstances(String), b7a34a039dc74635bba47d4763cd5c9a(String), 7e9d7306afd1405a9730796c25492472(String), null, null, null, 1(Long), 1(String), null, e92c275b73ba47f6937d59e24873c6f3(String), integer(String), nrOfCompletedInstances(String), b7a34a039dc74635bba47d4763cd5c9a(String), 7e9d7306afd1405a9730796c25492472(String), null, null, null, 0(Long), 0(String), null, b6d91858263c4112b01b546d9820a0d8(String), integer(String), nrOfActiveInstances(String), b7a34a039dc74635bba47d4763cd5c9a(String), 7e9d7306afd1405a9730796c25492472(String), null, null, null, 1(Long), 1(String), null, d5f306ba7fbe428cbb5511a592c70e1b(String), integer(String), loopCounter(String), b7a34a039dc74635bba47d4763cd5c9a(String), 024014e14ffb4e95b07060e129af8f1f(String), null, null, null, 0(Long), 0(String), null, c56e783d9e6441718d451bf8a9b034f9(String), string(String), flbmAssignee(String), b7a34a039dc74635bba47d4763cd5c9a(String), 024014e14ffb4e95b07060e129af8f1f(String), null, null, null, null, scfl(String), null, 751249edab7c4566b8c3d8e05ff44480(String), integer(String), loopCounter(String), b7a34a039dc74635bba47d4763cd5c9a(String), b7a34a039dc74635bba47d4763cd5c9a(String), null, null, null, 0(Long), 0(String), null, d3f3d6908dde47698ff858499995a76f(String), string(String), jhbmAssignee(String), b7a34a039dc74635bba47d4763cd5c9a(String), b7a34a039dc74635bba47d4763cd5c9a(String), null, null, null, null, scjh(String), null 2020-03-05 17:25:43,372 DEBUG [impl.persistence.entity.VariableInstanceEntity.bulkInsertVariableInstance_oracle] - <== Updates: 8 2020-03-05 17:25:43,404 DEBUG [impl.persistence.entity.HistoricTaskInstanceEntity.updateHistoricTaskInstance] - ==> Preparing: update ACT_HI_TASKINST set EXECUTION_ID_ = ?, NAME_ = ?, PARENT_TASK_ID_ = ?, DESCRIPTION_ = ?, OWNER_ = ?, ASSIGNEE_ = ?, CLAIM_TIME_ = ?, END_TIME_ = ?, DURATION_ = ?, DELETE_REASON_ = ?, TASK_DEF_KEY_ = ?, FORM_KEY_ = ?, PRIORITY_ = ?, DUE_DATE_ = ?, CATEGORY_ = ? where ID_ = ? 2020-03-05 17:25:43,453 DEBUG [impl.persistence.entity.HistoricTaskInstanceEntity.updateHistoricTaskInstance] - ==> Parameters: a32f7be1df484268a5137525f7482fc8(String), 计划部门审核(String), null, null, null, scjh(String), null, 2020-03-05 17:25:26.042(Timestamp), 783815(Long), completed(String), jhbmsh(String), /rent/zczrshZybm(String), 50(Integer), null, null, e10fc0d1e5a4472f8e3799780d806796(String) 2020-03-05 17:25:43,592 DEBUG [impl.persistence.entity.HistoricTaskInstanceEntity.updateHistoricTaskInstance] - <== Updates: 1 2020-03-05 17:25:43,615 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - ==> Preparing: update ACT_HI_VARINST set REV_ = ?, BYTEARRAY_ID_ = ?, DOUBLE_ = ?, LONG_ = ?, TEXT_ = ?, TEXT2_ = ?, VAR_TYPE_ = ?, LAST_UPDATED_TIME_ = ? where ID_ = ? and REV_ = ? 2020-03-05 17:25:43,652 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - ==> Parameters: 1(Integer), null, null, 1(Long), 1(String), null, integer(String), 2020-03-05 17:25:31.952(Timestamp), aa15f1aaa53243febef5fcfc2b0f6378(String), 0(Integer) 2020-03-05 17:25:43,767 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - <== Updates: 1 2020-03-05 17:25:43,789 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - ==> Preparing: update ACT_HI_VARINST set REV_ = ?, BYTEARRAY_ID_ = ?, DOUBLE_ = ?, LONG_ = ?, TEXT_ = ?, TEXT2_ = ?, VAR_TYPE_ = ?, LAST_UPDATED_TIME_ = ? where ID_ = ? and REV_ = ? 2020-03-05 17:25:43,825 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - ==> Parameters: 1(Integer), null, null, 0(Long), 0(String), null, integer(String), 2020-03-05 17:25:31.95(Timestamp), 95bf1206fafb4d94a382912c0e3d49d7(String), 0(Integer) 2020-03-05 17:25:43,946 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - <== Updates: 1 2020-03-05 17:25:43,968 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - ==> Preparing: update ACT_HI_VARINST set REV_ = ?, BYTEARRAY_ID_ = ?, DOUBLE_ = ?, LONG_ = ?, TEXT_ = ?, TEXT2_ = ?, VAR_TYPE_ = ?, LAST_UPDATED_TIME_ = ? where ID_ = ? and REV_ = ? 2020-03-05 17:25:44,003 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - ==> Parameters: 1(Integer), null, null, null, scjh(String), null, string(String), 2020-03-05 17:25:34.262(Timestamp), ccad23e5a3ae4791a0db8415196dfbe8(String), 0(Integer) 2020-03-05 17:25:44,118 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - <== Updates: 1 2020-03-05 17:25:44,142 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - ==> Preparing: update ACT_HI_VARINST set REV_ = ?, BYTEARRAY_ID_ = ?, DOUBLE_ = ?, LONG_ = ?, TEXT_ = ?, TEXT2_ = ?, VAR_TYPE_ = ?, LAST_UPDATED_TIME_ = ? where ID_ = ? and REV_ = ? 2020-03-05 17:25:44,177 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - ==> Parameters: 1(Integer), null, null, 0(Long), 0(String), null, integer(String), 2020-03-05 17:25:33.979(Timestamp), 9a88efabbcef4344a7ae082e5135d645(String), 0(Integer) 2020-03-05 17:25:44,306 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - <== Updates: 1 2020-03-05 17:25:44,327 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - ==> Preparing: update ACT_HI_VARINST set REV_ = ?, BYTEARRAY_ID_ = ?, DOUBLE_ = ?, LONG_ = ?, TEXT_ = ?, TEXT2_ = ?, VAR_TYPE_ = ?, LAST_UPDATED_TIME_ = ? where ID_ = ? and REV_ = ? 2020-03-05 17:25:44,365 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - ==> Parameters: 1(Integer), null, null, 1(Long), 1(String), null, integer(String), 2020-03-05 17:25:31.953(Timestamp), 32b25168f8d142099f15776efb4d0942(String), 0(Integer) 2020-03-05 17:25:44,479 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - <== Updates: 1 2020-03-05 17:25:44,500 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - ==> Preparing: update ACT_HI_VARINST set REV_ = ?, BYTEARRAY_ID_ = ?, DOUBLE_ = ?, LONG_ = ?, TEXT_ = ?, TEXT2_ = ?, VAR_TYPE_ = ?, LAST_UPDATED_TIME_ = ? where ID_ = ? and REV_ = ? 2020-03-05 17:25:44,535 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - ==> Parameters: 1(Integer), null, null, 1(Long), null, null, boolean(String), 2020-03-05 17:25:24.824(Timestamp), ca712ffb55ed4eaebd637337c36e402e(String), 0(Integer) 2020-03-05 17:25:44,664 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - <== Updates: 1 2020-03-05 17:25:44,682 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.updateHistoricActivityInstance] - ==> Preparing: update ACT_HI_ACTINST set EXECUTION_ID_ = ?, ASSIGNEE_ = ?, END_TIME_ = ?, DURATION_ = ? where ID_ = ? 2020-03-05 17:25:44,706 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.updateHistoricActivityInstance] - ==> Parameters: 66c63afb27a44c1688b44a0f6a216f5d(String), scjh(String), 2020-03-05 17:25:31.652(Timestamp), 789646(Long), b93e9df098ae40da8b83ab758823266f(String) 2020-03-05 17:25:44,796 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.updateHistoricActivityInstance] - <== Updates: 1 2020-03-05 17:25:44,812 DEBUG [impl.persistence.entity.TaskEntity.deleteTask] - ==> Preparing: delete from ACT_RU_TASK where ID_ = ? and REV_ = ? 2020-03-05 17:25:44,827 DEBUG [impl.persistence.entity.TaskEntity.deleteTask] - ==> Parameters: e10fc0d1e5a4472f8e3799780d806796(String), 1(Integer) 2020-03-05 17:25:44,896 DEBUG [impl.persistence.entity.TaskEntity.deleteTask] - <== Updates: 1 2020-03-05 17:25:44,908 DEBUG [impl.persistence.entity.VariableInstanceEntity.deleteVariableInstance] - ==> Preparing: delete from ACT_RU_VARIABLE where ID_ = ? and REV_ = ? 2020-03-05 17:25:44,923 DEBUG [impl.persistence.entity.VariableInstanceEntity.deleteVariableInstance] - ==> Parameters: 95bf1206fafb4d94a382912c0e3d49d7(String), 1(Integer) 2020-03-05 17:25:45,000 DEBUG [impl.persistence.entity.VariableInstanceEntity.deleteVariableInstance] - <== Updates: 1 2020-03-05 17:25:45,016 DEBUG [impl.persistence.entity.VariableInstanceEntity.deleteVariableInstance] - ==> Preparing: delete from ACT_RU_VARIABLE where ID_ = ? and REV_ = ? 2020-03-05 17:25:45,032 DEBUG [impl.persistence.entity.VariableInstanceEntity.deleteVariableInstance] - ==> Parameters: aa15f1aaa53243febef5fcfc2b0f6378(String), 1(Integer) 2020-03-05 17:25:45,108 DEBUG [impl.persistence.entity.VariableInstanceEntity.deleteVariableInstance] - <== Updates: 1 2020-03-05 17:25:45,122 DEBUG [impl.persistence.entity.VariableInstanceEntity.deleteVariableInstance] - ==> Preparing: delete from ACT_RU_VARIABLE where ID_ = ? and REV_ = ? 2020-03-05 17:25:45,137 DEBUG [impl.persistence.entity.VariableInstanceEntity.deleteVariableInstance] - ==> Parameters: 32b25168f8d142099f15776efb4d0942(String), 1(Integer) 2020-03-05 17:25:45,214 DEBUG [impl.persistence.entity.VariableInstanceEntity.deleteVariableInstance] - <== Updates: 1 2020-03-05 17:25:45,229 DEBUG [impl.persistence.entity.ExecutionEntity.deleteExecution] - ==> Preparing: delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ? 2020-03-05 17:25:45,244 DEBUG [impl.persistence.entity.ExecutionEntity.deleteExecution] - ==> Parameters: 66c63afb27a44c1688b44a0f6a216f5d(String), 1(Integer) 2020-03-05 17:25:48,284 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - ==> Preparing: select * from ( select a.*, ROWNUM rnum from ( select RES.* from ACT_RU_JOB RES LEFT OUTER JOIN ACT_RU_EXECUTION PI ON PI.ID_ = RES.PROCESS_INSTANCE_ID_ where (RES.RETRIES_ > 0) and (RES.DUEDATE_ is null or RES.DUEDATE_ <= ?) and (RES.LOCK_OWNER_ is null or RES.LOCK_EXP_TIME_ <= ?) and ( (RES.EXECUTION_ID_ is null) or (PI.SUSPENSION_STATE_ = 1) ) ) a where ROWNUM < ?) where rnum >= ? org.apache.ibatis.exceptions.PersistenceException: ### Error updating database. Cause: java.sql.SQLException: ORA-02292: 违反完整约束条件 (EAM.SYS_C0018471) - 已找到子记录 2020-03-05 17:25:48,284 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - ==> Parameters: 2020-03-05 17:25:48.284(Timestamp), 2020-03-05 17:25:48.284(Timestamp), 2(Integer), 1(Integer) ### The error may involve org.activiti.engine.impl.persistence.entity.ExecutionEntity.deleteExecution-Inline ### The error occurred while setting parameters ### SQL: delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ? ### Cause: java.sql.SQLException: ORA-02292: 违反完整约束条件 (EAM.SYS_C0018471) - 已找到子记录 ``` ```![图片说明](https://img-ask.csdn.net/upload/202003/05/1583402296_781060.png) ``` ```不能删除ACT_RU_EXECUTION 表中的记录, delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ? ### Cause: java.sql.SQLException: ORA-02292: 违反完整约束条件
©️2020 CSDN 皮肤主题: 大白 设计师:CSDN官方博客 返回首页