topic Database blocking when use moveDeadLetterJobToExecutableJob method in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/database-blocking-when-use-movedeadletterjobtoexecutablejob/m-p/12234#M5389 <HTML><HEAD></HEAD><BODY><P style="color: #000000; background-color: rgba(240, 240, 240, 0.3); padding: 0.2em 0px;">we have move activiti 5.15.1 to activiti 6.0.0.4 version.</P><P style="color: #000000; background-color: rgba(240, 240, 240, 0.3); padding: 0.2em 0px;">when we resume job of activiti 5 with following command that time it was block the Database when we are get varible after the move job.</P><P style="color: #000000; background-color: rgba(240, 240, 240, 0.3); padding: 0.2em 0px;"></P><P style="color: #000000; background-color: rgba(240, 240, 240, 0.3); padding: 0.2em 0px 0px;"><CODE style="background-color: rgba(192, 201, 200, 0.2); border: 1px solid rgba(192, 201, 200, 0.4); font-size: 0.875em; padding: 0px 4px;">processEngine.getManagementService().moveDeadLetterJobToExecutableJob(Jobobj.getId(),1); </CODE></P><P style="color: #000000; background-color: rgba(240, 240, 240, 0.3); padding: 0.2em 0px 0px;"><CODE style="background-color: rgba(192, 201, 200, 0.2); border: 1px solid rgba(192, 201, 200, 0.4); font-size: 0.875em; padding: 0px 4px;">Map&lt;String, Object&gt; variables = workflowService.getVariableByProcessInstance(String.valueOf(processInstanceId));</CODE></P><P style="color: #000000; background-color: rgba(240, 240, 240, 0.3); padding: 0.2em 0px 0px;"></P><P style="color: #000000; background-color: rgba(240, 240, 240, 0.3); padding: 0.2em 0px 0px;">As per my observation it was not release the session of<BR /><CODE style="background-color: rgba(192, 201, 200, 0.2); border: 1px solid rgba(192, 201, 200, 0.4); font-size: 0.875em; padding: 0px 4px;">delete from ACT_GE_BYTEARRAY where ID_ = ? and REV_ = ?</CODE></P><P style="color: #000000; background-color: rgba(240, 240, 240, 0.3); padding: 0.2em 0px 0px;">Please find the attachment for more details.</P><P style="color: #000000; background-color: rgba(240, 240, 240, 0.3); padding: 0.2em 0px 0px;"></P><P style="color: #000000; background-color: rgba(240, 240, 240, 0.3); padding: 0.2em 0px 0px;">Please do needful.</P></BODY></HTML> Mon, 19 Aug 2019 08:58:50 GMT jkanjariya 2019-08-19T08:58:50Z Database blocking when use moveDeadLetterJobToExecutableJob method https://connect.hyland.com/t5/alfresco-forum/database-blocking-when-use-movedeadletterjobtoexecutablejob/m-p/12234#M5389 we have move activiti 5.15.1 to activiti 6.0.0.4 version.when we resume job of activiti 5 with following command that time it was block the Database when we are get varible after the move job.processEngine.getManagementService().moveDeadLetterJobToExecutableJob(Jobobj.getId(),1); Map&lt;String, Obje Mon, 19 Aug 2019 08:58:50 GMT https://connect.hyland.com/t5/alfresco-forum/database-blocking-when-use-movedeadletterjobtoexecutablejob/m-p/12234#M5389 jkanjariya 2019-08-19T08:58:50Z