How can I delete orphaned sprints?

Hi JIRA Support:

I've run into an issue where orphaned sprints from deleted boards still show up in my project. Is there a way to delete orphaned sprints after I've deleted the boards? The issue I'm having is the same as what is posted under the first response (copied support text) from this thread:

https://answers.atlassian.com/questions/295346

Thanks in advance.

2 answers

Hi,

I'm not sure if it helps, but I have an alternate that I tried. Assuming your situation was like mine, then this may help. This is also for anyone else who stumbles upon this.

This ticket outlines a solution in the comments - I followed the advice here and it worked
https://jira.atlassian.com/browse/GHS-11263

  1. Create a Filter that gets all issues across all projects
  2. Create a Board based on the filter from step 1
  3. Create a random Issue, and associate it with the Sprint that you want to delete
  4. The orphaned / unavailable Sprint now shows up in the Board from step 2
  5. Delete the Sprint (if it is in planning) or Close the Sprint (if it is already active)

    This worked well for me and took about ten minutes; I had 20 orphan sprints to clean-up. 

You can delete the sprint in the database.  

  1. Take a backup of your system.
  2. Shut down JIRA.
  3. Find the ID of the sprint in question:  SELECT * FROM AO_60DB71_SPRINT
  4. Delete the offending sprint:  DELETE FROM AO_60DB71_SPRINT where ID = <ID>
  5. Restart JIRA
  6. Reindex.

The above queries are written in MySQL syntax.  You may need to tweak the syntax if you are running another database platform.

Suggest an answer

Log in or Join to answer
Community showcase
Emilee Spencer
Published yesterday in Marketplace Apps

Marketplace Spotlight: DeepAffects

Hello Atlassian Community! My name is Emilee, and I’m a Product Marketing Manager for the Marketplace team. Starting with this post, I'm kicking off a monthly series of Spotlights to highlight Ma...

37 views 0 3
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