AnsweredAssumed Answered

version migration problem

Question asked by nemesis1 on Oct 10, 2013
Latest reply on Oct 10, 2013 by nemesis1
Hi;

I am trying to migrate a process to newer version of same process. But I have  a problem. All processes can not be migrated to process. When I  run my process on debug mode , I see that "all processes waiting to be executed on embedded sub process" can not be migrated to newer version. and I also have some findings below;

1) proc_def_id column on act_hi_procinst is updated but proc_def_id columns of  act_ru_task task,act_ru_execution,ACT_HI_TASKINST tables are not updated.


2) when I run the code below
"runtimeService.createProcessInstanceQuery().processDefinitionId(processDefinitionId);"

it generates a sql below.

"
select * from (
select a.*, ROWNUM rnum from (
select distinct RES.* , P.KEY_ as ProcessDefinitionKey, P.ID_ as ProcessDefinitionId from ACT_RU_EXECUTION RES
inner join ACT_RE_PROCDEF P on RES.PROC_DEF_ID_ = P.ID_
WHERE RES.PARENT_ID_ is null and P.ID_ = ? and (RES.SUSPENSION_STATE_ = 1) order by RES.ID_ asc ) a where ROWNUM < ?) where rnum >= ?
"

3) when I check the related records on ACT_RU_EXECUTION , all tasks on embedded subprocess have  PARENT_ID.

Is there any error on this method.  Or I have to apply a different methods or procedure to migrate processes having embedded subprocess.

Thanks for your help..

Outcomes