It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Confluence groups and Active Directory (AD)

Re : Confluence Groups

Hi Confluence gurus,

We use Confluence version 5.7 (Server), and are trying to upgrade to 6.1 in our DEV environment.  We use Active Directory (AD) for our groups.

One of our senior developers tried to access Confluence in DEV, and rec'd this error ...

“maximum number of expressions in a list is 1000 -- limits the number of elements in an Oracle IN predicate to 1000 entries.  However, the given parameter list [groups] contained 1103 entries, which will likely cause failures to execute the query in the database. “

We (Developers, Service Desk and BA's)  are going through and doing a group clean-up as they have gotten totally out of hand, however, I'd like to understand more about how Confluence and AD interact.

What I am trying to ascertain is:

  1. Is there a workaround or quick fix for the error message above?
  2. What is the ideal size of groups for a user?
  3. How does Confluence read the groups from AD?
  4. Is there a way to group the AD groups into a parent and child relationship?
    1. As an example, we have 71 Media types, and each have an Edit and View group, so there are 142 groups associated with Media alone.
    2. Ideally, I would like to create a parent entitled Media and group the 142 rows under the parent.
      • Note: These were created to allow users to create, edit and view attachments in an 'in-house' application, while still allowing staff to filter and report on the different 'types'.  Eg. Mediaexampletype1 or Mediaexampletype2
  5. Would creating a parent/child relationship work, or is there a better way to do it?

Thanks in advance.


1 answer

As I recall you can enable paged result of the AD/ LDAP queries. I would try this setting in the LDAP configuration first. You could also try incremental synchronization, if possible in your environment Check documentation:

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Confluence Cloud

What's New in Confluence Cloud – June 2020 Edition

Ready for the monthly rollup of what happened in May for Confluence Cloud? Improved mobile login experience (& SSO) For those of you with the Confluence mobile app, we know the login experien...

24,914 views 40 79
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you