# Flowable Upgrade from 6.6.0 to 6.70

**URL:** <https://forum.flowable.org/t/flowable-upgrade-from-6-6-0-to-6-70/8590>\
**Category:** Flowable Engine\
**Created:** [November 2, 2021, 7:23am UTC](https://forum.flowable.org/t/flowable-upgrade-from-6-6-0-to-6-70/8590 "2021-11-02T07:23:19Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![balajisundarajan8](https://avatars.discourse-cdn.com/v4/letter/b/e56c9b/32.png) [@balajisundarajan8](https://forum.flowable.org/u/balajisundarajan8)\
**Post date:** [November 2, 2021, 7:23am UTC](https://forum.flowable.org/t/flowable-upgrade-from-6-6-0-to-6-70/8590/1 "2021-11-02T07:23:19Z")

</div>

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\_’.

---

<div class="post-metadata">

**Author:** ![balajisundarajan8](https://avatars.discourse-cdn.com/v4/letter/b/e56c9b/32.png) [@balajisundarajan8](https://forum.flowable.org/u/balajisundarajan8)\
**Post date:** [November 2, 2021, 9:47am UTC](https://forum.flowable.org/t/flowable-upgrade-from-6-6-0-to-6-70/8590/2 "2021-11-02T09:47:34Z")

</div>

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);

---

<div class="post-metadata">

**Author:** ![joram](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/joram/32/26_2.png) [@joram](https://forum.flowable.org/u/joram)\
**Post date:** [November 10, 2021, 10:20am UTC](https://forum.flowable.org/t/flowable-upgrade-from-6-6-0-to-6-70/8590/3 "2021-11-10T10:20:58Z")

</div>

> [@balajisundarajan8](#):
>
> Note: Upgrade should not affect existing progress task. How to upgrade to latest version ?

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

> [@balajisundarajan8](#):
>
> 12:33:52.670: [APP/PROC/WEB.0] ### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name ‘PROPAGATED\_STAGE\_INST\_ID\_’.

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

> [@balajisundarajan8](#):
>
> we need to execute below queries to update version from 6.6.0 to 6.7.0.

No, that looks incorrect: BUSINESS\_STATUS\_ is currently on the `main` branch, but not in 6.7.0