Resolution dropdown has garbage content from comments

Question

In both our prod and staging environments, and a bug being set to Done, the Resolution dropdown suddenly has dozens of garbage items.  After some research, I've found that those are clearly from comments made in various issue types, in a relatively new project.

I think this may have been a data corruption in our latest true up, but I don't want to delete them if someone for some reason(?) copied and pasted these in this location.  It's weird.  I'm also concerned that before we upgrade to Jira 8.6, 8.5.1, which we just did, that this may port over to the other environments once we true them up again.

Can anyone suggest how I determine when this happened, and how, and by whom?  And/or if it was a DB corruption?

Thanks,

Anjani M.

Anjani Millet · Answer

1) Here is a screenshot for View Resolutions; half way down the page, the items in the resolution column begin with

Resolution: "Adjustments made to team sequencing, tools team has a plan.​"

2) This resolution, if put into a jql query, "Adjustments made to team sequencing, tools team has a plan", is pulled from Comments in an issue made by "Ops Support Vijay" in the Working Model STAR project - Vijay is a member of our team.

Every one of these comment-resolutions tracks back to a comment made byt Ops-Support-Vijay on the Working Model STAR project, which is new.

Just learned this appears to have been a Sharepoint error, imported during our upgrade/true up.  I'm not certain, still investigating.  As far as you know, could this have anything to do with 8.5 or upgrade to it?

Anjani

Leonard Chew · Answer

The resolutions should definitely NOT change just because of commenting.

Some checks that might help:

* Log in  as administrator and go to your "View Resolutions" screen and check if the resolutions are really persisted.
* You can also check the resolutions on your Jira-database with this SQL query:select * from resolution;

* Check if the unwanted resolutions are used in any issue by executing a JQL:resolution in (a,b,c)

* Delete the unwanted resolutions.
* Unfortunately the audit log will not have a log entry when to see who added a new resolution. Therefore it is difficult to find out who added one.
Vote for this jira change request: https://jira.atlassian.com/browse/JRASERVER-42746
* Restrict your workflows to only show the resolutions you want by setting the resolution property (jira.field.resolution.include) on your resolution transition.

Deepanshu Natani · Answer

Can you share a screenshot?