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

Too many folders can throw error when disabling Staging

    Details

      Description

      Steps to reproduce

      1. Start Liferay with SQL Server
      2. Create lots of folders (i.e. 3000)
      3. Enable Staging
      4. Disable Staging

      Expected behavior
      Staging is disabled without errors

      Actual behavior
      You can see below error in logs:

      2021-01-15 12:46:08.003 ERROR [http-nio-7180-exec-7][JDBCExceptionReporter:234] The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.
      2021-01-15 12:46:08.024 ERROR [http-nio-7180-exec-7][PortletServlet:112] javax.portlet.PortletException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
      javax.portlet.PortletException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
      	at com.liferay.portal.kernel.portlet.LiferayPortlet.callActionMethod(LiferayPortlet.java:205)
      	at com.liferay.portal.kernel.portlet.bridges.mvc.MVCPortlet.callActionMethod(MVCPortlet.java:415)
      ...
      Caused by: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
      	at com.liferay.portlet.documentlibrary.service.persistence.impl.DLFileEntryFinderImpl.doFindByG_U_R_F_M(DLFileEntryFinderImpl.java:797)
      	at com.liferay.portlet.documentlibrary.service.persistence.impl.DLFileEntryFinderImpl.findByG_R_F(DLFileEntryFinderImpl.java:571)
      	at com.liferay.portlet.documentlibrary.service.impl.DLFileEntryLocalServiceImpl.getGroupFileEntries(DLFileEntryLocalServiceImpl.java:1367)
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              beck.liu Beck Liu
              Reporter:
              antonio.ortega Antonio Ortega
              Participants of an Issue:
              Recent user:
              Clarissa Velazquez
              Engineering Assignee:
              Antonio Ortega
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

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

                  Packages

                  Version Package
                  7.1.10 DXP FP23
                  7.1.10.6 SP6
                  7.1.X
                  7.2.10 DXP FP11
                  7.2.10.3 DXP SP4
                  7.2.X
                  7.3.X
                  7.3.10 DXP FP1
                  7.3.10.1 DXP SP1
                  7.3.6 CE GA7
                  Master