Sometime in the past, our administrators turned "allow unassigned issues" off. Time passed, but the people clamored for unassigned issues. In their short-sightedness, new administrators, instead of turning the setting back on, created an "Unassigned" user (with the username "unassigned").
Fast-forward and the Unassigned user has 1000s of issues assigned. A benevolent administrator is trying to return to allowing properly unassigned tickets. I was able to bulk edit and change the assignment. But, the Unassigned user's "username" is the same as the special username for tickets that are properly unassigned.
I cannot remove the Unassigned user because it appears, to JIRA, to perpetually have tickets assigned to it!
For anyone else dealing with the same:
I marked the Unassigned user "inactive" so it couldn't be assigned. I changed it's name to "nobody", which helped to see (in some searches) that it really wasn't used. I changed all projects where it was the default-assigned Project Lead to use unassigned properly.
Thanks for sharing this experience with us. Indeed a user cannot be removed when it still has issues created on his username, so it's possible that there is, still something locking it.
I suggest you to check on your database for this user (nobody) and see where it is still set, specially on the tables related to issues such as jiraissue.
Here is the Jira Database Schema:
PS: Instead of checking each table, creating a database dump and then analyzing it as text, should help on looking for this user in all tables at once.
I'm certain that the user has no more tickets assigned. I bulk changed 1000s of tickets today. The fake-unassigned user's profile still shows all of these tickets! I just assigned a new ticket to the built-in unassigned and this fake-unassigned user's ticket count increased!
The problem seems to be in the username (field) or the assignee (search field). It's literally "unassigned" for both my user and the built-in user that JIRA uses for unassigned tickets.
After running this bulk change, did you have the chance to run a full locked re-index?
Please run this and let us know if the indexing of the issues bulk-changed appears correct.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG