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. 
Mayur Jain I'm New Here Sunday

you sir are a hero, thank you!!!

0 votes
Justin Burke Atlassian Team Jan 30, 2015

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 Sign up to answer
Community showcase
Published Monday in Jira Service Desk

Frequently Asked Questions for Jira Service Desk (AKA JSD FAQ)

Just the FAQs! Welcome to the Community, and this Focused-FAQ! Here, we've pulled together some of the most frequently asked questions associated with Jira Service Desk (JSD). We hope ...

139 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