Migrate Activiti 5.22.0 to Activiti 6.0.0

[himabindu_v]

Add dependency in Pom.xml

---------------------------------------------

      <dependency>

            <groupId>org.activiti</groupId>

            <artifactId>activiti-spring</artifactId>

            <version>6.0.0</version>

      </dependency>

            <dependency>

                  <groupId>org.activiti</groupId>

                  <artifactId>activiti5-spring-compatibility</artifactId>

                  <version>6.0.0</version>

            </dependency>

org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'historyService' defined in com.nipun.it.sp.configration.ApplicationContextConfig: Unsatisfied dependency expressed through method 'historyService' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine': FactoryBean threw exception on object creation; nested exception is org.activiti.engine.ActivitiException: couldn't upgrade db schema: alter table ACT_RU_EXECUTION add column IS_MI_ROOT_ TINYINT

        at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:769)

        at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:509)

        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1288)

        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1127)

        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:538)

        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:498)

        at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320)

        at org.springframework.beans.factory.support.AbstractBeanFactory$$Lambda$8/792896752.getObject(Unknown Source)

        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)

        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318)

        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)

        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:846)

        at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:863)

        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:546)

        at org.springframework.web.servlet.FrameworkServlet.configureAndRefreshWebApplicationContext(FrameworkServlet.java:701)

        at org.springframework.web.servlet.FrameworkServlet.initWebApplicationContext(FrameworkServlet.java:577)

        at org.springframework.web.servlet.FrameworkServlet.initServletBean(FrameworkServlet.java:529)

        at org.springframework.web.servlet.HttpServletBean.init(HttpServletBean.java:169)

        at javax.servlet.GenericServlet.init(GenericServlet.java:158)

        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1144)

        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:986)

        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4956)

        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5270)

        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

        at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1423)

        at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1413)

        at java.util.concurrent.FutureTask.run(Unknown Source)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

        at java.lang.Thread.run(Unknown Source)

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine': FactoryBean threw exception on object creation; nested exception is org.activiti.engine.ActivitiException: couldn't upgrade db schema: alter table ACT_RU_EXECUTION add column IS_MI_ROOT_ TINYINT

        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:178)

        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:101)

        at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1674)

        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.getObjectForBeanInstance(AbstractAutowireCapableBeanFactory.java:1216)

        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:330)

        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)

        at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:277)

        at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1244)

        at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1164)

        at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:857)

        at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:760)

        ... 29 more

Caused by: org.activiti.engine.ActivitiException: couldn't upgrade db schema: alter table ACT_RU_EXECUTION add column IS_MI_ROOT_ TINYINT

        at org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1242)

        at org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1138)

        at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpgrade(DbSqlSession.java:1117)

        at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpdate(DbSqlSession.java:947)

        at org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsProcessEngineBuild(DbSqlSession.java:1318)

        at org.activiti.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:28)

        at org.activiti.engine.impl.interceptor.CommandInvoker$1.run(CommandInvoker.java:37)

        at org.activiti.engine.impl.interceptor.CommandInvoker.executeOperation(CommandInvoker.java:78)

        at org.activiti.engine.impl.interceptor.CommandInvoker.executeOperations(CommandInvoker.java:57)

        at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:42)

        at org.activiti.engine.impl.interceptor.TransactionContextInterceptor.execute(TransactionContextInterceptor.java:48)

        at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:63)

        at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47)

        at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)

        at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)

        at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:29)

        at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:44)

        at org.activiti.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.java:81)

        at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:665)

        at org.activiti.spring.SpringProcessEngineConfiguration.buildProcessEngine(SpringProcessEngineConfiguration.java:65)

        at org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:57)

        at org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:32)

Please give me any suggestion to migrate Activiti 5.22.0 to Activiti 6.0.0 In Spring application

Thanks & regards,

V.HimaBindu.