JQL Query using was operator returns error

When attempting to execute a JQL against a username field using the WAS operator, I receive the following error: 

Error occurred communicating with the server. Please reload the page and try again.

This JQL Fails:

assignee was hongbm

 

The WAS operator works against other fields such as status.

This JQL Succeeds:

status = "Design / Review" and status was closed

 

We are on JIRA Server  v7.1.7#71011-sha1:2526d7c now, but are planning on upgrading to the latest JIRA version soon.


Any ideas?  

 

Thanks,

Bob

4 answers

This widget could not be displayed.

WAS operator should work with assignee. Can you provide us a screenshot with the error?

This widget could not be displayed.

image2017-2-10 12:4:14.png

Updated:

After the original message was displayed, I hit enter in the address bar and after about 60 seconds a 500 error was displayed along with diagnostic information.

Technical details
Log's referral number: 97c9d41d-43bd-408c-b2a6-bc594aaff46c
Cause
Referer URL: Unknown
java.lang.IllegalStateException: User 'thy0716' has no unique key mapping.
java.lang.IllegalStateException: User 'thy0716' has no unique key mapping.
at com.atlassian.jira.user.ApplicationUsers.from(ApplicationUsers.java:46) [classes/:?]
at com.atlassian.jira.user.ApplicationUsers.from(ApplicationUsers.java:143) [classes/:?]

....

If I search for the username in User Management, I find an entry but hovering over the user's icon displays:

User does not exist: thy0716

We are integrating with Crowd and an external LDAP server, so I suspect we have some sort of directory sync issue.

Since this may be more than can be addressed here, I've also submitted a separate request with Atlassian Support.

This widget could not be displayed.

Did you find a solution for this?

I have exactly the same error: also using the WAS operator, especially with EMPTY, hangs the server. E.g.

resolution WAS EMPTY ON 2017-10-25

Our domain is https://vikingco.atlassian.net 

I am 100% certain that this worked, because I use it in scripts. These scripts are now broken.

This widget could not be displayed.

Hi everyone,

I had a same problem and open a ticket at Atlassian support.

But, you can use this query  below:

issue in issueHistory() AND assignee = XXXX

Also, you can see the documentation

https://confluence.atlassian.com/jiracoreserver073/advanced-searching-functions-reference-861257222.html

In the ticket, Atlassian ask me to send the Support.zip and the Har file.

See the documentation to create a Har file:

https://confluence.atlassian.com/kb/generating-har-files-and-analyzing-web-requests-720420612.html

I hope this can help you.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

155 views 2 0
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