Which flowable version supports to DB2 5.99


#1

a flowable engine is not able to upgrade some of the tables when using d2 with version 5.99.0.0 and flowable with version 6.3.1.0

getting this exception:

org.flowable.common.engine.api.FlowableException: couldn’t upgrade db schema: create table ACT_ID_PROPERTY (
NAME_ varchar(64) not null,
VALUE_ varchar(300),
REV_ integer,
primary key (NAME_)
)


#2

Can you perhaps share the entire exception that you are getting?


#3

ProcessEngineConfiguration cfg = new StandaloneProcessEngineConfiguration().setDatabaseType(ProcessEngineConfiguration.DATABASE_TYPE_DB2)
.setJdbcUrl(“jdbc:as400://IP;date format=iso;libraries=ZDBXDCI004”).setJdbcUsername("").setJdbcPassword("")
.setJdbcDriver(“com.ibm.as400.access.AS400JDBCDriver”)
.setDatabaseSchemaUpdate(ProcessEngineConfiguration.DB_SCHEMA_UPDATE_TRUE);

we used above db2 connection code and we are getting an exception below

org.flowable.common.engine.api.FlowableException: couldn’t upgrade db schema: create table ACT_ID_PROPERTY (
NAME_ varchar(64) not null,
VALUE_ varchar(300),
REV_ integer,
primary key (NAME_)
)


#4

entire exception is-

Servlet.service() for servlet [com.util.TransitionServlet] in context with path [/UIflowable] threw exception
org.flowable.common.engine.api.FlowableException: couldn’t upgrade db schema: create table ACT_ID_PROPERTY (
NAME_ varchar(64) not null,
VALUE_ varchar(300),
REV_ integer,
primary key (NAME_)
)
at org.flowable.common.engine.impl.db.AbstractSqlScriptBasedDbSchemaManager.executeSchemaResource(AbstractSqlScriptBasedDbSchemaManager.java:340)
at org.flowable.common.engine.impl.db.AbstractSqlScriptBasedDbSchemaManager.executeSchemaResource(AbstractSqlScriptBasedDbSchemaManager.java:232)
at org.flowable.common.engine.impl.db.AbstractSqlScriptBasedDbSchemaManager.dbSchemaUpgrade(AbstractSqlScriptBasedDbSchemaManager.java:94)
at org.flowable.common.engine.impl.db.ServiceSqlScriptBasedDbSchemaManager.dbSchemaUpdate(ServiceSqlScriptBasedDbSchemaManager.java:78)
at org.flowable.idm.engine.impl.db.IdmDbSchemaManager.performSchemaOperationsIdmEngineBuild(IdmDbSchemaManager.java:154)
at org.flowable.idm.engine.impl.SchemaOperationsIdmEngineBuild.execute(SchemaOperationsIdmEngineBuild.java:29)
at org.flowable.common.engine.impl.interceptor.DefaultCommandInvoker.execute(DefaultCommandInvoker.java:10)
at org.flowable.common.engine.impl.interceptor.TransactionContextInterceptor.execute(TransactionContextInterceptor.java:53)
at org.flowable.common.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:71)
at org.flowable.common.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:35)
at org.flowable.common.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:56)
at org.flowable.idm.engine.impl.IdmEngineImpl.<init>(IdmEngineImpl.java:45)
at org.flowable.idm.engine.IdmEngineConfiguration.buildIdmEngine(IdmEngineConfiguration.java:169)
at org.flowable.idm.engine.configurator.IdmEngineConfigurator.configure(IdmEngineConfigurator.java:57)