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

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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Jira

5 ways you can make the most of Jira Software and Bitbucket Cloud

As part of the Bitbucket product team I'm always interested in better understanding what kind of impact the use of our tools have on the way you work. In a recent study we conducted of software devel...

75 views 0 5
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