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

Upgrade from 7.0 GA1 and below: SQLServer and Sybase databases present an incorrect size for STRING fields

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: Duplicate
    • Affects Version/s: 7.0.0 CE GA1, 7.0.4 CE GA5, 7.0.0 DXP FP39, Master
    • Fix Version/s: 7.0.3 CE GA4
    • Component/s: Database Upgrade Framework
    • Labels:
      None
    • Fix Priority:
      4

      Description

      The issue https://issues.liferay.com/browse/LPS-67342 increased the size for STRING fields from 1000 to 4000 and from 2000 to 4000 in Sybase and SQLServer respectively:
      https://github.com/liferay/liferay-portal-ee/commit/2b22e43cc72fafd17c42ca6e6c853c2e4e054cf8

      However we didn't create an upgrade process for this case and that means that we still keep the previous size for those installatations which started in 7.0 GA1 and below and will perform an upgrade to future versions.

      Steps to reproduce it:

      1. Start a 7.0GA1 (no fix packs) or 6.2 using SQLServer
      2. Upgrade to master/7.1

      Actual results:
      Check the size for AssetEntry.title, it will be 2000

      Expected results:
      Check the size for AssetEntry.title, it should be 4000

        Attachments

          Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. LPS-68410 Upgrade process needed to increase the length of STRING columns in Sybase and SQL Server

          • Closed
          is caused by

          Bug - A problem which impairs or prevents the functions of the product. LPS-67342 Upgrade tools fails to connect to database with Jboss application server

          • Closed

            Activity

              People

              Assignee:
              support-lep@liferay.com SE Support
              Reporter:
              alberto.chaparro Alberto Chaparro
              Participants of an Issue:
              Recent user:
              Marta Elicegui
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                4 years, 23 weeks ago

                  Packages

                  Version Package
                  7.0.3 CE GA4