topic version migration problem in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/version-migration-problem/m-p/163909#M117682 <HTML><HEAD></HEAD><BODY><SPAN>Hi;</SPAN><BR /><BR /><SPAN>I am trying to migrate a process to newer version of same process. But I have&nbsp; a problem. All processes can not be migrated to process. When I&nbsp; 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;</SPAN><BR /><BR /><SPAN>1) proc_def_id column on act_hi_procinst is updated but proc_def_id columns of&nbsp; act_ru_task task,act_ru_execution,ACT_HI_TASKINST tables are not updated.</SPAN><BR /><BR /><BR /><SPAN>2) when I run the code below</SPAN><BR /><SPAN>"runtimeService.createProcessInstanceQuery().processDefinitionId(processDefinitionId);"</SPAN><BR /><BR /><SPAN>it generates a sql below.</SPAN><BR /><BR /><SPAN>"</SPAN><BR /><SPAN>select * from (</SPAN><BR /><SPAN> select a.*, ROWNUM rnum from ( </SPAN><BR /><SPAN> select distinct RES.* , P.KEY_ as ProcessDefinitionKey, P.ID_ as ProcessDefinitionId from ACT_RU_EXECUTION RES </SPAN><BR /><SPAN> inner join ACT_RE_PROCDEF P on RES.PROC_DEF_ID_ = P.ID_ </SPAN><BR /><SPAN> WHERE RES.PARENT_ID_ is null and P.ID_ = ? and (RES.SUSPENSION_STATE_ = 1) order by RES.ID_ asc ) a where ROWNUM &lt; ?) where rnum &gt;= ?</SPAN><BR /><SPAN> "</SPAN><BR /><BR /><SPAN>3) when I check the related records on ACT_RU_EXECUTION , all tasks on embedded subprocess have&nbsp; PARENT_ID.</SPAN><BR /><BR /><SPAN>Is there any error on this method.&nbsp; Or I have to apply a different methods or procedure to migrate processes having embedded subprocess. </SPAN><BR /><BR /><SPAN>Thanks for your help..</SPAN></BODY></HTML> Thu, 10 Oct 2013 11:26:18 GMT nemesis1 2013-10-10T11:26:18Z version migration problem https://connect.hyland.com/t5/alfresco-archive/version-migration-problem/m-p/163909#M117682 Hi;I am trying to migrate a process to newer version of same process. But I have&nbsp; a problem. All processes can not be migrated to process. When I&nbsp; 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 Thu, 10 Oct 2013 11:26:18 GMT https://connect.hyland.com/t5/alfresco-archive/version-migration-problem/m-p/163909#M117682 nemesis1 2013-10-10T11:26:18Z Re: version migration problem https://connect.hyland.com/t5/alfresco-archive/version-migration-problem/m-p/163910#M117683 <HTML><HEAD></HEAD><BODY><SPAN>How are you doing that migration? Did you write your own logic for it?</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Thu, 10 Oct 2013 12:23:25 GMT https://connect.hyland.com/t5/alfresco-archive/version-migration-problem/m-p/163910#M117683 trademak 2013-10-10T12:23:25Z Re: version migration problem https://connect.hyland.com/t5/alfresco-archive/version-migration-problem/m-p/163911#M117684 <HTML><HEAD></HEAD><BODY><SPAN>Thanks for your fast reply.</SPAN><BR /><BR /><SPAN>activiti project was embedded into our project. We are using your api methods. </SPAN><BR /><BR /><SPAN> To migrate processes we are calling activiti method below</SPAN><BR /><BR /><SPAN>"setProcessDefinitonVersion(processInstanceId, processDefinitionVersion);"</SPAN><BR /><BR /><SPAN>To obtain processInstanceIds, we are using runtimeService.createProcessInstanceQuery().processDefinitionId(processDefinitionId) method, but it does not return the instances having parent id (tasks on embedded subprocess). did I call correct method to obtain processInstanceIds.</SPAN><BR /><BR /><BR /><SPAN>Thanks</SPAN><BR /><BR /><BR /><BR /><BR /></BODY></HTML> Thu, 10 Oct 2013 14:40:24 GMT https://connect.hyland.com/t5/alfresco-archive/version-migration-problem/m-p/163911#M117684 nemesis1 2013-10-10T14:40:24Z Re: version migration problem https://connect.hyland.com/t5/alfresco-archive/version-migration-problem/m-p/163912#M117685 <HTML><HEAD></HEAD><BODY><SPAN>You probably will need a more advanced query, cause like you noticed it doesnt incoporate subprocesses and such.</SPAN></BODY></HTML> Mon, 21 Oct 2013 10:07:29 GMT https://connect.hyland.com/t5/alfresco-archive/version-migration-problem/m-p/163912#M117685 jbarrez 2013-10-21T10:07:29Z