Affects Version/s: 7.1.X, 7.2.X, Master
Component/s: Sites Administration > Sites
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
The following errors are thrown and site list is not displayed.
Same by accessing any site page
No error is thrown, site list is displayed.
7.1.x GIT ID: d4a87e2a0460a136f60064120033d7a1d1bf3f1a
Master GIT ID: 3c35d152038202b340a6f943f1e015d719531bdd
* Please see Zendesk Support tab for further comments and attachments.