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:
            Sophia Zhang
            Engineering Assignee:
            Christopher Kian
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              1 year, 6 weeks, 6 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
                7.4.13 DXP GA1
                Master