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

Cannot create Style Book entries after upgrading from 7.3 GA1

    Details

      Description

      Description

      Currently, customers that upgrade from 7.3 GA1 to 7.3 DXP-1 are no longer able to create new Style Book entries. Instead, they encounter the following error:

      2021-04-22 01:04:14.117 ERROR [http-nio-8080-exec-7][JDBCExceptionReporter:234] Unknown column 'uuid_' in 'field list'
      2021-04-22 01:04:14.121 ERROR [http-nio-8080-exec-7][PortletServlet:119] javax.portlet.PortletException: org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
      

      Reproduction Steps

      1. Start up a clean 7.3 GA1 bundle.
      2. Go to Design > Style Books and create a new style book entry.
      3. Shutdown bundle and upgrade bundle to 7.3 DXP-1.
      4. Start up upgraded bundle.
      5. Repeat Step 2.

      Actual Results:
      A SQLSyntaxErrorException occurs and a new style book entry cannot be created.

      Expected Results:
      A new style book is successfully created.

      Reproduced in:
      7.3 DXP-1: 638bb33d5013d2e0
      7.3.x: bb9e82ca3d81b576
      master: 07ab8d3c3a85dea2 (the commit before LPS-127285)

      Not reproduced in:
      master: 20867b666620000b

      Notes

      The issue is that, between 7.3 GA1 and 7.3 DXP-1, new columns were added to the "StyleBookEntryVersion" table. Specifically, the columns "uuid_" and "modifiedDate" were added as a result of LPS-121746. However, there is no upgrade process in 7.3 DXP-1 or 7.3.x that adds these new columns to the table during upgrade.

      In master, this is not an issue as a upgrade process was created that added these missing columns to the "StyleBookEntryVersion" table (LPS-127285). However, due to 7.4 specific changes like LPS-120859, which added new upgrade processes related to style books, backporting LPS-127285 to 7.3.x would cause upgrade schema conflicts and therefore cannot be backported:

      Thus, adjustments to the upgrade schema versions need to be made in master.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              alberto.chaparro Alberto Chaparro
              Reporter:
              kevin.lee Kevin Lee
              Participants of an Issue:
              Recent user:
              Brian Wulbern
              Engineering Assignee:
              Kevin Lee
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                9 weeks, 3 days ago

                  Packages

                  Version Package
                  7.4.1 CE GA2 DXP 7,4
                  Master