Sprints lost after Jira update


I did an update of Jira from 5.1 to 5.2.2 Today I have Greenhopper 6.1.0 installed.

After the update I had to re-index. After that all Sprints were lost. Also the story estimations weren't displayed in the backlog.

How can I get back my Sprint data? Also the finished Sprints are gone.



3 answers

1 accepted

We had duplicated fields (due to a Greenhopper update).


That explains why the sprints were gone. After the update new fields for Sprint and Story Points were created. I merged the data. Now it's ok.

We just had this exact issue as well. I ended up just updating the propertyvalue column of the propertynumber table from the newly created field id to the old field id, and all the sprints showed back up immediately. Thanks so much for pointing me in the right direction.

0 vote
Joe Wai Tye Atlassian Team Dec 12, 2012

Hi Gerald,

Hmm, it's rather unusual that your Sprints were lost. In that case, may I know if your boards still show up fine?

If it does, could you try restarting your instance, and see if it helps?

Thanks for your answer.

The boards were empty. I'll try the restart approach.

It's been a while.

Restarting Jira did not change anything.

hi gerald.

can you confirm that all issues still exist?

could you add a screenshot of your empty planing board please?

No i mean the issues inside the sprints you are missing. My thought was aiming on some epic labels that might be highlighted unwanted wich will cause empty backlogs as well

well, the issue basically exist, however some estimations were gone.

Unfortunately we already created new sprints, so I've got no emtpy board anymore.

at this point - we just have started using Greenhopper - there were no Epics.

As I said the issues in the backlog were present. It seems that the Sprint Objects have been deleted.

What does the database query say?

select * from AO_60DB71_RAPIDVIEW

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Marketplace Apps

Tips on how to choose the best estimation method for your planning

Planning and grooming sessions all come with their own sets of rules. Team members meet to estimate stories or other work items, all according to an agreed-upon process. And with every session comes ...

65 views 0 11
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