Uploaded image for project: 'PUBLIC - Liferay Commerce'
  1. PUBLIC - Liferay Commerce
  2. COMMERCE-5143

Upgrade to 7.3.5-ga6 - database upgrade errors

    Details

      Description

      I performed an upgrade from 7.3.5-ga5 to 7.4.5-ga6 and get the following commerce modules won't ugrade: (upgrade:check)

      There is an upgrade process available for com.liferay.commerce.product.service from 2.1.0.step-1 to 3.0.0 There is an upgrade process available for com.liferay.commerce.account.service from 1.2.0 to 2.0.0

      I get the following errors on running the upgrades "upgrade:execute com.liferay.commerce.account.service"

      Output

      INFO - Upgrading com.liferay.commerce.account.internal.upgrade.v1_3_0.CommerceAccountNameUpgradeProcess INFO - Starting com.liferay.portal.kernel.upgrade.UpgradeProcess#alter INFO - Completed com.liferay.portal.kernel.upgrade.UpgradeProcess#alter in 52 ms INFO - Failed upgrade process com.liferay.commerce.account.internal.upgrade.v1_3_0.CommerceAccountNameUpgradeProcess in 55 ms ERROR - Failed upgrade process for module com.liferay.commerce.account.service com.liferay.portal.kernel.upgrade.UpgradeException: java.lang.NoSuchFieldException: TABLE_SQL_ADD_INDEXES at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:109) at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:127) at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor$UpgradeInfosRunnable.run(UpgradeExecutor.java:200) at com.liferay.portal.output.stream.container.internal.OutputStreamContainerFactoryTrackerImpl.runWithSwappedLog(OutputStreamContainerFactoryTrackerImpl.java:134) at com.liferay.portal.upgrade.internal.executor.SwappedLogExecutor.execute(SwappedLogExecutor.java:51) at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor.executeUpgradeInfos(UpgradeExecutor.java:155) at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor.execute(UpgradeExecutor.java:118) at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands.execute(ReleaseManagerOSGiCommands.java:139) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.apache.felix.gogo.runtime.Reflective.invoke(Reflective.java:139) at org.apache.felix.gogo.runtime.CommandProxy.execute(CommandProxy.java:91) at org.apache.felix.gogo.runtime.Closure.executeCmd(Closure.java:599) at org.apache.felix.gogo.runtime.Closure.executeStatement(Closure.java:526) at org.apache.felix.gogo.runtime.Closure.execute(Closure.java:415) at org.apache.felix.gogo.runtime.Pipe.doCall(Pipe.java:416) at org.apache.felix.gogo.runtime.Pipe.call(Pipe.java:229) at org.apache.felix.gogo.runtime.Pipe.call(Pipe.java:59) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.lang.NoSuchFieldException: TABLE_SQL_ADD_INDEXES at java.base/java.lang.Class.getField(Class.java:1999) at com.liferay.portal.kernel.upgrade.UpgradeProcess.getIndexSQLs(UpgradeProcess.java:519) at com.liferay.portal.kernel.upgrade.UpgradeProcess.alter(UpgradeProcess.java:382) at com.liferay.commerce.account.internal.upgrade.v1_3_0.CommerceAccountNameUpgradeProcess.doUpgrade(CommerceAccountNameUpgradeProcess.java:27) at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:104) ... 23 more

      The following error occurs when I run "upgrade:execute com.liferay.commerce.product.service"

      Output
      INFO - Upgrading com.liferay.commerce.product.internal.upgrade.v2_1_0.SubscriptionUpgradeProcess INFO - Starting com.liferay.portal.kernel.upgrade.UpgradeProcess#alter INFO - Completed com.liferay.portal.kernel.upgrade.UpgradeProcess#alter in 106 ms INFO - Failed upgrade process com.liferay.commerce.product.internal.upgrade.v2_1_0.SubscriptionUpgradeProcess in 131 ms ERROR - Failed upgrade process for module com.liferay.commerce.product.service com.liferay.portal.kernel.upgrade.UpgradeException: java.lang.NoSuchFieldException: TABLE_SQL_ADD_INDEXES at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:109) at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:127) at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor$UpgradeInfosRunnable.run(UpgradeExecutor.java:200) at com.liferay.portal.output.stream.container.internal.OutputStreamContainerFactoryTrackerImpl.runWithSwappedLog(OutputStreamContainerFactoryTrackerImpl.java:134) at com.liferay.portal.upgrade.internal.executor.SwappedLogExecutor.execute(SwappedLogExecutor.java:51) at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor.executeUpgradeInfos(UpgradeExecutor.java:155) at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor.execute(UpgradeExecutor.java:118) at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands.execute(ReleaseManagerOSGiCommands.java:139) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.apache.felix.gogo.runtime.Reflective.invoke(Reflective.java:139) at org.apache.felix.gogo.runtime.CommandProxy.execute(CommandProxy.java:91) at org.apache.felix.gogo.runtime.Closure.executeCmd(Closure.java:599) at org.apache.felix.gogo.runtime.Closure.executeStatement(Closure.java:526) at org.apache.felix.gogo.runtime.Closure.execute(Closure.java:415) at org.apache.felix.gogo.runtime.Pipe.doCall(Pipe.java:416) at org.apache.felix.gogo.runtime.Pipe.call(Pipe.java:229) at org.apache.felix.gogo.runtime.Pipe.call(Pipe.java:59) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.lang.NoSuchFieldException: TABLE_SQL_ADD_INDEXES at java.base/java.lang.Class.getField(Class.java:1999) at com.liferay.portal.kernel.upgrade.UpgradeProcess.getIndexSQLs(UpgradeProcess.java:519) at com.liferay.portal.kernel.upgrade.UpgradeProcess.alter(UpgradeProcess.java:382) at com.liferay.commerce.product.internal.upgrade.base.BaseCommerceProductServiceUpgradeProcess.addColumn(BaseCommerceProductServiceUpgradeProcess.java:50) at com.liferay.commerce.product.internal.upgrade.v2_1_0.SubscriptionUpgradeProcess.doUpgrade(SubscriptionUpgradeProcess.java:35) at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:104) ... 23 more

       

        Attachments

          Activity

            People

            Assignee:
            igor.beslic Igor Beslic
            Reporter:
            mxc Mark Clarke
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Packages

                Version Package
                7.4 CE GA1
                Master
                7.3.X