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

Can not add new structure after upgrade when UpgradeDDMStructure using data engine

    Details

      Description

      Step to reproduce:

      1. Start a 7.2.10.3-SP3
      2. Shutdown server
      3. Copy data folder to master
      4. Upgrade to master
      5. Start server
      6. Navigate to Web Content admin > Structures tab
      7. Add a new web content structure with any field
      8. Click Save

      Expected Results:
      The new structure should be created successfully.

      Actual Results:
      The new structure is not created. Additionally, the following error is shown in server console

      2020-12-07 08:50:25.370 ERROR [http-nio-8080-exec-9][JDBCExceptionReporter:234] Incorrect integer value: 'Field86492833' for column 'fieldName' at row 1
      2020-12-07 08:50:25.381 ERROR [http-nio-8080-exec-9][PortletServlet:119] javax.portlet.PortletException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
      javax.portlet.PortletException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
              at com.liferay.portal.kernel.portlet.bridges.mvc.BaseTransactionalMVCActionCommand.processAction(BaseTransactionalMVCActionCommand.java:59)
              at com.liferay.journal.web.internal.portlet.action.AddDataDefinitionMVCActionCommand.processAction(AddDataDefinitionMVCActionCommand.java:55)
              at com.liferay.portal.kernel.portlet.bridges.mvc.MVCPortlet.callActionMethod(MVCPortlet.java:357)
              at com.liferay.portal.kernel.portlet.LiferayPortlet.processAction(LiferayPortlet.java:88)
              at com.liferay.portal.kernel.portlet.bridges.mvc.MVCPortlet.processAction(MVCPortlet.java:247)
              at com.liferay.portlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:77)
              at com.liferay.portal.kernel.portlet.PortletFilterUtil.doFilter(PortletFilterUtil.java:50)
              at com.liferay.portal.kernel.servlet.PortletServlet.service(PortletServlet.java:115)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
              at org.eclipse.equinox.http.servlet.internal.registration.EndpointRegistration.service(EndpointRegistration.java:153)
      

      Reproduced on:
      Upgrade From: 7.2.10.3-SP3.
      Tomcat 9.0.37 + MySQL 5.7. Portal master GIT ID: 86da566560be2ecc80203f578e693446f97a59e3.

        Attachments

        1. Actual.gif
          Actual.gif
          11.42 MB
        2. datadump72sp3.zip
          255 kB

          Activity

            People

            Assignee:
            yang.cao Yang Cao
            Reporter:
            yang.cao Yang Cao
            Participants of an Issue:
            Recent user:
            Marta Elicegui
            Engineering Assignee:
            Eudaldo Alonso
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              8 weeks, 6 days ago

                Packages

                Version Package
                Master