Flowable Upgrade from 6.6.0 to 6.70

Flowable Engine
1

Hi,

We are trying to update flowable version from 6.6.0 to 6.70 in sprint boot version. when deploy the app and trying to invoke process facing below issues. It looks like new column (PROPAGATED_STAGE_INST_ID_)included in 6.7.0 version.

Note: Upgrade should not affect existing progress task. How to upgrade to latest version ?

12:33:52.670: [APP/PROC/WEB.0] ### SQL: insert into ACT_HI_PROCINST ( ID_, REV_, PROC_INST_ID_, BUSINESS_KEY_, PROC_DEF_ID_, START_TIME_, END_TIME_, DURATION_, START_USER_ID_, START_ACT_ID_, END_ACT_ID_, SUPER_PROCESS_INSTANCE_ID_, DELETE_REASON_, TENANT_ID_, NAME_, CALLBACK_ID_, CALLBACK_TYPE_, REFERENCE_ID_, REFERENCE_TYPE_, PROPAGATED_STAGE_INST_ID_ ) values ( ?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
12:33:52.670: [APP/PROC/WEB.0] ### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name ‘PROPAGATED_STAGE_INST_ID_’.

2

we need to execute below queries to update version from 6.6.0 to 6.7.0.

update ACT_GE_PROPERTY set VALUE_ = ‘6.6.0.1’ where NAME_ = ‘schema.version’;
alter table ACT_HI_PROCINST add PROPAGATED_STAGE_INST_ID_ nvarchar(255);

update ACT_GE_PROPERTY set VALUE_ = ‘6.7.0.1’ where NAME_ = ‘schema.version’;
alter table ACT_RU_EXECUTION add BUSINESS_STATUS_ nvarchar(255);
alter table ACT_HI_PROCINST add BUSINESS_STATUS_ nvarchar(255);

3

All our upgrades are QA’d on all supported databases (incuding MSSQL).

That’s weird - we don’t see that on our SQL server. What database version are you using?

No, that looks incorrect: BUSINESS_STATUS_ is currently on the main branch, but not in 6.7.0