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

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.X, 7.1.X, Master
• Fix Version/s: 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
• Component/s: Dynamic Data Mapping
• Labels:
  • ee-ts
  • liferay-dxp-70-sp10
  • liferay-dxp-71-sp1
  • liferay-fixpack-de-66-7010
  • liferay-fixpack-dxp-5-7110
• Branch Version/s:
  7.0.x
• Backported to Branch:
  Committed
• Story Points: 0.25
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/64178

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