JQL Tricks function hasSameValues("reporter", "assignee") fails with error

issue in hasSameValues("reporter", "assignee") in advanced search fails with error.

This is the same message both  on our production: jira 6.4.5/JQL Tricks 5.3.10

and second testing env jira 7.2.9/JQL Tricks 7.0

Logs on both the machines say: 

2017-10-04 05:04:27,471 http-bio-443-exec-2796 ERROR jiraadmin 303x974986x5 1tsjcm3 132.186.191.9 /rest/issueNav/1/issueTable [issuenav.service.issuetable.DefaultIssueTableService] com.atlassian.jira.issue.search.ClauseTooComplexSearchException: A the following query was too complex to generate a query from: {issue in hasSameValues(assignee, reporter)}

But the same function with different parameters issue in hasSameValues("fixVersion", "affectedVersion") gives output.

Our instance has about 170,000 issues - is that too big for this query?

So I tried "project = XYX and state = Registered and issue in hasSameValues("assignee", "reporter")" to reduce the search scope, but it gives the same error.

Any ideas on what else to try? What is really happening here?

 

image.png

1 answer

1 accepted

1 votes

This is a known issue due to a limit set internally by Apache lucene. Can you try increasing the value of "jira.search.maxclause" property to a higher value like 200000 and see if it works? You will have to add this property in jira-config.properties file and restart JIRA.

Check out https://confluence.atlassian.com/jirakb/how-to-edit-the-jira-config-properties-file-317194938.html on how to add this advanced property in JIRA.

If that doesn't work, create a support ticket with J-Tricks.

Thanks, Jobin.

Unfortunately, I can't relax the search results for queries as it is a decision made sometime back already.

I will take this as a answer, though.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,804 views 11 18
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot