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

Upgrade to 7.4.2-ga3 fails on com.liferay.dynamic.data.mapping.internal.upgrade.v4_1_0.DDMFieldUpgradeProcessUpgrade process for 7.4.2-ga3 fails

Details

    • 4
    • Database Upgrade

    Description

      When upgrading to 7.4.2-GA3 I get the following error:

      "
      Caused by: com.liferay.portal.kernel.log.LogSanitizerException: java.sql.BatchUpdateException: Batch entry 195 insert into DDMFieldAttribute (mvccVersion, ctCollectionId, fieldAttributeId, companyId, fieldId, storageId, attributeName, languageId, largeAttributeValue, smallAttributeValue) values (0, 0, 1196, 20099, 1027, 2490408, '', '', NULL, 'CREATOR: gd-jpeg v1.0 (using IJG JPEG v80), quality = 90_CREATOR: gd-jpeg v1.0 (using IJG JPEG v80), quality = 90__') was aborted: ERROR: invalid byte sequence for encoding "UTF8": 0x00 Call getNextException to see other errors in the batch. [Sanitized]
      at org.postgresql.jdbc.BatchResultHandler.handleCompletion(BatchResultHandler.java:166) ~[postgresql.jar:42.2.5]"

      I think this can be traced to the upgrade process for DDMFieldUpgradeProcess.java on lines 494 and 495 where the values are set to null and only one is updated to not null.

      This is on postgresql using UTF8 encoding. I tried to see if it was dirty data but couldn't locate the issue with our data.

       

      https://github.com/liferay/liferay-portal/blob/master/modules/apps/dynamic-data-mapping/dynamic-data-mapping-service/src/main/java/com/liferay/dynamic/data/mapping/internal/upgrade/v4_1_0/DDMFieldUpgradeProcess.java

       

       

      Attachments

        Activity

          People

            rodrigo.paulino Rodrigo Paulino (Inactive)
            mxc Mark Clarke
            Kiyoshi Lee Kiyoshi Lee
            Rodrigo Paulino Rodrigo Paulino (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              1 year, 10 weeks, 6 days ago

              Packages

                Version Package