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

UpgradeJournal and UpgradeCommunityProperties cause data corruption in certain databases

    Details

      Description

      Due to the fix for LPS-20920, the update process for journal structures and community properties will truncate the data to different lengths in certain databases (DB2, Derby, Oracle, SQL Server, Sybase), causing data corruption for those databases if the data in those columns is longer than the CAST_TEXT length in Liferay.

      To work around the issue, run the normal replace() without a cast, and in order to address the issue in LPS-20920, catch the exception that gets thrown for databases that do not support the replace without a cast, and replace each row individually.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              brian.chan Brian Chan
              Reporter:
              minhchau.dang Minhchau Dang
              Participants of an Issue:
              Recent user:
              Marta Elicegui
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                9 years, 18 weeks, 4 days ago

                  Packages

                  Version Package
                  6.1.10 EE GA1
                  6.1.20 EE GA2
                  6.2.0 CE M2