Hi Clemens, Here is a script I have tested on my DEV instance (not in production yet though) to upgrade all users to the latest workflow def.
SET @ WfDefId = ( SELECT ID_ FROM ACT_RE_PROCDEF WHERE KEY_ = 'userWorkflow' AND VERSION_ = ( SELECT MAX ( VERSION_ ) FROM ACT_RE_PROCDEF ) ) ; UPDATE ACT_RU_EXECUTION SET PROC_DEF_ID_ = @ WfDefId WHERE ID_ IS NOT NULL ; UPDATE ACT_RU_TASK SET PROC_DEF_ID_ = @ WfDefId WHERE ID_ IS NOT NULL ; UPDATE ACT_RU_ACTINST SET PROC_DEF_ID_ = @ WfDefId WHERE ID_ IS NOT NULL ; My feeling is that when you update the workflow you have to keep the compatibility with previous version, from the variables point of view I mean. Regards Lionel ----- Le 18 Jan 24, à 9:23, Clemens Bergmann <clemens.bergm...@tu-darmstadt.de> a écrit : > Hello Samuel, > thanks for this hint. I tried to find out which database tables I would have > to > update but I am not sure. > If I understand it correctly ACT_RE_PROCDEF contains the versions of the > defined > workflows. ACT_HI_PROCINST seems to contain the instances of these workflows > and I would suspect that I would have to change the PROC_DEF_ID_ table to > match > the ID_ value from ACT_RE_PROCDEF. The first thing that seems to be strange is > the fact that we have 9 entries in this database but only 8 users. > I was not able to find the link between the workflow instances and the users. > There seem to be two tables (ACT_HI_VARINST and ACT_RU_VARIABLE) but I am not > sure which one is used. > A hint in the right direction would be appreciated. > Kind regards > Clemens (Bergmann) > -- > Clemens Bergmann > [er/ihm; he/him] > Gruppe Nutzermanagement und Entwicklung > Technische Universität Darmstadt > Hochschulrechenzentrum, Alexanderstraße 2, 64283 Darmstadt > Tel. +49 6151 16 71184 > [ http://www.hrz.tu-darmstadt.de/ | http://www.hrz.tu-darmstadt.de/ ]
smime.p7s
Description: S/MIME Cryptographic Signature
