topic Re: re-opening closed process and setting to praticular task in Alfresco Archive

re-opening closed process and setting to praticular task

danielporter1 — Thu, 01 Sep 2016 18:38:27 GMT

Hi there,I'm working on re-opening a process and setting it to the last task in the workflow by directly modifying the database. Right now I'm changing information in 8 tables - adding an execution, adding an act_ru_task, adding a new act_hi_actinst, adding a new act_hi_taskinst, modifying the act_h

Re: re-opening closed process and setting to praticular task

danielporter1 — Thu, 01 Sep 2016 18:54:40 GMT

Oops, posted the the wrong stored proc code. This is the invocation I was actually using:

create or replace function setClosedProcessToManagerReview(proc_inst_id character varying (64), proc_def_id character varying(64))
returns BOOLEAN LANGUAGE plpgsql AS
$$
BEGIN

INSERT INTO act_ru_execution select id_, 1, proc_inst_id_, business_key_, null, proc_def_id_, null, 'a5managerreview', true, false, true, false, 1, 2, '', null, null
FROM act_hi_procinst
WHERE proc_inst_id_ = proc_inst_id;

INSERT INTO act_ru_task
SELECT (SELECT cast(max(cast(id_ as int)) + 3 as character varying (64)) FROM act_ru_task) as id_,
2,
proc_inst_id,
proc_inst_id,
proc_def_id, 'Manager Review', null , null, 'a5managerreview', null, null, null, 50, now(), null, null, 1, '', '/app/viewdocument/review/';

INSERT INTO act_hi_actinst
SELECT (select cast(max(cast(id_ as int)) + 3 as character varying (64)) from act_hi_actinst), proc_def_id, proc_inst_id, proc_inst_id, 'a5managerreview',
(SELECT id_ FROM act_ru_task WHERE proc_inst_id_ = proc_inst_id), null, 'Manager Review', 'userTask', null, now(), null, null, '';

INSERT INTO act_hi_taskinst
select id_, proc_def_id_, task_def_key_, proc_inst_id_, execution_id_, name_,
null, null, null, assignee_, create_time_, null, null, null, null, 50, null, form_key_, category_, tenant_id_ FROM act_ru_task WHERE proc_inst_id_ = proc_inst_id;

UPDATE act_hi_procinst
SET end_time_ = null, duration_=null, end_act_id_ = null
WHERE proc_inst_id_ = proc_inst_id;

INSERT INTO act_ru_variable
SELECT id_, rev_, var_type_, name_, execution_id_, proc_inst_id_, task_id_, bytearray_id_, double_, long_, text_, text2_
FROM act_hi_varinst
WHERE proc_inst_id_ = proc_inst_id;

INSERT INTO act_ru_identitylink
SELECT (SELECT cast(max(cast(id_ as int)) + 3 as character varying (64)) FROM act_ru_identitylink),
1, 'ProjectLeader', 'candidate', null, (SELECT id_ FROM act_ru_task WHERE proc_inst_id_ = proc_inst_id), null, null;
return true;
END;
$$;
select setClosedProcessToManagerReview(proc_inst_id_, 'documentupload:23:1722512') from act_hi_procinst
WHERE end_time_ is not null AND end_act_id_ = 'a6goodocrfinish' AND delete_reason_ is null;

Re: re-opening closed process and setting to praticular task

martin_grofcik — Fri, 02 Sep 2016 07:45:42 GMT

Hi Daniel,

From my point of view the the described approach to get the last task of the process alive again is wrong. What is done - is done.

you can encapsulate the last task to the subprocess. When the process is completed and you want to create new last task process, just create new process from these subprocess.
add message event with loop back + timer intermediate events to the end of the process. Process instance will wait some time and when message (to make last task alive again) comes the loop brings execution to the task again

Regards
Martin

Re: re-opening closed process and setting to praticular task

thuynh — Tue, 13 Dec 2016 08:01:32 GMT

bp3‌

Hi Daniel,

Sorry for super late reply here.

Just want to check in with you whether this is still an issue for you that needs our help to resolve?

If it is, please elaborate what you're trying to do a bit more clear please? You said you want to:

re-opening a process and setting it to the last task

by directly modifying the database

Let's stop here. First of all, directly manipulating the database of the activiti-engine is totally a wrong approach. This is not supported by product and is very likely to break the entire engine.

Instead, please let us know your use case and what you are trying to achieve. What do you mean by 'setting it to the last task'?

Thank you,