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

    • Fix Priority:
      4

      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

            Assignee:
            rodrigo.paulino Rodrigo Paulino
            Reporter:
            mxc Mark Clarke
            Participants of an Issue:
            Recent user:
            Rodrigo Paulino
            Engineering Assignee:
            Rodrigo Paulino
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              10 weeks, 4 days ago

                Packages

                Version Package