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

Too many sites can throw error with SQL Server.

    Details

      Description

      Description
      When using the Microsoft SQL Server, if the user is assigned to more than 2100 sites, an error will be thrown when going to site list or accessing any of these site pages.

      Steps to reproduce

      1. Setup latest Liferay 7.1
      2. Setup portal-ext.properties to connect to the SQL Server (in our case 2016)
      3. Start Liferay
      4. Create 2100 sites (recommend using dummy-factory to create sites) or using the Groovy scripts attachedSiteGenerate.groovy.
      5. Navigate to Control Panel > Sites > Sites

      Actual result
      The following errors are thrown and site list is not displayed.
      Same by accessing any site page

      2020-04-27 05:45:55.257 ERROR [http-nio-8080-exec-6][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.
      2020-04-27 05:45:55.259 ERROR [http-nio-8080-exec-6][BaseJSPPanelCategory:97] Unable to include /sites/site_administration_header.jsp
      org.apache.jasper.JasperException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query

      Expected result
      No error is thrown, site list is displayed.

      Reproduced in
      DXP-17
      7.1.x GIT ID: d4a87e2a0460a136f60064120033d7a1d1bf3f1a
      Master GIT ID: 3c35d152038202b340a6f943f1e015d719531bdd

      * Please see Zendesk Support tab for further comments and attachments.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sharry.shi Sharry Shi
              Reporter:
              hong.vo Hong Vo
              Participants of an Issue:
              Recent user:
              Antonio Ortega
              Engineering Assignee:
              Minhchau Dang
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                1 year, 4 weeks, 3 days ago

                  Packages

                  Version Package
                  7.1.10 DXP FP19
                  7.1.10.5 SP5
                  7.1.X
                  7.2.10 DXP FP6
                  7.2.X
                  7.3.4 CE GA5
                  7.3.10 DXP GA1
                  Master