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

Failed upgrade process UpgradeDLFileEntryType against PostgreSQL and Sybase

    Details

      Description

      Steps to Reproduce:

      1. Start an released portal, such as 7.2.10 connected to PostgreSQL or Sybase.
      2. Upgrade to master.

      Expected Results:
      Upgrade should compete successfully without error.

      Actual Results:
      Upgrade Failed with bellow error and the message type should be ERROR instead of INFO:

      PostgreSQL:

           [java] 04:14:36,456 INFO  [main][UpgradeProcess:115] Failed upgrade process com.liferay.portal.upgrade.v7_3_x.UpgradeDLFileEntryType in 4 ms
           [java] 04:14:36,456 INFO  [main][UpgradeProcess:115] Failed upgrade process com.liferay.portal.upgrade.PortalUpgradeProcess in 4655 ms
           [java] com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: invalid input syntax for integer: ""
           [java]   Position: 133
      

      Sybase:

           [java] 03:36:26,514 INFO  [main][UpgradeProcess:115] Failed upgrade process com.liferay.portal.upgrade.v7_3_x.UpgradeDLFileEntryType in 11 ms
           [java] 03:36:26,515 INFO  [main][UpgradeProcess:115] Failed upgrade process com.liferay.portal.upgrade.PortalUpgradeProcess in 9518 ms
           [java] com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.sybase.jdbc4.jdbc.SybSQLException: Implicit conversion from datatype 'VARCHAR' to 'DECIMAL' is not allowed.  Use the CONVERT function to run this query.
      

      Reproduced on:
      Upgrade From: DXP 7.2.10 GA1.
      Tomcat 9.0.33 + PostgeSQL 10.6. Portal master GIT ID: 438ede3ce637a64c6011615666f9b0d566573926.
      Upgrade From: DXP 7.2.10 GA1.
      Tomcat 9.0.33 + Sybase 16. Portal master GIT ID: 438ede3ce637a64c6011615666f9b0d566573926.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                summer.zhang Summer Zhang
                Reporter:
                summer.zhang Summer Zhang
                Participants of an Issue:
                Recent user:
                Jason Pince
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

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

                  Packages

                  Version Package
                  7.3.3 CE GA4
                  Master