Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-127996

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

    Details

      Description

      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

        Attachments

        1. 1628064581(1).png
          1628064581(1).png
          201 kB
        2. data-archive-portal-db2.zip
          16.49 MB
        3. upgrade.log
          133 kB

          Issue Links

            Activity

              People

              Assignee:
              melody.wu Melody Wu
              Reporter:
              koor.gai Koor Gai
              Participants of an Issue:
              Recent user:
              Melody Wu
              Engineering Assignee:
              Melody Wu
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                7 weeks, 5 days ago

                  Packages

                  Version Package
                  Master