maxClauseCount | Community
Skip to main content
roberth55706517
roberth55706517
Level 4
December 3, 2015
Solved

maxClauseCount

  • December 3, 2015
  • 17 replies
  • 4800 views

I have a client where they have been talked into using AEM and scene7 as a warehouse for their images. We have run into a snag where some users are getting an exception that displays in the left toolbar stating that the maxClauseCount has been breached and that the current count is 1024. Once this happens, the UI is in an unusable state where you are unable to navigate anywhere and if you are impersonating them, the admin account can't revert back to themselves either. I found the solrconfig.xml in the CRX/DE tree and changed the MaxBooleanClauses to 10240, yes excessive I know, and added a maxClauseCount of the same value. I then restarted the AEM but there was no change in behavior. Since this does not affect all users, what should I look for that may be specific to the users having the problem?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Sham_HC

5.6.1 & AEM6 had issue . Tracked at GRANITE-3909 which is resolved through hotfix NPR-3590.  AEM 6.1 includes the fix.  File an support ticket with logs & query triggered will help to find is product issue or other.    Generally it happens if you have nested groups & get into redundant or conditions. 

17 replies

Show previous replies
smacdonald2008
smacdonald2008
Level 10
December 3, 2015

Did you see this blog entry:

http://blogs.adobe.com/dmcmahon/tag/maxclausecount/

It provides a workaround of getting smaller result sets in the query. 

I have passed this one to internal Adobe people. 

roberth55706517
roberth55706517Author
Level 4
December 3, 2015

I've seen that and several others. The problem is that the query isn't in any code I can control. It is deeper in the com.day.cq.workflow.WorkflowSessionImpl class. Or some other class it calls to get the inbox items. Thus why I ended up here.

Sham_HC
Sham_HCAccepted solution
Level 10
December 3, 2015

5.6.1 & AEM6 had issue . Tracked at GRANITE-3909 which is resolved through hotfix NPR-3590.  AEM 6.1 includes the fix.  File an support ticket with logs & query triggered will help to find is product issue or other.    Generally it happens if you have nested groups & get into redundant or conditions. 

roberth55706517
roberth55706517Author
Level 4
December 3, 2015

Sham HC wrote...

5.6.1 & AEM6 had issue . Tracked at GRANITE-3909 which is resolved through hotfix NPR-3590.  AEM 6.1 includes the fix.  File an support ticket with logs & query triggered will help to find is product issue or other.    Generally it happens if you have nested groups & get into redundant or conditions. 

 

So the problem that I see is that there are over 1024 tasks for given groups. How much nesting is too much? Is it also a problem when users are in multiple groups? It still seems to me that the code could be smarter so that it doesn't come close to the limit when I only want 3 records. There will still be a problem with the task list form. That form should show all of the tasks or have a way to view a subset at a time.

roberth55706517
roberth55706517Author
Level 4
December 3, 2015

roberth55706517 wrote...

Sham HC wrote...

5.6.1 & AEM6 had issue . Tracked at GRANITE-3909 which is resolved through hotfix NPR-3590.  AEM 6.1 includes the fix.  File an support ticket with logs & query triggered will help to find is product issue or other.    Generally it happens if you have nested groups & get into redundant or conditions. 

 

So the problem that I see is that there are over 1024 tasks for given groups. How much nesting is too much? Is it also a problem when users are in multiple groups? It still seems to me that the code could be smarter so that it doesn't come close to the limit when I only want 3 records. There will still be a problem with the task list form. That form should show all of the tasks or have a way to view a subset at a time.

 

Looking at the relationships, the users are in one or two groups that are members of another group that provides the needed permissions. I didn't want to have to duplicate all of the permissions for every group. Deepest inheritances is one parent. I still believe the root cause is too many inbox items.

roberth55706517
roberth55706517Author
Level 4
December 3, 2015

The nested group things doesn't work well. I'm a member of all of the groups and I don't have the issue crop up on my user account.

roberth55706517
roberth55706517Author
Level 4
December 11, 2015

I found the query that is causing the problem. This is being created somewhere way down in the code and I don't know how to change it or test a work around. 

Any ideas?

I found this by going into the diagnostics tools and looking at the query performance.

Terms & ConditionsAccessibility statement

Loading footer...