Database issue while upgrading flowable from 6.5.2 to 6.7.2

Hi Team,

We are trying to upgrade flowable from 6.5.2 to 6.7.2, while upgrading we are database exceptions.
Sometime throwing major minor version mismatch error, sometime throwing act_ge_property table not found.

Even if I am trying to run fresh flowable with DB, which is having multiple schemas, its throwing act_ge_property table not found(Flowable is update DB script rather then create).

Ashish Singh

Can you paste which exceptions?

That exception can only happen when using an old engine on a newer schema.


Please see below for exception.

Caused by: java.sql.SQLSyntaxErrorException: Table ‘local.act_ge_property’ doesn’t exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException( ~[mysql-connector-java-8.0.28.jar:8.0.28]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException( ~[mysql-connector-java-8.0.28.jar:8.0.28]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal( ~[mysql-connector-java-8.0.28.jar:8.0.28]
at com.mysql.cj.jdbc.ClientPreparedStatement.execute( ~[mysql-connector-java-8.0.28.jar:8.0.28]
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute( ~[HikariCP-4.0.3.jar:na]
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute( ~[HikariCP-4.0.3.jar:na]
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query( ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query( ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.executor.SimpleExecutor.doQuery( ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase( ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.executor.BaseExecutor.query( ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.executor.CachingExecutor.query( ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.executor.CachingExecutor.query( ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList( ~[mybatis-3.4.6.jar:3.4.6]
… 102 common frames omitted

We are just upgrading flowable engine from 6.5.2 to 6.7.2.
We are using Maria DB

Hi Team,

After debugging the flowable code I have found bug in flowable source code.
Normally if we have one Schema in Database Create/ Upgrade works but if we have multiple schemas(One flowable schemas and others for different use) in Database it fails to Create flowable Schemas.

It throws Table ‘local.act_ge_property’ doesn’t exist.

If you’re using multiple schema’s, the engine also needs to be configured to use that schema. But this has always been the case - also in 6.5.x - so not sure how it could work back then?