-
Type:
Bug
-
Status: Closed
-
Resolution: Duplicate
-
Affects Version/s: 7.1.10 DXP FP1
-
Component/s: Environments > Databases
-
Labels:
e*Description*
The steps to reproduce will set up a series of conditions that can be accomplished by the use of scripts. The attached ReproduceTools.zip and ShellScript.zip
will contain all of the necessary scripts to reproduce the following issue.
**Please adjust the argument when script executing
Steps to reproduce
- Set up Liferay DXP at patch level DE-25 + liferay-hotfix-2680-7010
- Set up Database at Oracle 12
- Configure an Oracle DB and configure Liferay to use it
- Add portal-ext.properties
layout.user.private.layouts.enabled=false layout.user.private.layouts.auto.create=false layout.user.public.layouts.enabled=false layout.user.public.layouts.auto.create=false company.default.locale=ja_JP
- Start up Liferay DXP
- Create 2000 sites by performing the following steps:
- Go to Server Administration > Script
- Run script "1.AddOrganizationGroovyScript.txt" to create sites
- Assign Administrator user to group using the second script:
- Run script in "2.1.AssignUserToGroup.txt"
- Add public page and private page to each of the created sites using the 3.1 and 3.2 scripts:
- Run script in "3.1.1.AddPageToGroup.txt" (Create Private pages)
- Run script in "3.2.1.AddPageToGroup.txt" (Create Public pages)
- Set Site Template "intranet" to all of the created sites using the 4.1 and 4.2 scripts
- run script in "4.1.1.AddLayoutsetToGroup.txt" (Set up site templates on Private page)
- run script in "4.2.1.AddLayoutsetToGroup.txt" (Set up site templates on Public page)
- Go to public site (Liferay DXP)
- Use browser developer tool get "JSESSIONID" parameter values from cookie
- Set the got values to Shell Script "JSESSIONID" parameter(both curl1.sh and curl2.sh)
- Run Shell Script in "curl1.sh"(Because it may take time, be careful of session time out.)
- Run Shell Script in "curl2.sh"(Because it may take time, be careful of session time out.)
- Go to Configuration(編集) > Site Setting(サイト設定)(Access "Site Setting" twice)
Actual Results
Output Internal Server Error.
{{com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000._ [Sanitized]}}
Expected Results
View Site Settings NO errors