Too many sites can throw error with SQL Server.

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.1.X, 7.2.X, Master
• Fix Version/s: 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
• Component/s: Sites Administration > Sites
• Labels:
  • backend_test
  • ee-ts
  • liferay-dxp-71-sp5
  • liferay-fixpack-dxp-19-7110
  • liferay-fixpack-dxp-6-7210
• Branch Version/s:
  7.2.x, 7.1.x
• Backported to Branch:
  Committed
• Fix Priority: 3
• Sprint: U&SM| S03 Sprint 23 |5.12-5.26
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/88610

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.}