Spring boot upgrade to 2.4.3 DB script missing

Camunda 7 Topics Discussion & Questions
1

Hi Team,
We have migrated the spring boot-starter parent version from 2.2.5 to 2.4.3. And as per documentation we also upgraded camunda.spring-boot.version to 7.15.0 from 7.13.0. Now when we run the app we got below issue:

as aborted: ERROR: column “batch_id_” of relation “act_ru_variable” does not exist
Position: 203 Call getNextException to see other errors in the batch.
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.default

We request you to provide the guidelines or complete database scripts for this migration. We did use the below link

https://docs.camunda.org/manual/7.15/update/patch-level/#applying-multiple-patches-at-once

but couldn’t find the proper scripts required.

2

Your “request” was already fulfilled:

Run the 7_14_to_7_15 sql script for your DBMS contained in the camunda-engine.jar under
org/camunda/bpm/engine/db/upgrade.

You might want to consider a database evolution tool like liquibase or flyway in the future to automate this.

1 Like
3

Do you think we need to take care more things, apart from db patch and spring boot upgrade?

4

As always: it depends … especially web security is something that might get a bit shaky, but I would just go ahead and check the forum for specific problems. In general, updating is smooth.

1 Like
5