DB migration to Camunda BPM 7.9 with schema-update = false

Camunda 7 Topics Discussion & Questions
1

Hello there,

We are going to migrate from activity to Camunda 7.9.
Currently, we have schema.version = 5.21.0.0
We followed the post:
https://blog.camunda.com/post/2016/10/migrate-from-activiti-to-camunda/
and we added some migration scripts from 7.5 to 7.9 located at $DISTRIBUTION_PATH/sql/upgrade

As a result, I think we have schema.version = 7.9

Also, one very important thing is we want to use schema-update: false

So when I tried to start up my application (schema-update: false ) we got:

org.camunda.bpm.engine.WrongDbException: ENGINE-03055 Version mismatch: Camunda library version is 'fox' and db version is '5.21.0.0'.

I found ACT_GE_PROPERTY table and there is a version 5.21.0.0

Could you, guys help us with questions?

Is it possible to start an application with schema-update: false after migration?
If yes, what SQL scripts I should apply to DB?
Or need I just to update schema.version in ACT_GE_PROPERTY manually (set ‘fox’)?

Thanks.

2

Hi @Vyacheslav_Biletskiy,

Setting this property value to fox should be good.

Cheers,
Thorben

1 Like
3

Thank you for the response. I tried this approach and it works fine.

4

need your guidance how to set property value fox? I am facing similar issue

5

I tried to set in database, I see below exceptions now

ENGINE-16004 Exception while closing command context: ENGINE-03056 Tables are missing for the following components: [
engine
history
identity
case.engine
decision.engine
]

org.camunda.bpm.engine.ProcessEngineException: ENGINE-03056 Tables are missing for the following components: [
engine
history
identity
case.engine
decision.engine
]
at org.camunda.bpm.engine.impl.db.EnginePersistenceLogger.missingTableException(EnginePersistenceLogger.java:488)
at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.dbSchemaCheckVersion(DbSqlSession.java:333)
at org.camunda.bpm.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:54)