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 vote
Accepted answer

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 Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,116 views 4 9
Read article

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