Problem with fresh deployment on DB2 and migration from Activiti 5.21

Flowable Engine
1

Hi All,

Having:
Ubuntu 22.04 LTE
WildFly : wildfly-preview-26.1.3.Final
Jakarta 9.1
DB2: v10.5_linuxx64_expc
JDBC: https://repo1.maven.org/maven2/com/ibm/db2/jcc/11.5.9.0/jcc-11.5.9.0.jar

XA DataSource created with:

XA Datasource - ACTIVITI

batch
xa-data-source add
–name=ACTIVITI
–driver-name=db2jcc
–jndi-name=java:jboss/datasources/ACTIVITI
–user-name=${db2User}
–password=${db2Pass}
–use-ccm=true
–max-pool-size=25
–blocking-timeout-wait-millis=5000
–background-validation=true
–background-validation-millis=60000
–check-valid-connection-sql=“select 1 from sysibm.sysdummy1”
–flush-strategy=FailingConnectionOnly
/subsystem=datasources/xa-data-source=ACTIVITI/xa-datasource-properties=ServerName:add(value=localhost)
/subsystem=datasources/xa-data-source=ACTIVITI/xa-datasource-properties=PortNumber:add(value=50000)
/subsystem=datasources/xa-data-source=ACTIVITI/xa-datasource-properties=DatabaseName:add(value=ACTIVITI)
/subsystem=datasources/xa-data-source=ACTIVITI/xa-datasource-properties=DriverType:add(value=4)
xa-data-source enable --name = ACTIVITI
run-batch
reload

The database is empty although my migration projekct from Activiti 5.21 already succeeded with API change and passess almost all upgrade process to 7.0.1 database with similar exception like for the empty database.

See the stack trace. Any help is appreciated.

2024-08-23 10:59:53,752 INFO [org.flowable.cdi.impl.FlowableExtension#afterDeploymentValidation] Initializing flowable-cdi.
2024-08-23 10:59:53,761 DEBUG [bpmbox.util.ProgrammaticProcessEngineConfiguration#getProcessEngine] Deltaspike Project Stage: Development
2024-08-23 10:59:53,761 DEBUG [bpmbox.util.ProgrammaticProcessEngineConfiguration#getProcessEngine] mailServerHost:
2024-08-23 10:59:53,791 INFO [org.flowable.cdi.CdiJtaProcessEngineConfiguration#initConfigurators] Found 2 Engine Configurators in total:
2024-08-23 10:59:53,792 INFO [org.flowable.cdi.CdiJtaProcessEngineConfiguration#initConfigurators] class org.flowable.eventregistry.impl.configurator.EventRegistryEngineConfigurator (priority:100000)
2024-08-23 10:59:53,792 INFO [org.flowable.cdi.CdiJtaProcessEngineConfiguration#initConfigurators] class org.flowable.idm.engine.configurator.IdmEngineConfigurator (priority:150000)
2024-08-23 10:59:53,792 INFO [org.flowable.cdi.CdiJtaProcessEngineConfiguration#configuratorsBeforeInit] Executing beforeInit() of class org.flowable.eventregistry.impl.configurator.EventRegistryEngineConfigurator (priority:100000)
2024-08-23 10:59:53,796 INFO [org.flowable.cdi.CdiJtaProcessEngineConfiguration#configuratorsBeforeInit] Executing beforeInit() of class org.flowable.idm.engine.configurator.IdmEngineConfigurator (priority:150000)
2024-08-23 10:59:55,126 INFO [org.flowable.cdi.CdiJtaProcessEngineConfiguration#initFlowable5CompatibilityHandler] Found compatibility handler instance : class org.flowable.compatibility.DefaultFlowable5CompatibilityHandler
2024-08-23 10:59:55,173 INFO [org.flowable.common.engine.impl.async.DefaultAsyncTaskExecutor#initializeExecutor] Creating thread pool queue of size 100
2024-08-23 10:59:55,174 INFO [org.flowable.common.engine.impl.async.DefaultAsyncTaskExecutor#initializeExecutor] Creating thread factory with naming pattern flowable-async-task-invoker-thread-%d
2024-08-23 10:59:55,175 INFO [org.flowable.common.engine.impl.async.DefaultAsyncTaskExecutor#initializeExecutor] Creating executor service with corePoolSize 8, maxPoolSize 8 and keepAliveTime 5000
2024-08-23 10:59:55,175 INFO [org.flowable.common.engine.impl.async.DefaultAsyncTaskExecutor#initializeExecutor] Using rejectedExecutionHandler java.util.concurrent.ThreadPoolExecutor$CallerRunsPolicy@151f4d85
2024-08-23 10:59:55,176 INFO [org.flowable.common.engine.impl.async.DefaultAsyncTaskExecutor#initializeExecutor] Creating thread pool queue of size 2048
2024-08-23 10:59:55,176 INFO [org.flowable.common.engine.impl.async.DefaultAsyncTaskExecutor#initializeExecutor] Creating thread factory with naming pattern flowable-async-job-executor-thread-%d
2024-08-23 10:59:55,176 INFO [org.flowable.common.engine.impl.async.DefaultAsyncTaskExecutor#initializeExecutor] Creating executor service with corePoolSize 8, maxPoolSize 8 and keepAliveTime 5000
2024-08-23 10:59:55,179 INFO [org.flowable.cdi.CdiJtaProcessEngineConfiguration#configuratorsAfterInit] Executing configure() of class org.flowable.eventregistry.impl.configurator.EventRegistryEngineConfigurator (priority:100000)
2024-08-23 10:59:55,318 INFO [org.flowable.common.engine.impl.db.CommonDbSchemaManager#executeSchemaResource] performing create on common with resource org/flowable/common/db/create/flowable.db2.create.common.sql
2024-08-23 10:59:56,633 INFO [liquibase.executor#null] Changelog query completed.
2024-08-23 10:59:56,666 INFO [liquibase.lockservice#null] Successfully acquired change log lock
2024-08-23 10:59:56,698 INFO [liquibase.changelog#null] Creating database history table with name: “DB2INST1”.FLW_EV_DATABASECHANGELOG
2024-08-23 10:59:56,776 INFO [liquibase.executor#null] Changelog query completed.
2024-08-23 10:59:56,781 INFO [liquibase.changelog#null] Reading from “DB2INST1”.FLW_EV_DATABASECHANGELOG
2024-08-23 10:59:56,785 INFO [liquibase.executor#null] Changelog query completed.
2024-08-23 10:59:56,787 INFO [liquibase.executor#null] Changelog query completed.
2024-08-23 10:59:57,045 INFO [liquibase.changelog#null] Table FLW_EVENT_DEPLOYMENT created
2024-08-23 10:59:57,368 INFO [liquibase.changelog#null] Table FLW_EVENT_RESOURCE created
2024-08-23 10:59:57,618 INFO [liquibase.changelog#null] Table FLW_EVENT_DEFINITION created
2024-08-23 10:59:57,637 INFO [liquibase.changelog#null] Index ACT_IDX_EVENT_DEF_UNIQ created
2024-08-23 10:59:57,884 INFO [liquibase.changelog#null] Table FLW_CHANNEL_DEFINITION created
2024-08-23 10:59:57,901 INFO [liquibase.changelog#null] Index ACT_IDX_CHANNEL_DEF_UNIQ created
2024-08-23 10:59:57,906 INFO [liquibase.changelog#null] ChangeSet org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml::1::flowable ran successfully in 1038ms
2024-08-23 10:59:57,909 INFO [liquibase.executor#null] Changelog query completed.
2024-08-23 10:59:57,911 INFO [liquibase.executor#null] Changelog query completed.
2024-08-23 10:59:57,949 SEVERE [liquibase.changelog#null] ChangeSet org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml::2::flowable encountered an exception.
2024-08-23 10:59:57,961 INFO [liquibase#null] Update command encountered an exception.
2024-08-23 10:59:57,978 INFO [liquibase.executor#null] Changelog query completed.
2024-08-23 10:59:57,979 INFO [liquibase.lockservice#null] Successfully released change log lock
2024-08-23 10:59:57,990 ERROR [org.flowable.common.engine.impl.interceptor.CommandContext#exception] masked exception in command context. for root cause, see below as it will be rethrown later.: java.lang.NullPointerException: Cannot invoke “jakarta.transaction.Transaction.getStatus()” because “transaction” is null
at deployment.bpmboxEAR.ear//org.flowable.common.engine.impl.cfg.jta.JtaTransactionContext.rollback(JtaTransactionContext.java:51)
at deployment.bpmboxEAR.ear//org.flowable.common.engine.impl.interceptor.TransactionCommandContextCloseListener.closeFailure(TransactionCommandContextCloseListener.java:46)
at deployment.bpmboxEAR.ear//org.flowable.common.engine.impl.interceptor.CommandContext.executeCloseListenersCloseFailure(CommandContext.java:208)
at deployment.bpmboxEAR.ear//org.flowable.common.engine.impl.interceptor.CommandContext.close(CommandContext.java:93)
at deployment.bpmboxEAR.ear//org.flowable.common.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:114)
at deployment.bpmboxEAR.ear//org.flowable.common.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:30)
at deployment.bpmboxEAR.ear//org.flowable.common.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:56)
at deployment.bpmboxEAR.ear//org.flowable.eventregistry.impl.EventRegistryEngineImpl.(EventRegistryEngineImpl.java:47)
at deployment.bpmboxEAR.ear//org.flowable.eventregistry.impl.EventRegistryEngineConfiguration.buildEventRegistryEngine(EventRegistryEngineConfiguration.java:210)
at deployment.bpmboxEAR.ear//org.flowable.eventregistry.impl.configurator.EventRegistryEngineConfigurator.initEventRegistryEngine(EventRegistryEngineConfigurator.java:87)
at deployment.bpmboxEAR.ear//org.flowable.eventregistry.impl.configurator.EventRegistryEngineConfigurator.configure(EventRegistryEngineConfigurator.java:64)
at deployment.bpmboxEAR.ear//org.flowable.common.engine.impl.AbstractEngineConfiguration.configuratorsAfterInit(AbstractEngineConfiguration.java:1122)
at deployment.bpmboxEAR.ear//org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl.init(ProcessEngineConfigurationImpl.java:992)
at deployment.bpmboxEAR.ear//org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:873)
at deployment.bpmboxEAR.ear.pl.bpmbox-bpmbox-ejb2-5.4.jar//bpmbox.util.ProgrammaticProcessEngineConfiguration.getProcessEngine(ProgrammaticProcessEngineConfiguration.java:135)
at deployment.bpmboxEAR.ear//org.flowable.cdi.impl.FlowableExtension.lookupProcessEngine(FlowableExtension.java:94)
at deployment.bpmboxEAR.ear//org.flowable.cdi.impl.FlowableExtension.afterDeploymentValidation(FlowableExtension.java:66)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:569)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.injection.StaticMethodInjectionPoint.invoke(StaticMethodInjectionPoint.java:95)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.injection.MethodInvocationStrategy$SpecialParamPlusBeanManagerStrategy.invoke(MethodInvocationStrategy.java:187)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.event.ObserverMethodImpl.sendEvent(ObserverMethodImpl.java:330)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.event.ExtensionObserverMethodImpl.sendEvent(ExtensionObserverMethodImpl.java:123)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.event.ObserverMethodImpl.sendEvent(ObserverMethodImpl.java:308)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.event.ObserverMethodImpl.notify(ObserverMethodImpl.java:286)
at jakarta.enterprise.api//jakarta.enterprise.inject.spi.ObserverMethod.notify(ObserverMethod.java:125)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.util.Observers.notify(Observers.java:166)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.event.ObserverNotifier.notifySyncObservers(ObserverNotifier.java:285)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.event.ObserverNotifier.notify(ObserverNotifier.java:273)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.event.ObserverNotifier.fireEvent(ObserverNotifier.java:177)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.event.ObserverNotifier.fireEvent(ObserverNotifier.java:171)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.bootstrap.events.AbstractContainerEvent.fire(AbstractContainerEvent.java:53)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.bootstrap.events.AbstractDeploymentContainerEvent.fire(AbstractDeploymentContainerEvent.java:35)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.bootstrap.events.AfterDeploymentValidationImpl.fire(AfterDeploymentValidationImpl.java:28)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.bootstrap.WeldStartup.validateBeans(WeldStartup.java:510)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.bootstrap.WeldBootstrap.validateBeans(WeldBootstrap.java:93)
at org.jboss.as.weld@26.1.3.Final//org.jboss.as.weld.WeldStartService.start(WeldStartService.java:98)
at org.jboss.msc@1.4.13.Final//org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1739)
at org.jboss.msc@1.4.13.Final//org.jboss.msc.service.ServiceControllerImpl$StartTask.execute(ServiceControllerImpl.java:1701)
at org.jboss.msc@1.4.13.Final//org.jboss.msc.service.ServiceControllerImpl$ControllerTask.run(ServiceControllerImpl.java:1559)
at org.jboss.threads@2.4.0.Final//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1990)
at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486)
at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1363)
at java.base/java.lang.Thread.run(Thread.java:840)

2024-08-23 10:59:58,009 ERROR [org.jboss.msc.service.fail#startFailed] MSC000001: Failed to start service jboss.deployment.unit.“bpmboxEAR.ear”.WeldStartService: org.jboss.msc.service.StartException in service jboss.deployment.unit.“bpmboxEAR.ear”.WeldStartService: Failed to start service
at org.jboss.msc@1.4.13.Final//org.jboss.msc.service.ServiceControllerImpl$StartTask.execute(ServiceControllerImpl.java:1731)
at org.jboss.msc@1.4.13.Final//org.jboss.msc.service.ServiceControllerImpl$ControllerTask.run(ServiceControllerImpl.java:1559)
at org.jboss.threads@2.4.0.Final//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1990)
at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486)
at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1363)
at java.base/java.lang.Thread.run(Thread.java:840)
Caused by: org.jboss.weld.exceptions.DeploymentException: Error initialising eventregistry data model
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.bootstrap.events.AbstractDeploymentContainerEvent.fire(AbstractDeploymentContainerEvent.java:38)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.bootstrap.events.AfterDeploymentValidationImpl.fire(AfterDeploymentValidationImpl.java:28)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.bootstrap.WeldStartup.validateBeans(WeldStartup.java:510)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.bootstrap.WeldBootstrap.validateBeans(WeldBootstrap.java:93)
at org.jboss.as.weld@26.1.3.Final//org.jboss.as.weld.WeldStartService.start(WeldStartService.java:98)
at org.jboss.msc@1.4.13.Final//org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1739)
at org.jboss.msc@1.4.13.Final//org.jboss.msc.service.ServiceControllerImpl$StartTask.execute(ServiceControllerImpl.java:1701)
… 6 more
Caused by: org.flowable.common.engine.api.FlowableException: Error initialising eventregistry data model
at deployment.bpmboxEAR.ear//org.flowable.common.engine.impl.db.LiquibaseBasedSchemaManager.initSchema(LiquibaseBasedSchemaManager.java:91)
at deployment.bpmboxEAR.ear//org.flowable.eventregistry.impl.db.EventDbSchemaManager.initSchema(EventDbSchemaManager.java:36)
at deployment.bpmboxEAR.ear//org.flowable.eventregistry.impl.cmd.SchemaOperationsEventRegistryEngineBuild.execute(SchemaOperationsEventRegistryEngineBuild.java:29)
at deployment.bpmboxEAR.ear//org.flowable.eventregistry.impl.cmd.SchemaOperationsEventRegistryEngineBuild.execute(SchemaOperationsEventRegistryEngineBuild.java:24)
at deployment.bpmboxEAR.ear//org.flowable.common.engine.impl.interceptor.DefaultCommandInvoker.execute(DefaultCommandInvoker.java:22)
at deployment.bpmboxEAR.ear//org.flowable.common.engine.impl.interceptor.TransactionContextInterceptor.execute(TransactionContextInterceptor.java:53)
at deployment.bpmboxEAR.ear//org.flowable.common.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:105)
at deployment.bpmboxEAR.ear//org.flowable.common.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:30)
at deployment.bpmboxEAR.ear//org.flowable.common.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:56)
at deployment.bpmboxEAR.ear//org.flowable.eventregistry.impl.EventRegistryEngineImpl.(EventRegistryEngineImpl.java:47)
at deployment.bpmboxEAR.ear//org.flowable.eventregistry.impl.EventRegistryEngineConfiguration.buildEventRegistryEngine(EventRegistryEngineConfiguration.java:210)
at deployment.bpmboxEAR.ear//org.flowable.eventregistry.impl.configurator.EventRegistryEngineConfigurator.initEventRegistryEngine(EventRegistryEngineConfigurator.java:87)
at deployment.bpmboxEAR.ear//org.flowable.eventregistry.impl.configurator.EventRegistryEngineConfigurator.configure(EventRegistryEngineConfigurator.java:64)
at deployment.bpmboxEAR.ear//org.flowable.common.engine.impl.AbstractEngineConfiguration.configuratorsAfterInit(AbstractEngineConfiguration.java:1122)
at deployment.bpmboxEAR.ear//org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl.init(ProcessEngineConfigurationImpl.java:992)
at deployment.bpmboxEAR.ear//org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:873)
at deployment.bpmboxEAR.ear.pl.bpmbox-bpmbox-ejb2-5.4.jar//bpmbox.util.ProgrammaticProcessEngineConfiguration.getProcessEngine(ProgrammaticProcessEngineConfiguration.java:135)
at deployment.bpmboxEAR.ear//org.flowable.cdi.impl.FlowableExtension.lookupProcessEngine(FlowableExtension.java:94)
at deployment.bpmboxEAR.ear//org.flowable.cdi.impl.FlowableExtension.afterDeploymentValidation(FlowableExtension.java:66)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:569)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.injection.StaticMethodInjectionPoint.invoke(StaticMethodInjectionPoint.java:95)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.injection.MethodInvocationStrategy$SpecialParamPlusBeanManagerStrategy.invoke(MethodInvocationStrategy.java:187)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.event.ObserverMethodImpl.sendEvent(ObserverMethodImpl.java:330)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.event.ExtensionObserverMethodImpl.sendEvent(ExtensionObserverMethodImpl.java:123)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.event.ObserverMethodImpl.sendEvent(ObserverMethodImpl.java:308)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.event.ObserverMethodImpl.notify(ObserverMethodImpl.java:286)
at jakarta.enterprise.api//jakarta.enterprise.inject.spi.ObserverMethod.notify(ObserverMethod.java:125)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.util.Observers.notify(Observers.java:166)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.event.ObserverNotifier.notifySyncObservers(ObserverNotifier.java:285)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.event.ObserverNotifier.notify(ObserverNotifier.java:273)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.event.ObserverNotifier.fireEvent(ObserverNotifier.java:177)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.event.ObserverNotifier.fireEvent(ObserverNotifier.java:171)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.bootstrap.events.AbstractContainerEvent.fire(AbstractContainerEvent.java:53)
at org.jboss.weld.core@4.0.3.Final//org.jboss.weld.bootstrap.events.AbstractDeploymentContainerEvent.fire(AbstractDeploymentContainerEvent.java:35)
… 12 more
Caused by: org.flowable.common.engine.api.FlowableException: Error updating eventregistry engine tables
at deployment.bpmboxEAR.ear//org.flowable.common.engine.impl.db.LiquibaseBasedSchemaManager.schemaUpdate(LiquibaseBasedSchemaManager.java:132)
at deployment.bpmboxEAR.ear//org.flowable.eventregistry.impl.db.EventDbSchemaManager.schemaUpdate(EventDbSchemaManager.java:63)
at deployment.bpmboxEAR.ear//liquibase.Scope.lambda$child$0(Scope.java:187)
at deployment.bpmboxEAR.ear//liquibase.Scope.child(Scope.java:196)
at deployment.bpmboxEAR.ear//liquibase.Scope.child(Scope.java:186)
at deployment.bpmboxEAR.ear//liquibase.Scope.child(Scope.java:165)
at deployment.bpmboxEAR.ear//org.flowable.common.engine.impl.db.LiquibaseBasedSchemaManager.runForLiquibase(LiquibaseBasedSchemaManager.java:96)
at deployment.bpmboxEAR.ear//org.flowable.common.engine.impl.db.LiquibaseBasedSchemaManager.initSchema(LiquibaseBasedSchemaManager.java:84)
… 48 more
Caused by: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml::2::flowable:
Reason: liquibase.exception.DatabaseException: DB2 SQL Error: SQLCODE=-30090, SQLSTATE=25000, SQLERRMC=2;, DRIVER=4.33.31 [Failed SQL: (-30090) CALL SYSPROC.ADMIN_CMD (‘REORG TABLE “DB2INST1”.FLW_CHANNEL_DEFINITION’)]
at deployment.bpmboxEAR.ear//liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:136)
at deployment.bpmboxEAR.ear//liquibase.Liquibase.lambda$null$0(Liquibase.java:297)
at deployment.bpmboxEAR.ear//liquibase.Scope.lambda$child$0(Scope.java:187)
at deployment.bpmboxEAR.ear//liquibase.Scope.child(Scope.java:196)
at deployment.bpmboxEAR.ear//liquibase.Scope.child(Scope.java:186)
at deployment.bpmboxEAR.ear//liquibase.Scope.child(Scope.java:165)
at deployment.bpmboxEAR.ear//liquibase.Scope.child(Scope.java:256)
at deployment.bpmboxEAR.ear//liquibase.Liquibase.lambda$update$1(Liquibase.java:295)
at deployment.bpmboxEAR.ear//liquibase.Scope.lambda$child$0(Scope.java:187)
at deployment.bpmboxEAR.ear//liquibase.Liquibase.update(Liquibase.java:197)
at deployment.bpmboxEAR.ear//org.flowable.common.engine.impl.db.LiquibaseBasedSchemaManager.schemaUpdate(LiquibaseBasedSchemaManager.java:130)
… 55 more
Caused by: liquibase.exception.MigrationFailedException: Migration failed for changeset org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml::2::flowable:
Reason: liquibase.exception.DatabaseException: DB2 SQL Error: SQLCODE=-30090, SQLSTATE=25000, SQLERRMC=2;, DRIVER=4.33.31 [Failed SQL: (-30090) CALL SYSPROC.ADMIN_CMD (‘REORG TABLE “DB2INST1”.FLW_CHANNEL_DEFINITION’)]
at deployment.bpmboxEAR.ear//liquibase.changelog.ChangeSet.execute(ChangeSet.java:744)
at deployment.bpmboxEAR.ear//liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:59)
at deployment.bpmboxEAR.ear//liquibase.changelog.ChangeLogIterator$2.lambda$null$0(ChangeLogIterator.java:124)
at deployment.bpmboxEAR.ear//liquibase.Scope.lambda$child$0(Scope.java:187)
at deployment.bpmboxEAR.ear//liquibase.Scope.child(Scope.java:196)
at deployment.bpmboxEAR.ear//liquibase.Scope.child(Scope.java:186)
at deployment.bpmboxEAR.ear//liquibase.Scope.child(Scope.java:165)
at deployment.bpmboxEAR.ear//liquibase.changelog.ChangeLogIterator$2.lambda$run$1(ChangeLogIterator.java:124)
at deployment.bpmboxEAR.ear//liquibase.Scope.lambda$child$0(Scope.java:187)
deployment.bpmboxEAR.ear//liquibase.changelog.ChangeLogIterator$2.run(ChangeLogIterator.java:105)
at deployment.bpmboxEAR.ear//liquibase.Scope.lambda$child$0(Scope.java:187)
at deployment.bpmboxEAR.ear//liquibase.Scope.child(Scope.java:196)
at deployment.bpmboxEAR.ear//liquibase.Scope.child(Scope.java:260)
at deployment.bpmboxEAR.ear//liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:75)
… 72 more
Caused by: liquibase.exception.DatabaseException: DB2 SQL Error: SQLCODE=-30090, SQLSTATE=25000, SQLERRMC=2;, DRIVER=4.33.31 [Failed SQL: (-30090) CALL SYSPROC.ADMIN_CMD (‘REORG TABLE “DB2INST1”.FLW_CHANNEL_DEFINITION’)]
at deployment.bpmboxEAR.ear//liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:445)
at deployment.bpmboxEAR.ear//liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:77)
at deployment.bpmboxEAR.ear//liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:160)
at deployment.bpmboxEAR.ear//liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1270)
at deployment.bpmboxEAR.ear//liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1252)
at deployment.bpmboxEAR.ear//liquibase.changelog.ChangeSet.execute(ChangeSet.java:702)
… 92 more
Caused by: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-30090, SQLSTATE=25000, SQLERRMC=2;, DRIVER=4.33.31
at com.ibm.db2//com.ibm.db2.jcc.am.b4.a(b4.java:815)
at com.ibm.db2//com.ibm.db2.jcc.am.kn.execute(kn.java:1117)
at org.jboss.ironjacamar.jdbcadapters@1.5.3.Final//org.jboss.jca.adapters.jdbc.WrappedStatement.execute(WrappedStatement.java:198)
at deployment.bpmboxEAR.ear//liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:441)
… 97 more

2024-08-23 10:59:58,013 ERROR [org.jboss.as.controller.management-operation#executeStep] WFLYCTL0013: Operation (“add”) failed - address: ([(“deployment” => “bpmboxEAR.ear”)]) - failure description: {“WFLYCTL0080: Failed services” => {“jboss.deployment.unit."bpmboxEAR.ear".WeldStartService” => “Failed to start service
Caused by: org.jboss.weld.exceptions.DeploymentException: Error initialising eventregistry data model
Caused by: org.flowable.common.engine.api.FlowableException: Error initialising eventregistry data model
Caused by: org.flowable.common.engine.api.FlowableException: Error updating eventregistry engine tables
Caused by: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml::2::flowable:
Reason: liquibase.exception.DatabaseException: DB2 SQL Error: SQLCODE=-30090, SQLSTATE=25000, SQLERRMC=2;, DRIVER=4.33.31 [Failed SQL: (-30090) CALL SYSPROC.ADMIN_CMD (‘REORG TABLE "DB2INST1".FLW_CHANNEL_DEFINITION’)]
Caused by: liquibase.exception.MigrationFailedException: Migration failed for changeset org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml::2::flowable:
Reason: liquibase.exception.DatabaseException: DB2 SQL Error: SQLCODE=-30090, SQLSTATE=25000, SQLERRMC=2;, DRIVER=4.33.31 [Failed SQL: (-30090) CALL SYSPROC.ADMIN_CMD (‘REORG TABLE "DB2INST1".FLW_CHANNEL_DEFINITION’)]
Caused by: liquibase.exception.DatabaseException: DB2 SQL Error: SQLCODE=-30090, SQLSTATE=25000, SQLERRMC=2;, DRIVER=4.33.31 [Failed SQL: (-30090) CALL SYSPROC.ADMIN_CMD (‘REORG TABLE "DB2INST1".FLW_CHANNEL_DEFINITION’)]
Caused by: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-30090, SQLSTATE=25000, SQLERRMC=2;, DRIVER=4.33.31”}}
2024-08-23 10:59:58,013 ERROR [org.jboss.as.controller.management-operation#executeStep] WFLYCTL0013: Operation (“add”) failed - address: ([(“deployment” => “bpmboxEAR.ear”)]) - failure description: {“WFLYCTL0080: Failed services” => {“jboss.deployment.unit."bpmboxEAR.ear".WeldStartService” => “Failed to start service
Caused by: org.jboss.weld.exceptions.DeploymentException: Error initialising eventregistry data model
Caused by: org.flowable.common.engine.api.FlowableException: Error initialising eventregistry data model
Caused by: org.flowable.common.engine.api.FlowableException: Error updating eventregistry engine tables
Caused by: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml::2::flowable:
Reason: liquibase.exception.DatabaseException: DB2 SQL Error: SQLCODE=-30090, SQLSTATE=25000, SQLERRMC=2;, DRIVER=4.33.31 [Failed SQL: (-30090) CALL SYSPROC.ADMIN_CMD (‘REORG TABLE "DB2INST1".FLW_CHANNEL_DEFINITION’)]
Caused by: liquibase.exception.MigrationFailedException: Migration failed for changeset org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml::2::flowable:
Reason: liquibase.exception.DatabaseException: DB2 SQL Error: SQLCODE=-30090, SQLSTATE=25000, SQLERRMC=2;, DRIVER=4.33.31 [Failed SQL: (-30090) CALL SYSPROC.ADMIN_CMD (‘REORG TABLE "DB2INST1".FLW_CHANNEL_DEFINITION’)]
Caused by: liquibase.exception.DatabaseException: DB2 SQL Error: SQLCODE=-30090, SQLSTATE=25000, SQLERRMC=2;, DRIVER=4.33.31 [Failed SQL: (-30090) CALL SYSPROC.ADMIN_CMD (‘REORG TABLE "DB2INST1".FLW_CHANNEL_DEFINITION’)]
Caused by: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-30090, SQLSTATE=25000, SQLERRMC=2;, DRIVER=4.33.31”}}
2024-08-23 10:59:58,014 ERROR [org.jboss.as.server#handleResult] WFLYSRV0021: Deploy of deployment “bpmboxEAR.ear” was rolled back with the following failure message:
{“WFLYCTL0080: Failed services” => {“jboss.deployment.unit."bpmboxEAR.ear".WeldStartService” => “Failed to start service
Caused by: org.jboss.weld.exceptions.DeploymentException: Error initialising eventregistry data model
Caused by: org.flowable.common.engine.api.FlowableException: Error initialising eventregistry data model
Caused by: org.flowable.common.engine.api.FlowableException: Error updating eventregistry engine tables
Caused by: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml::2::flowable:
Reason: liquibase.exception.DatabaseException: DB2 SQL Error: SQLCODE=-30090, SQLSTATE=25000, SQLERRMC=2;, DRIVER=4.33.31 [Failed SQL: (-30090) CALL SYSPROC.ADMIN_CMD (‘REORG TABLE "DB2INST1".FLW_CHANNEL_DEFINITION’)]
Caused by: liquibase.exception.MigrationFailedException: Migration failed for changeset org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml::2::flowable:
Reason: liquibase.exception.DatabaseException: DB2 SQL Error: SQLCODE=-30090, SQLSTATE=25000, SQLERRMC=2;, DRIVER=4.33.31 [Failed SQL: (-30090) CALL SYSPROC.ADMIN_CMD (‘REORG TABLE "DB2INST1".FLW_CHANNEL_DEFINITION’)]
Caused by: liquibase.exception.DatabaseException: DB2 SQL Error: SQLCODE=-30090, SQLSTATE=25000, SQLERRMC=2;, DRIVER=4.33.31 [Failed SQL: (-30090) CALL SYSPROC.ADMIN_CMD (‘REORG TABLE "DB2INST1".FLW_CHANNEL_DEFINITION’)]
Caused by: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-30090, SQLSTATE=25000, SQLERRMC=2;, DRIVER=4.33.31”}}

resulting tables: only 8 tables created