SQLSyntaxErrorException: ORA-01795 shows due to "IN" statement for OracleDB.

• Type: Bug
• Status: Closed
• Resolution: Duplicate
• Affects Version/s: 7.1.10 DXP FP1
• Fix Version/s: 7.0.X, 7.1.X, Master
• Component/s: Environments > Databases
• Labels:
  • ee-ts

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

1. Set up Liferay DXP at patch level DE-25 + liferay-hotfix-2680-7010
2. Set up Database at Oracle 12
3. Configure an Oracle DB and configure Liferay to use it
4. 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

1. Start up Liferay DXP
2. Create 2000 sites by performing the following steps:
   1. Go to Server Administration > Script
   2. Run script "1.AddOrganizationGroovyScript.txt" to create sites
3. Assign Administrator user to group using the second script:
   1. Run script in "2.1.AssignUserToGroup.txt"
4. Add public page and private page to each of the created sites using the 3.1 and 3.2 scripts:
   1. Run script in "3.1.1.AddPageToGroup.txt" (Create Private pages)
   2. Run script in "3.2.1.AddPageToGroup.txt" (Create Public pages)
5. Set Site Template "intranet" to all of the created sites using the 4.1 and 4.2 scripts
   1. run script in "4.1.1.AddLayoutsetToGroup.txt" (Set up site templates on Private page)
   2. run script in "4.2.1.AddLayoutsetToGroup.txt" (Set up site templates on Public page)
6. Go to public site (Liferay DXP)
7. Use browser developer tool get "JSESSIONID" parameter values from cookie
8. Set the got values to Shell Script "JSESSIONID" parameter(both curl1.sh and curl2.sh)
9. Run Shell Script in "curl1.sh"(Because it may take time, be careful of session time out.)
10. Run Shell Script in "curl2.sh"(Because it may take time, be careful of session time out.)
11. 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