topic Bulk Delete Process Instances in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/bulk-delete-process-instances/m-p/211851#M164981 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>I discovered that due to a bug in one of my Java service tasks, my business process was never being completed. There are several thousand processes instances that are still listed as running, that should really be completed. This is causing all sorts of issues with memory.</SPAN><BR /><BR /><SPAN>I'm wondering if there is a way to complete these process instances in bulk? Could I maybe update the database tables directly to stop these from running?</SPAN><BR /><BR /><SPAN>Thanks!</SPAN><BR /><BR /><SPAN>Sean</SPAN></BODY></HTML> Thu, 24 Nov 2016 21:59:58 GMT brewmaster 2016-11-24T21:59:58Z Bulk Delete Process Instances https://connect.hyland.com/t5/alfresco-archive/bulk-delete-process-instances/m-p/211851#M164981 Hello,I discovered that due to a bug in one of my Java service tasks, my business process was never being completed. There are several thousand processes instances that are still listed as running, that should really be completed. This is causing all sorts of issues with memory.I'm wondering if ther Thu, 24 Nov 2016 21:59:58 GMT https://connect.hyland.com/t5/alfresco-archive/bulk-delete-process-instances/m-p/211851#M164981 brewmaster 2016-11-24T21:59:58Z Re: Bulk Delete Process Instances https://connect.hyland.com/t5/alfresco-archive/bulk-delete-process-instances/m-p/211852#M164982 <HTML><HEAD></HEAD><BODY><P>While it is possible to do this directly in the database, I believe the best options would be to write a simple unit test that connected to the production database and :<BR /><BR />1. retrieved all the bad tasks (using runtimeService.createProcessInstanceQuery().....<BR />2. iterate over the returned list and terminate the instances (runtimeService.deleteProcessInstance(instanceId, reason)</P><P></P><P>Another alternative would be a similar approach using a script and curl against the REST API.</P><P>Let me know if you need some sample code.</P><P></P><P>Greg</P><P><A href="https://migration33.stage.lithium.com/t5/tag/bp3/tg-p"></A>‌</P></BODY></HTML> Wed, 21 Dec 2016 19:31:28 GMT https://connect.hyland.com/t5/alfresco-archive/bulk-delete-process-instances/m-p/211852#M164982 gdharley 2016-12-21T19:31:28Z