How can I delete orphaned sprints?

[EdwardC]

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.

[Fred Chong Rutherford]

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. 

[Mayur Jain]

you sir are a hero, thank you!!!

[Stu]

Brilliant - thanks for posting this...

[Warren Sergent]

Sadly this is not an option in our case where we have literally hundreds (in fact, there's no way of determining how many either) of orphaned sprints due to a mass clear out of old projects.

We need a way to mass-delete empty/orphaned sprints - otherwise they show up in the Create/Edit issue Sprint dropdown.

[Jim_Snape]

@Fred Chong Rutherford  Lifesaver, Thank you.

There should be a much easier way to do this though...

[Michelle Lauer]

Thank you Fred!  This worked perfectly!

[Richard Petrie]

Beautiful!! Thank you sir!

[WeAreAllJustinNow]

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.