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

Web Content Templates page with too many Structures can throw error with SQL Server

    Details

      Description

      Description

      When accessing the web content templates, you get an error saying templates are unavailable and that the request has too many parameters when you have many structures and are using SQL Server.

      Steps to reproduce

      1. Set up SQL Server (I used a Windows 2012 Server VM preloaded with it and created a database)
      2. Set up portal-ext.properties to connect to the SQL Server (I used these properties)

      terms.of.use.required=false
      users.reminder.queries.enabled=false
      setup.wizard.enabled=false
      browser.launcher.url=
      passwords.default.policy.change.required=false
      
      jdbc.default.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
      jdbc.default.url=jdbc:sqlserver://192.168.168.133;databaseName=lrdb_master_2
      jdbc.default.username=sa
      jdbc.default.password=test
      
      hibernate.show_sql=true
      

      3. Start up bundle and go to Control Panel > Server Administration > Scripts
      4. Add and run the attached " Add Structures Script.txt ", it should succeed successfully after a minute or so and having added 2100 structures
      5. Go to Site > Content > Web Content
      6. Click on the Templates tab

      Results of Testing

      Actual Result: "Web Content is temporarily unavailable." is displayed and there is this error in the logs:

      Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.
      

      Expected Result: Templates are displayed without errors.

      Errors/Logs

      16:10:43,880 ERROR [http-nio-8080-exec-9][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.
      16:10:43,882 ERROR [http-nio-8080-exec-9][PortletRequestDispatcherImpl:265] Unable to dispatch request: com.liferay.portal.kernel
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              joyce.wang Joyce Wang
              Reporter:
              joshua.cords Joshua Cords
              Participants of an Issue:
              Recent user:
              Csaba Turcsan
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                2 years, 20 weeks, 2 days ago

                  Packages

                  Version Package
                  7.0.0 DXP FP66
                  7.0.X
                  7.1.10 DXP FP5
                  7.1.10.1 SP1
                  7.1.2 CE GA3
                  7.1.X
                  Master