topic Re: Switch running process instances to newer Process-Model-Version in Alfresco Archive

Switch running process instances to newer Process-Model-Version

stephan_bauer — Tue, 07 Jul 2015 09:20:52 GMT

Hi,I have read http://forums.activiti.org/content/anyone-know-how-fit-such-requestIn our case, we have 3 deployed Versions of the business process.All relevant instances are currently waiting in an Event-Gateway, and the Event-GW still exists in the latest version. The cookbook described at the bott

Re: Switch running process instances to newer Process-Model-Version

jbarrez — Tue, 07 Jul 2015 12:30:33 GMT

In theory yes, if the process is closely matching. If you changed stuff like parallel paths, subprocesses etc where the execution currently is at, then it won't be as easy.

Re: Switch running process instances to newer Process-Model-Version

martin_grofcik — Thu, 09 Jul 2015 13:30:51 GMT

Hi Stephan,

In your case I would check subscriptions too (there is reference to process definition id too. You will need to upgrade reference.

Regards
Martin

Re: Switch running process instances to newer Process-Model-Version

stephan_bauer — Fri, 10 Jul 2015 07:48:25 GMT

Hi Martin,

thanks for the hint. I checked the act_ru_event_subscr table with the following select statement, but the proc_def_id_ in act_ru_event_subscr is empty in all records. It seems activiti doesn't use it (yet or anymore?).

select ex.id_, ex.proc_def_id_, ex.is_active_, ex.proc_inst_id_, sub.id_, sub.proc_inst_id_, sub.execution_id_, sub.activity_id_, sub.proc_def_id_
from act_ru_execution ex
INNER JOIN act_ru_event_subscr sub on ex.id_ = sub.execution_id_;

Many thanks!
Stephan

Re: Switch running process instances to newer Process-Model-Version

jbarrez — Tue, 14 Jul 2015 19:19:55 GMT

> but the proc_def_id_ in act_ru_event_subscr is empty in all records. It seems activiti doesn't use it (yet or anymore?).

It is set for a start event (eg timer), but not for runtime event subscriptions. So in your case, no updates required there.

Re: Switch running process instances to newer Process-Model-Version

stephan_bauer — Thu, 16 Jul 2015 11:07:36 GMT

Hi again,
now we have done the migration and in the database, all proc_def_id_ s of the corresponding Businessprocess are updated to the latest version. But when I go into the activiti-explorer and check the "Process definitions of running instances" under "Administration" then activiti still tells that the number of instances of the old proc_def_id_s is still the same as before the update. Do I have to reset some cache?
I mean, we had shutdown the appserver before doing the sql-update and so i would have expected not to see any deprecated cache-entries anyway…
Thanks again,
Stephan

Re: Switch running process instances to newer Process-Model-Version

trademak — Fri, 17 Jul 2015 06:31:38 GMT

Hi Stephan,

Did you also update the history tables of Activiti, or only the runtime tables?

Best regards,

Re: Switch running process instances to newer Process-Model-Version

stephan_bauer — Fri, 17 Jul 2015 11:22:45 GMT

Hi Tijs,

first we only updated the runtime tables. We were not sure if it makes sense to update history tables as well…
Then we tried with the following update-statement:

update act_hi_actinst set proc_def_id_='XXXXXXX:4:6740072' where proc_def_id_='XXXXXXX:1:2512' and end_time_ is null
Query returned successfully: 37079 rows affected, 12423 ms execution time.

But this didn't have any impact on the activiti-explorer screen. I suppose there are some more updates to do? Although I'm still a bit confused that the statistics, that this page displays relies on history-tables…(?)

Many thanks,
Stephan

Re: Switch running process instances to newer Process-Model-Version

jbarrez — Thu, 23 Jul 2015 09:16:55 GMT

It could very well be those screens use historic tables, the history also reflects the runtime state of a process instance.
So I would update the act_hi_proc_inst table too, now you've only changed the ativity instances table, which is most likely not used for that screen.

Re: Switch running process instances to newer Process-Model-Version

stephan_bauer — Tue, 28 Jul 2015 06:02:51 GMT

indeed! after also updating the proc_def_id_ in act_hi_proc_inst table, the activiti-explorer displays the statistics correctly!
Many Thanks!
Stephan