I am trying to upgrade flowable engine from 6.3.0.1 to 6.5.0.6.
It is throwing below exception-
[org.flowable.common.engine.impl.interceptor.CommandContext ]- Error while closing command context org.apache.ibatis.exceptions.PersistenceException:
Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: relation “flw_channel_definition” does not exist
Position: 33
The error may exist in org/flowable/eventregistry/db/mapping/entity/ChannelDefinition.xml
The error may involve org.flowable.eventregistry.impl.persistence.entity.ChannelDefinitionEntityImpl.selectChannelDefinitionsByQueryCriteria-Inline
The error occurred while setting parameters
SQL: select RES.* from FLW_CHANNEL_DEFINITION RES WHERE RES.VERSION_ = (select max(VERSION_) from FLW_CHANNEL_DEFINITION where KEY_ = RES.KEY_ and ( (TENANT_ID_ IS NOT NULL and TENANT_ID_ = RES.TENANT_ID_) or (TENANT_ID_ IS NULL and RES.TENANT_ID_ IS NULL) ) ) order by RES.ID_ asc
Cause: org.postgresql.util.PSQLException: ERROR: relation “flw_channel_definition” does not exist
Position: 33
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
at org.flowable.common.engine.impl.db.DbSqlSession.selectListWithRawParameter(DbSqlSession.java:269)
at org.flowable.common.engine.impl.db.DbSqlSession.selectListWithRawParameter(DbSqlSession.java:234)
at org.flowable.common.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:158)
at org.flowable.eventregistry.impl.persistence.entity.data.impl.MybatisChannelDefinitionDataManager.findChannelDefinitionsByQueryCriteria(MybatisChannelDefinitionDataManager.java:82)
at org.flowable.eventregistry.impl.persistence.entity.ChannelDefinitionEntityManagerImpl.findChannelDefinitionsByQueryCriteria(ChannelDefinitionEntityManagerImpl.java:49)
at org.flowable.eventregistry.impl.ChannelDefinitionQueryImpl.executeList(ChannelDefinitionQueryImpl.java:319)
at org.flowable.common.engine.impl.query.AbstractQuery.execute(AbstractQuery.java:153)
at org.flowable.common.engine.impl.interceptor.DefaultCommandInvoker.execute(DefaultCommandInvoker.java:22)
at org.flowable.common.engine.impl.interceptor.TransactionContextInterceptor.execute(TransactionContextInterceptor.java:53)
at org.flowable.common.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:72)
at org.flowable.common.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:30)
at org.flowable.common.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:56)
at org.flowable.common.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:51)
at org.flowable.common.engine.impl.query.AbstractQuery.list(AbstractQuery.java:117)
at org.flowable.eventregistry.impl.EventRegistryEngineImpl.handleDeployedChannelDefinitions(EventRegistryEngineImpl.java:68)
at org.flowable.eventregistry.impl.EventRegistryEngineConfiguration.buildEventRegistryEngine(EventRegistryEngineConfiguration.java:193)
at org.flowable.eventregistry.impl.configurator.EventRegistryEngineConfigurator.initEventRegistryEngine(EventRegistryEngineConfigurator.java:87)
at org.flowable.eventregistry.impl.configurator.EventRegistryEngineConfigurator.configure(EventRegistryEngineConfigurator.java:64)
at org.flowable.common.engine.impl.AbstractEngineConfiguration.configuratorsAfterInit(AbstractEngineConfiguration.java:1006)
at org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl.init(ProcessEngineConfigurationImpl.java:1065)
at org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:957)
at org.flowable.spring.SpringProcessEngineConfiguration.buildProcessEngine(SpringProcessEngineConfiguration.java:73)