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

ORA-01795 exception in logs when assign UserGroup( >1000users) to Site membership

    Details

    • Branch Version/s:
      7.3.x, 7.2.x, 7.1.x
    • Backported to Branch:
      Committed
    • Fix Priority:
      3
    • Databases:
      Oracle Database 10.1, Oracle Database 10.2, Oracle Database 11.1, Oracle Database 11.2, Oracle Database 12c Release 1, Oracle Database 12c Release 2
    • Sprint:
      U&SM| 21 Sprint 4|3.9-3.30, U&SM| 21 Sprint 5|3.30-4.20

      Description

      Steps to reproduce:

      1. Setup Liferay DXP with Oracle DB
      2. Create a User Group
      3. Create 2000 users, assigned to the User Group
      4. Create a private site.
      5. Goto New Site -> Members -> Site Membership -> User Groups.
      6. Click on the New icon.
      7. In pop up, search for the above-created Usergroup and select.
      8. Click on "Done"

      Expected result: The users are added to the group with no error
      Actual result: The following error message is in the logs: ORA-01795: maximum number of expressions in a list is 1000_

        Attachments

          Activity

            People

            Assignee:
            sharry.shi Sharry Shi
            Reporter:
            laszlo.hudak Laszlo Hudak (Inactive)
            Participants of an Issue:
            Recent user:
            Clarissa Velazquez
            Engineering Assignee:
            Christopher Kian
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              24 weeks, 3 days ago

                Packages

                Version Package
                7.1.10 DXP FP23
                7.1.10.6 SP6
                7.1.X
                7.2.10 DXP FP12
                7.2.X
                7.3.7 CE GA8
                7.3.10 DXP FP2
                7.3.X
                7.4.0 CE GA1 DXP 7,4
                Master