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

Failed upgrade process for module com.liferay.account.service from 7413 on PostgreSQL

    Description

    Steps to Reproduce:

    1. Import the attached PostgreSQL dump from 7413.
    2. Upgrade to master.

    Expected Result:
    No error during upgrade.

    Actual Result:
    Below error thrown:

         [java] 2021-12-10 21:10:13.556 INFO  [main][UpgradeProcess:134] Failed upgrade process com.liferay.account.internal.upgrade.v2_5_0.AccountRoleResourceUpgradeProcess in 4 ms
         [java] 2021-12-10 21:10:13.558 ERROR [main][UpgradeStepRegistratorTracker:143] Failed upgrade process for module com.liferay.account.service
         [java] com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: syntax error at or near "where"
         [java]   Position: 99
    

    Reproduced on:
    Tomcat 9.0.53 + PostgreSQL 121. Portal master DXP GIT ID: da22c88cd8bc786e3dc7eba9a418763a92c8fb15.

      Attachments

        Issue Links

          Activity

            People

            Assignee:
            patricia.perez Patricia Perez
            Reporter:
            summer.zhang Summer Zhang
            Participants of an Issue:
            Recent user:
            Clarissa Velazquez
            Engineering Assignee:
            Pei-Jung Lan
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              27 weeks, 6 days ago

                Packages

                Version Package
                7.4.3.5 CE GA5
                7.4.13 DXP U1
                Master