-
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
-
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:
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
- Setup latest Liferay 7.1
- Setup portal-ext.properties to connect to the SQL Server (in our case 2016)
- Start Liferay
- Create 2100 sites (recommend using dummy-factory to create sites) or using the Groovy scripts attachedSiteGenerate.groovy
.
- 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.
- causes
-
LPS-113622 RoleFinderTest#testFindByU_G is failing in Oracle
- Closed
- is related to
-
LPS-125928 Too many folders can throw error when disabling Staging
- Resolved
-
LPS-43753 Optimize the SQL query for UserFinderImpl
- Closed