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

Failed upgrade process for module com.liferay.remote.app.service on SQL Server and Oracle DB

    Description

    Issue for other DBs (LPS-139537) was recently fixed, but a new issue is now showing on SQL Server and Oracle DB due to invalid "true" identifier.

    Steps to Reproduce:

    1. Import the attached SQL Server dump from 7.3.10 into SQL Server 2017
    2. Run upgrade to to upgrade to master

    Expected Result:
    No error on upgrade.

    Actual Result:
    com.liferay.remote.app.service upgrade fails

          [java] 2021-09-26 04:42:07.993 ERROR [main][ReleaseManagerImpl:93] bundle com.liferay.portal.upgrade.impl:5.0.8 (236)[com.liferay.portal.upgrade.internal.release.ReleaseManagerImpl(755)] : The activate method has thrown an exception 
         [java] com.liferay.portal.kernel.upgrade.UpgradeException: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'true'.
         [java] 	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:120) ~[portal-kernel.jar:?]
         [java] 	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:138) ~[portal-kernel.jar:?]
         [java] 	at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor$UpgradeInfosRunnable.run(UpgradeExecutor.java:199) ~[?:?]
         [java] 	at com.liferay.portal.output.stream.container.internal.OutputStreamContainerFactoryTrackerImpl.runWithSwappedLog(OutputStreamContainerFactoryTrackerImpl.java:134) ~[?:?]
         [java] 	at com.liferay.portal.upgrade.internal.executor.SwappedLogExecutor.execute(SwappedLogExecutor.java:51) ~[?:?]
         [java] 	at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor.executeUpgradeInfos(UpgradeExecutor.java:154) ~[?:?]
         [java] 	at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor.execute(UpgradeExecutor.java:117) ~[?:?]
         [java] 	at com.liferay.portal.upgrade.internal.release.ReleaseManagerImpl.activate(ReleaseManagerImpl.java:184) ~[?:?]

    Full log from CI

    Reproducible when upgrading from 7.3.10 or 7.4.0

    Not Reproducible when upgrading from 7.2.10 or earlier.

    Also fails on Oracle DB 19.3

         [java] 2021-09-27 04:31:41.788 ERROR [main][UpgradeStepRegistratorTracker:143] Failed upgrade process for module com.liferay.remote.app.service
         [java] com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLSyntaxErrorException: ORA-00904: "TRUE": invalid identifier
    

    Full log from CI

      Attachments

        Issue Links

          Activity

            People

            Assignee:
            victor.ware Victor Ware
            Reporter:
            victor.ware Victor Ware
            Participants of an Issue:
            Recent user:
            Enterprise Release HU
            Engineering Assignee:
            Javier de Arcos Velilla
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              8 weeks, 2 days ago

                Packages

                Version Package
                7.4.13 DXP GA1
                7.4.3.4 CE GA4
                Master