topic Undeploy workflow taking long time and UI page timeouts meantime in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/undeploy-workflow-taking-long-time-and-ui-page-timeouts-meantime/m-p/31523#M13370 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am using Activiti v5.21 and I have a real time workflow with 70 active instances(in least case) and each process instance consists of 150 tasks. I am using API call to delete deployment -&nbsp;<EM>repositoryService.deleteDeployment(deploymentId, true);</EM></P><P></P><P>When I am trying to undeploy that workflow, its took almost 3 minutes and mean time my UI page timeout happened. When I gone inside of the undeploy, I found some interesting things as below.</P><P>1) select queries on ACT_HI_VARINST and ACT_RU_VARIABLE tables. For instance, there are 70*150 *2 (instances * variable count * 2 VAR tables) = 21000 select queries which is consuming most of the execution time (~2/3 of execution time) which can be minimized by considering process_inst_id_ value.</P><P><SPAN style="font-family: arial;"><CODE style="font-size: 9pt;">10-May-2017[07:18:31.722]::smileyvery-happy:EBUG::ajp-nio-10002-exec-18::smileysurprised:rg.activiti.engine.impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId:132 - ==&gt; Preparing: select * from ACT_HI_VARINST where ID_ = ? <BR />10-May-2017[07:18:31.723]::smileyvery-happy:EBUG::ajp-nio-10002-exec-18::smileysurprised:rg.activiti.engine.impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId:132 - ==&gt; Parameters: e4c1eeae-3575-11e7-89d1-020030001cf1(String) <BR />10-May-2017[07:18:31.726]::smileyvery-happy:EBUG::ajp-nio-10002-exec-18::smileysurprised:rg.activiti.engine.impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId:132 - &lt;== Total: 1 </CODE></SPAN></P><P></P><P>2) After collecting entities using select queries, While deleting Its doing bulk deletes for few tables but not for ACT_RU_VARIABLE and ACT_HI_VARINST tables. Not sure why these 2 tables not considered for bulk deletes using process instance Id which is consuming more time during un deployment.</P><P></P><P>Is there any other way to do faster un deployment process to avoid UI page timeouts. Attached my use case activiti log file for reference.</P><P></P><P>Any suggestions will be appreciated.</P><P></P><P>thanks,</P><P>Swamy.</P></BODY></HTML> Wed, 10 May 2017 16:03:37 GMT swamy2156 2017-05-10T16:03:37Z Undeploy workflow taking long time and UI page timeouts meantime https://connect.hyland.com/t5/alfresco-forum/undeploy-workflow-taking-long-time-and-ui-page-timeouts-meantime/m-p/31523#M13370 Hi,I am using Activiti v5.21 and I have a real time workflow with 70 active instances(in least case) and each process instance consists of 150 tasks. I am using API call to delete deployment -&nbsp;repositoryService.deleteDeployment(deploymentId, true);When I am trying to undeploy that workflow, its took Wed, 10 May 2017 16:03:37 GMT https://connect.hyland.com/t5/alfresco-forum/undeploy-workflow-taking-long-time-and-ui-page-timeouts-meantime/m-p/31523#M13370 swamy2156 2017-05-10T16:03:37Z Re: Undeploy workflow taking long time and UI page timeouts meantime https://connect.hyland.com/t5/alfresco-forum/undeploy-workflow-taking-long-time-and-ui-page-timeouts-meantime/m-p/31524#M13371 <HTML><HEAD></HEAD><BODY><P>By the way, I am using Oracle 11g RAC database for my application.</P></BODY></HTML> Thu, 11 May 2017 10:29:19 GMT https://connect.hyland.com/t5/alfresco-forum/undeploy-workflow-taking-long-time-and-ui-page-timeouts-meantime/m-p/31524#M13371 swamy2156 2017-05-11T10:29:19Z Re: Undeploy workflow taking long time and UI page timeouts meantime https://connect.hyland.com/t5/alfresco-forum/undeploy-workflow-taking-long-time-and-ui-page-timeouts-meantime/m-p/31525#M13372 <HTML><HEAD></HEAD><BODY><P>this appears to be a duplicate of :&nbsp;<A __default_attr="231320" __jive_macro_name="thread" _jive_internal="true" class="jive_macro_thread jive_macro link-titled" href="https://community.alfresco.com/thread/231320-undeploying-workflow-taking-long-time" rel="nofollow noopener noreferrer"></A>&nbsp;</P></BODY></HTML> Thu, 11 May 2017 16:48:25 GMT https://connect.hyland.com/t5/alfresco-forum/undeploy-workflow-taking-long-time-and-ui-page-timeouts-meantime/m-p/31525#M13372 gdharley 2017-05-11T16:48:25Z