"My Workflow Tasks > Assigned to my Roles" page can not be loaded due to too_many_clauses: maxClauseCount when the user is a member of a high number of sites

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.1.X, 7.2.X, Master
• Fix Version/s: 7.1.10 DXP FP21, 7.1.X, 7.2.10 DXP FP11, 7.2.10.4 DXP SP4, 7.2.X, 7.3.1 CE GA2, 7.3.2 CE GA3, 7.3.10 DXP GA1, Master
• Component/s: Workflow > My Workflow Tasks
• Labels:
  • ee-ts
  • liferay-dxp-72-sp4
  • liferay-fixpack-dxp-11-7210
  • liferay-fixpack-dxp-21-7110
• Branch Version/s:
  7.2.x, 7.1.x
• Backported to Branch:
  Committed
• Fix Priority: 4
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/86351

Steps to reproduce on master, 7.2.x, 7.1.x (DXP profile) - Simplified to avoid re-compiling and adapting the dummyfactory to master

1. Start DXP and connect to a remote ES6
2. Create 5 new blank sites
3. Stop the ES server
4. Set indices.query.bool.max_clause_count: 5 in ES_HOME/config/elasticsearch.yml just to show that this limit has an impact on the Workflow portlets
5. Restart ES
6. Visit the My Workflow Tasks > Assigned to my Roles page.
    Result : Same error as below.

Steps to reproduce: 7.1.x, 7.2.x (DXP profile) - Similar to the customer's use case

1. Start DXP and connect to a remote ES6.
2. Deploy the DummyFactory module.
3. Add the Dummy Factory widget to a page.
4. Create 2024 sites (blank is fine).
5. Visit the My Workflow Tasks > Assigned to my Roles page.

 
 Result:

2020-03-12 13:57:22.454 ERROR [http-nio-7111-exec-3][render_portlet_jsp:131] null
 NotSerializableExceptionWrapper[too_many_clauses: maxClauseCount is set to 1024]
  at org.apache.lucene.search.BooleanQuery$Builder.add(BooleanQuery.java:114)
  at org.elasticsearch.index.query.BoolQueryBuilder.addBooleanClauses(BoolQueryBuilder.java:422)
  at org.elasticsearch.index.query.BoolQueryBuilder.doToQuery(BoolQueryBuilder.java:385)
  at org.elasticsearch.index.query.AbstractQueryBuilder.toQuery(AbstractQueryBuilder.java:105)
  at org.elasticsearch.index.query.BoolQueryBuilder.addBooleanClauses(BoolQueryBuilder.java:415)
  at org.elasticsearch.index.query.BoolQueryBuilder.doToQuery(BoolQueryBuilder.java:383)
  at org.elasticsearch.index.query.AbstractQueryBuilder.toQuery(AbstractQueryBuilder.java:105)
  at org.elasticsearch.index.query.BoolQueryBuilder.addBooleanClauses(BoolQueryBuilder.java:415)
  at org.elasticsearch.index.query.BoolQueryBuilder.doToQuery(BoolQueryBuilder.java:385)
  at org.elasticsearch.index.query.AbstractQueryBuilder.toQuery(AbstractQueryBuilder.java:105)
  at org.elasticsearch.index.query.BoolQueryBuilder.addBooleanClauses(BoolQueryBuilder.java:415)
  at org.elasticsearch.index.query.BoolQueryBuilder.doToQuery(BoolQueryBuilder.java:385)
  at org.elasticsearch.index.query.AbstractQueryBuilder.toQuery(AbstractQueryBuilder.java:105)
  at org.elasticsearch.index.query.BoolQueryBuilder.addBooleanClauses(BoolQueryBuilder.java:415)
  at org.elasticsearch.index.query.BoolQueryBuilder.doToQuery(BoolQueryBuilder.java:383)
  at org.elasticsearch.index.query.AbstractQueryBuilder.toQuery(AbstractQueryBuilder.java:105)
  at org.elasticsearch.index.query.BoolQueryBuilder.addBooleanClauses(BoolQueryBuilder.java:415)
  at org.elasticsearch.index.query.BoolQueryBuilder.doToQuery(BoolQueryBuilder.java:383)
  at org.elasticsearch.index.query.AbstractQueryBuilder.toQuery(AbstractQueryBuilder.java:105)
  at org.elasticsearch.index.query.BoolQueryBuilder.addBooleanClauses(BoolQueryBuilder.java:415)

Workaround

1. Stop ES.
2. Set indices.query.bool.max_clause_count: 2048 in ES_HOME/config/elasticsearch.yml
3. Restart ES.
4. Visit the Assigned to My Roles page again.
   Page is loaded without errors.

Reference:
https://www.elastic.co/guide/en/elasticsearch/reference/current/search-settings.html