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.

Renjith Pillai Community Champion Jan 19, 2013

What does the database query say?

select * from AO_60DB71_RAPIDVIEW

Suggest an answer

Log in or Join to answer
Community showcase
Jason Wong
Published yesterday in Agility Beta

Welcome to agility

Every team in the world is unique, and so   Atlassian believes   that each and every team's best way of working  needs to  be molded to their unique circumstances  – ...

358 views 6 15
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot