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

3 votes
Accepted answer

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 votes
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
Community showcase
Published yesterday in Agile

How Scrum works? It starts with training and education

To answer “How scrum works,” most of the teams I've worked with first addressed the question: “where to start?”  That question applies to both implementation and improvements on the Scrum framew...

168 views 3 5
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