Hi Lionel, glad to read that you did solve. Regards.
On 05/10/23 17:47, Lionel SCHWARZ wrote:
OK that was tricky but I finally found out that: - I have to update table ACT_RU_ACTINST as well - the UPDATE ACT_RU_EXECUTION is actually: UPDATE ACT_RU_EXECUTION SET PROC_DEF_ID_ = 'userWorkflow:X:XXXX' WHERE PROC_INST_ID_ = <PROC_INST>; It seems to work like this Sorry for the noise, best regards Lionel ----- Le 5 Oct 23, à 17:15, Lionel SCHWARZ [email protected] a écrit :Dear all, After deploying a new userWorkflow definition (PUT /flowable/bpmnProcesses/userWorkflow), I tried to upgrade a user to this new workflow, executing the following steps: - stop Syncope - connect to DB - get the definition id of the new workflow: SELECT ID_ FROM ACT_RE_PROCDEF WHERE KEY_ = 'userWorkflow' ORDER BY VERSION_ DESC; - get the process instance of the user: SELECT ID_ FROM ACT_RU_EXECUTION BUSINESS_KEY_ = concat('userWorkflow:', <USERKEY>) - update both with the new definition id UPDATE ACT_RU_EXECUTION SET PROC_DEF_ID_ = 'userWorkflow:X:XXXX' WHERE ID_ = <PROC_INST>; UPDATE ACT_RU_TASK SET PROC_DEF_ID_ = 'userWorkflow:X:XXXX' WHERE ID_ IS NOT NULL AND PROC_INST_ID_ = <PROC_INST>; - restart Syncope But it seems something is still missing because updating the user does seem to use the new workflow... Is there another table to update? Regards Lionel
-- Francesco Chicchiriccò Tirasa - Open Source Excellence http://www.tirasa.net/ Member at The Apache Software Foundation Syncope, Cocoon, Olingo, CXF, OpenJPA, PonyMail http://home.apache.org/~ilgrosso/
