JQL Query using was operator returns error

Question

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

Fabio Manzoni_o7b9wf · Answer

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.

Wim Crols_ws6e1u · Answer

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.

Bob Hong · Answer

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.