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

6.2 to 7.0 upgrade fails on SQL Server 2012 with Data Truncation error

    Details

      Description

      Environment

      1. SQL Server 2012 or 2014 with compatibility level 110 (2012)
      2. Portal 6.2 + portal-111-6210
      3. Portal 7.0/DXP

      Steps to Reproduce

      1. Create an empty database 'LPORTAL' on SQL Server
      2. Launch the 6.2 portal pointing to that database and let it populate default data;
      3. Log into it to finish setup;
      4. Shutdown portal 6.2;
      5. Use DXP's Upgrade Tool to try to upgrade the 'LPORTAL' database.

      Expected Results
      Upgrade will finish successfully.

      Actual Results
      Upgrade fails with the exception below:

      14:56:08,652 INFO  [main][UpgradeProcess:97] Completed upgrade process com.liferay.portal.upgrade.UpgradeProcess_7_0_0 in 15013ms
      com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.DataTruncation: Data truncation
      

      Tested on
      EE-7.0.x: 629c9dd4bab69c9e7a04941422ee05d3d0b6f76b
      Master: Does not occur on master as SQL server is not supported.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                1 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  3 years, 12 weeks, 3 days ago

                  Packages

                  Version Package
                  7.0.0 DXP FP8
                  7.0.0 DXP SP2
                  7.0.3 CE GA4