topic Re: Exception when deleting/canceling an activiti process instance in Alfresco Forum

Exception when deleting/canceling an activiti process instance

emadhusam — Fri, 19 Jul 2019 10:21:57 GMT

Hi, I am using Alfresco One Enterprise with activiti.I created and published a couple of activity apps. The apps includes some processes with javascript actions. When I started an instance of the processes I figured out that there are some errors in the scripts so I corrected the processes published

Re: Exception when deleting/canceling an activiti process instance

jose_leon_coupa — Thu, 17 Dec 2020 20:08:38 GMT

Hi @emadhusam ,

Have you found a solution to this problem? I have a similar situation and I'm looking for a solution. Thanks!

Re: Exception when deleting/canceling an activiti process instance

emadhusam — Fri, 18 Dec 2020 07:58:26 GMT

Hello,

You have to delete the processes from the database first.

whereas you have to replace X with the instance ID of the problematic instance:

delete from ACT_EVT_LOG where proc_inst_id_ = 'X';
delete from ACT_RU_JOB where process_instance_id_ in (select id_ from ACT_RU_EXECUTION where proc_inst_id_ = 'X');
delete from ACT_RU_VARIABLE where proc_inst_id_ in (select id_ from ACT_RU_EXECUTION where proc_inst_id_ = 'X');
delete from ACT_GE_BYTEARRAY where id_ in (select id_ from ACT_RU_VARIABLE where proc_inst_id_ = 'X');
delete from ACT_RU_EVENT_SUBSCR where proc_inst_id_ = 'X';
delete from ACT_RU_IDENTITYLINK where proc_inst_id_ = 'X';
delete from ACT_RU_TASK where proc_inst_id_ = 'X';

// Take the parent_id into account for subprocesses
delete from ACT_RU_EXECUTION where parent_id_ = 'X';
delete from ACT_RU_EXECUTION where proc_inst_id_ = 'X' or id_ = 'X';
delete from ACT_HI_ACTINST where proc_inst_id_ = 'X' or execution_id_ = 'X';
delete from ACT_HI_PROCINST where proc_inst_id_ = 'X' or id_ = 'X';
delete from ACT_HI_TASKINST where proc_inst_id_ = 'X' or id_ = 'X';
delete from ACT_HI_VARINST where proc_inst_id_ = 'X' or execution_id_ = 'X';
delete from ACT_HI_DETAIL where proc_inst_id_ = 'X' or execution_id_ = 'X';
delete from ACT_HI_IDENTITYLINK where proc_inst_id_ ='X';

Re: Exception when deleting/canceling an activiti process instance

jose_leon_coupa — Fri, 18 Dec 2020 08:13:26 GMT

Thank you @emadhusam !

Re: Exception when deleting/canceling an activiti process instance

emadhusam — Fri, 18 Dec 2020 08:15:29 GMT

You are welcome.