Resolution Field - new values in German???? Edited

I´m Jira admin for 1 year. As I overtook the Jira administration, I saw, there are too many values for the field resolution. Some in English and the same values in German. So in April I deleted the German values or replaced them by English values. And I translated the English values to German.

And now, I have some German values back - I did not create them. How is is possible? where are the coming from? Due upgrade????

someone with the same problem?

Jira Software 7.3.2


View Resolutions - EVN JIRA - Internet Explorer_2017-11-15 14-39-02.png

1 answer

0 votes
Lenard Lee Atlassian Team Nov 15, 2017

Hello Ingrid,

If I understand correctly, the custom fields were deleted back in April 2017, but suddenly re-appeared recently?
Was there any upgrades or other significant changes done (example: System restore) to your JIRA instance recently?

  1. Could you run the query "select * from customfield;" and take note of the result.
  2. Next, go ahead and remove a couple the custom fields that re-appeared.
  3. Immediately after removing, go back to the database and run the query "select * from customfield;" again.
  4. Compare the before delete and after delete results to check whether the custom fields are deleted from the database.

Best regards,

Hi Lenard,

not custom fields, but the values in the field "Resolution". 

I deleted them back in April 2017 (or replaced the with the English value) and now some of them are back - see the screen shot - the german values. They look like being part of "out of the box" delivery an cannot be matched to the existing English values (which are also part of the out of the box version...).

Unfortunately I cannot say, on which date they exactly came back. I just saw yesterday, that they are back again.

To your question: no, we did not system restore. We did just some small updates of Jira Software and Zephyr for JIRA (currently version 3.6).

I thought maybe this is known problem with the values in the resolution field and using Jira in German language (or another language than English).

Best regards,


Lenard Lee Atlassian Team Nov 16, 2017

Hi Ingrid,

My apologies. Apparently, I've misread the initial description.

It would be odd that these values are returning. At the moment, it seems that somehow, the system was rollbacked. Or, someone restored JIRA with a backup that contains the resolutions.

Do try running the query below to confirm that the resolution value exists in the database.

SELECT * FROM resolution;

Next, crosscheck against the jiraissue table to see whether there are any issues whose resolution contains the deleted resolutions.



Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,295 views 5 10
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