Failed upgrade process for module com.liferay.commerce.account.service from 7310 on IBM DB2 11.1

• Type: Bug
• Status: Closed
• Resolution: No Longer Reproducible
• Affects Version/s: Master
• Fix Version/s: Master
• Component/s: User Management > Business Accounts
• Labels:
  • 7.4-blocker
  • 7.4-must
  • QA-AUTOMATION
  • liferay-ga1-ce-740
  • liferay-ga2-ce-741
• Fix Priority: 5
• QA Test Name:
  • LocalFile.DocumentsandmediaUpgrade#ViewDMArchive73101
  • LocalFile.MultiFactorAuthenticationUpgrade#ViewMFAConfigurationInInstanceLevelAfterUpgrade7310
  • LocalFile.MultiFactorAuthenticationUpgrade#ViewMFAConfigurationInSystemLevelAfterUpgrade7310
  • LocalFile.PageEditorUpgrade#ConfigureContainerStylesAfterUpgrade73101
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive7310
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchiveAutoUpgrade7310
  • LocalFile.SAMLUpgrade#ViewSAMLConfigurationAfterUpgrade7310
  • LocalFile.SAMLUpgrade#ViewSAMLWithEncryptionConfigurationAfterUpgrade7310
  • LocalFile.SiteUpgrade#ViewCustomSiteSettingAfterUpgrade73101
  • LocalFile.StagingUpgrade#PublishArticleCreatedByDeletedUserAfterUpgrade621021
  • LocalFile.StagingUpgrade#ViewStagingDefaultSettingAfterUpgrade621021
  • LocalFile.StagingUpgrade#ViewStagingDefaultSettingAfterUpgrade73101
  • LocalFile.WebContentUpgrade#AddWCWithFirstComplexStructure
  • LocalFile.WebContentUpgrade#AddWCWithSecondComplexStructure
  • LocalFile.WebContentUpgrade#ViewAndEditWebContentWCStructureWCTemplateWCDAndAssetPublisher7310
  • LocalFile.WebContentUpgrade#ViewWebContentWithNoDisplayPageTemplateArchive73101
  • LocalFile.WebContentUpgrade#ViewWebContentWithPredefinedValueInWebContentFieldArchive73101
• QA Test Score: 76

Steps to Reproduce:

1. Import the attached 7310 database of DB2 11.1.
2. Upgrade database to master by executing upgrade client tool.

Expected Results:
Upgrade completes successfully without error.

Actual Results:
Upgrade Failed with below error:

ERROR [main][UpgradeStepRegistratorTracker:144] Failed upgrade process for module com.liferay.commerce.account.service
 [parallel] com.liferay.portal.kernel.upgrade.UpgradeException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=END-OF-STATEMENT;able COMMERCEACCOUNT;IMMEDIATE, DRIVER=4.24.92
 [parallel] 	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:109)
 [parallel] 	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:127)
 [parallel] 	at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor$UpgradeInfosRunnable.run(UpgradeExecutor.java:199)
 [parallel] 	at com.liferay.portal.output.stream.container.internal.OutputStreamContainerFactoryTrackerImpl.runWithSwappedLog(OutputStreamContainerFactoryTrackerImpl.java:134)
 [parallel] 	at com.liferay.portal.upgrade.internal.executor.SwappedLogExecutor.execute(SwappedLogExecutor.java:51)
 [parallel] 	at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor.executeUpgradeInfos(UpgradeExecutor.java:154)
 [parallel] 	at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor.execute(UpgradeExecutor.java:117)
 [parallel] 	at com.liferay.portal.upgrade.internal.registry.UpgradeStepRegistratorTracker$UpgradeStepRegistratorServiceTrackerCustomizer.addingService(UpgradeStepRegistratorTracker.java:137)
 [parallel] 	at com.liferay.portal.upgrade.internal.registry.UpgradeStepRegistratorTracker$UpgradeStepRegistratorServiceTrackerCustomizer.addingService(UpgradeStepRegistratorTracker.java:86)
 [parallel] 	at org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:943)
 [parallel] 	at org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:1)
 [parallel] 	at org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)
 [parallel] 	at org.osgi.util.tracker.AbstractTracked.trackInitial(AbstractTracked.java:183)
 [parallel] 	at org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:321)
 [parallel] 	at org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:264)
 [parallel] 	at com.liferay.osgi.util.ServiceTrackerFactory.open(ServiceTrackerFactory.java:104)
 [parallel] 	at com.liferay.portal.upgrade.internal.registry.UpgradeStepRegistratorTracker.activate(UpgradeStepRegistratorTracker.java:61)
 [parallel] 	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 [parallel] 	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 [parallel] 	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 [parallel] 	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 [parallel] 	at org.apache.felix.scr.impl.inject.methods.BaseMethod.invokeMethod(BaseMethod.java:228)
 [parallel] 	at org.apache.felix.scr.impl.inject.methods.BaseMethod.access$500(BaseMethod.java:41)
 [parallel] 	at org.apache.felix.scr.impl.inject.methods.BaseMethod$Resolved.invoke(BaseMethod.java:664)
 [parallel] 	at org.apache.felix.scr.impl.inject.methods.BaseMethod.invoke(BaseMethod.java:510)
 [parallel] 	at org.apache.felix.scr.impl.inject.methods.ActivateMethod.invoke(ActivateMethod.java:310)
 [parallel] 	at org.apache.felix.scr.impl.inject.methods.ActivateMethod.invoke(ActivateMethod.java:300)
 [parallel] 	at org.apache.felix.scr.impl.manager.SingleComponentManager.createImplementationObject(SingleComponentManager.java:341)
 [parallel] 	at org.apache.felix.scr.impl.manager.SingleComponentManager.createComponent(SingleComponentManager.java:114)
 [parallel] 	at org.apache.felix.scr.impl.manager.SingleComponentManager.getService(SingleComponentManager.java:983)
 [parallel] 	at org.apache.felix.scr.impl.manager.SingleComponentManager.getServiceInternal(SingleComponentManager.java:956)
 [parallel] 	at org.apache.felix.scr.impl.manager.AbstractComponentManager.activateInternal(AbstractComponentManager.java:765)
 [parallel] 	at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:1053)
 [parallel] 	at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:1007)
 [parallel] 	at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.customizerAdded(ServiceTracker.java:1216)
 [parallel] 	at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.customizerAdded(ServiceTracker.java:1137)
 [parallel] 	at org.apache.felix.scr.impl.manager.ServiceTracker$AbstractTracked.trackAdding(ServiceTracker.java:944)
 [parallel] 	at org.apache.felix.scr.impl.manager.ServiceTracker$AbstractTracked.track(ServiceTracker.java:880)
 [parallel] 	at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.serviceChanged(ServiceTracker.java:1168)
 [parallel] 	at org.apache.felix.scr.impl.BundleComponentActivator$ListenerInfo.serviceChanged(BundleComponentActivator.java:125)
 [parallel] 	at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:109)
 [parallel] 	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:891)
 [parallel] 	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:804)
 [parallel] 	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:127)
 [parallel] 	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:228)
 [parallel] 	at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:469)
 [parallel] 	at org.apache.felix.scr.impl.manager.AbstractComponentManager$3.register(AbstractComponentManager.java:906)
 [parallel] 	at org.apache.felix.scr.impl.manager.AbstractComponentManager$3.register(AbstractComponentManager.java:892)
 [parallel] 	at org.apache.felix.scr.impl.manager.RegistrationManager.changeRegistration(RegistrationManager.java:128)
 [parallel] 	at org.apache.felix.scr.impl.manager.AbstractComponentManager.registerService(AbstractComponentManager.java:959)
 [parallel] 	at org.apache.felix.scr.impl.manager.AbstractComponentManager.activateInternal(AbstractComponentManager.java:732)
 [parallel] 	at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:1053)
 [parallel] 	at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:1007)
 [parallel] 	at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.customizerAdded(ServiceTracker.java:1216)
 [parallel] 	at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.customizerAdded(ServiceTracker.java:1137)
 [parallel] 	at org.apache.felix.scr.impl.manager.ServiceTracker$AbstractTracked.trackAdding(ServiceTracker.java:944)
 [parallel] 	at org.apache.felix.scr.impl.manager.ServiceTracker$AbstractTracked.track(ServiceTracker.java:880)
 [parallel] 	at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.serviceChanged(ServiceTracker.java:1168)
 [parallel] 	at org.apache.felix.scr.impl.BundleComponentActivator$ListenerInfo.serviceChanged(BundleComponentActivator.java:125)
 [parallel] 	at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:109)
 [parallel] 	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:891)
 [parallel] 	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:804)
 [parallel] 	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:127)
 [parallel] 	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:228)
 [parallel] 	at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:469)
 [parallel] 	at org.apache.felix.scr.impl.manager.AbstractComponentManager$3.register(AbstractComponentManager.java:906)
 [parallel] 	at org.apache.felix.scr.impl.manager.AbstractComponentManager$3.register(AbstractComponentManager.java:892)
 [parallel] 	at org.apache.felix.scr.impl.manager.RegistrationManager.changeRegistration(RegistrationManager.java:128)
 [parallel] 	at org.apache.felix.scr.impl.manager.AbstractComponentManager.registerService(AbstractComponentManager.java:959)
 [parallel] 	at org.apache.felix.scr.impl.manager.AbstractComponentManager.activateInternal(AbstractComponentManager.java:732)
 [parallel] 	at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:1053)
 [parallel] 	at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:1007)
 [parallel] 	at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.customizerAdded(ServiceTracker.java:1216)
 [parallel] 	at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.customizerAdded(ServiceTracker.java:1137)
 [parallel] 	at org.apache.felix.scr.impl.manager.ServiceTracker$AbstractTracked.trackAdding(ServiceTracker.java:944)
 [parallel] 	at org.apache.felix.scr.impl.manager.ServiceTracker$AbstractTracked.track(ServiceTracker.java:880)
 [parallel] 	at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.serviceChanged(ServiceTracker.java:1168)
 [parallel] 	at org.apache.felix.scr.impl.BundleComponentActivator$ListenerInfo.serviceChanged(BundleComponentActivator.java:125)
 [parallel] 	at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:109)
 [parallel] 	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:891)
 [parallel] 	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:804)
 [parallel] 	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:127)
 [parallel] 	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:228)
 [parallel] 	at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:469)
 [parallel] 	at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:487)
 [parallel] 	at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:1004)
 [parallel] 	at com.liferay.registry.internal.RegistryImpl.registerService(RegistryImpl.java:342)
 [parallel] 	at com.liferay.portal.tools.DBUpgrader._registerModuleServiceLifecycle(DBUpgrader.java:233)
 [parallel] 	at com.liferay.portal.tools.DBUpgrader._upgradeModules(DBUpgrader.java:294)
 [parallel] 	at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:157)
 [parallel] 	at com.liferay.portal.spring.context.PortalContextLoaderListener.contextInitialized(PortalContextLoaderListener.java:364)
 [parallel] 	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4716)
 [parallel] 	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5177)
 [parallel] 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
 [parallel] 	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:717)
 [parallel] 	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:690)
 [parallel] 	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:706)
 [parallel] 	at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:631)
 [parallel] 	at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1830)
 [parallel] 	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
 [parallel] 	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
 [parallel] 	at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
 [parallel] 	at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:118)
 [parallel] 	at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:526)
 [parallel] 	at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:425)
 [parallel] 	at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1576)
 [parallel] 	at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:309)
 [parallel] 	at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123)
 [parallel] 	at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:423)
 [parallel] 	at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:366)
 [parallel] 	at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:936)
 [parallel] 	at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:843)
 [parallel] 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
 [parallel] 	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
 [parallel] 	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
 [parallel] 	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
 [parallel] 	at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
 [parallel] 	at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
 [parallel] 	at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
 [parallel] 	at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
 [parallel] 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
 [parallel] 	at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
 [parallel] 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
 [parallel] 	at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:930)
 [parallel] 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
 [parallel] 	at org.apache.catalina.startup.Catalina.start(Catalina.java:772)
 [parallel] 	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 [parallel] 	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 [parallel] 	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 [parallel] 	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 [parallel] 	at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:342)
 [parallel] 	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:473)
 [parallel] Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=END-OF-STATEMENT;able COMMERCEACCOUNT;IMMEDIATE, DRIVER=4.24.92
 [parallel] 	at com.ibm.db2.jcc.am.b6.a(b6.java:810)
 [parallel] 	at com.ibm.db2.jcc.am.b6.a(b6.java:66)
 [parallel] 	at com.ibm.db2.jcc.am.b6.a(b6.java:140)
 [parallel] 	at com.ibm.db2.jcc.am.k3.c(k3.java:2817)
 [parallel] 	at com.ibm.db2.jcc.am.k3.d(k3.java:2801)
 [parallel] 	at com.ibm.db2.jcc.am.k3.b(k3.java:2161)
 [parallel] 	at com.ibm.db2.jcc.t4.ab.k(ab.java:445)
 [parallel] 	at com.ibm.db2.jcc.t4.ab.c(ab.java:104)
 [parallel] 	at com.ibm.db2.jcc.t4.p.b(p.java:38)
 [parallel] 	at com.ibm.db2.jcc.t4.av.h(av.java:124)
 [parallel] 	at com.ibm.db2.jcc.am.k3.ak(k3.java:2156)
 [parallel] 	at com.ibm.db2.jcc.am.k3.a(k3.java:3359)
 [parallel] 	at com.ibm.db2.jcc.am.k3.c(k3.java:783)
 [parallel] 	at com.ibm.db2.jcc.am.k3.executeUpdate(k3.java:762)
 [parallel] 	at com.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:117)
 [parallel] 	at com.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)
 [parallel] 	at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:337)
 [parallel] 	at com.liferay.portal.dao.db.DB2DB.runSQL(DB2DB.java:102)
 [parallel] 	at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:303)
 [parallel] 	at com.liferay.portal.kernel.dao.db.BaseDBProcess.runSQL(BaseDBProcess.java:71)
 [parallel] 	at com.liferay.commerce.account.internal.upgrade.v3_0_0.CommerceAccountUpgradeProcess.doUpgrade(CommerceAccountUpgradeProcess.java:109)
 [parallel] 	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:104)
 [parallel] 	... 131 more