Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-85488

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

    Details

      Description

      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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                david.zhang David Zhang (Inactive)
                Reporter:
                david.zhang David Zhang (Inactive)
                Participants of an Issue:
                Recent user:
                David Zhang (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  1 year, 12 weeks, 4 days ago

                  Packages

                  Version Package
                  7.0.X
                  7.1.X
                  Master