Removed version from project, now issues not visible on Kanban board - reset version for issue?

I had certain issues flagged with a version in JIRA. I removed the version (without removing it from the issues first) and now the affected issues aren't displaying on the Kanban board any more.

This is because the query of the board won't return those issues:

project = KEY and (fixVersion in unreleasedVersions() OR fixVersion is EMPTY)

This is because for the affected issues somehow the Version field is in limbo and is neither empty, nor containing a version... I tried to clear the value of the Version field through bulk edit, I also similarly tried to set a different version, then clear the field. However nothing will make the issues display, only adding another version to them. Re-indexing didn't help either.

How can I completely wipe out the Version field of these issues so they are matched by the query, or how can I otherwise solve the issue?

Thanks in advance!

4 answers

1 accepted

1 vote
Accepted answer
Mauro Badii Atlassian Team Jul 29, 2015

The problem is caused due to this bug:

A database update is required to workaround the problem until the problem is fixed.

Unfortunately this is the case.

1 vote

If you delete a version, it should be stripped off the issues as well.  How did you do the "remove" of the version?


Under Project admin/Versions. The version is not actually visible under the issues but still the above query indicates that the Version field is not empty.

I apologise, I was not clear there. When you "removed" it, what do you mean? Merge? Release? Archive? Delete?

Ok, that sounds like a bug - when I delete a version on the demo system I have here, it is removed from all the affects/fix version fields in my project Could you try re-indexing the project (in the project admin screen) and check the Kanban board again?

I see. I tried re-indexing (also mentioned it in the question) but it didn't help. I'd delete and re-add the issues in questions but there are dozens of them.

Right, so you are on Cloud. When you deleted the version, which option did you choose? "Remove version" or "swap to other version"?

It was Remove version. The affected issues don't have any version (that is visible) specified right now.

Ok, this definitely needs to go to Atlassian support. The query "project = Key and fixVersion is empty" should be returning these issues (assuming there was only one fixVersion, and that's the one you deleted). The next step would be to read the logs, but you can't on Cloud. It's definitely broken, and they need to take a look for us.

This is what happened, so yes, I think too that there is not much else to do. Raised a ticket, will come back if it's solved.

Mauro Badii Atlassian Team Jul 29, 2015

Great work @Nic Brough [Adaptavist] helping troubleshoot! (y)

The reindex should have fixed as Nic advised... maybe try renaming 3 folders within the caches/indexes folder found in JIRA install directory and then perform a locked re-index. Once completed remove these renamed folders which are (changes, issues, entities).

I'm on Cloud so this is not an option unfortunately.

Ahh so it is, putting a request into Atlassian support may help, though I doubt they will go into that level of support

change the query for the board to project = KEY

That should display the missing issues also. Check the version number for these.

Bulk update the version for the 'missing issues' to a consistent value other than empty, say 'LATER'

change the query for the board to project = KEY and version = LATER

So if I understand correctly you advice adding a version to the affected issues. This is a workaround I though about (see the question) but I'd rather not have a version specified for the issues (this is why I removed the version in the first place) and would like to handle them as if their version would be empty, as it appears.

You're right, you really should not have to do this. It should be empty

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,512 views 15 20
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