Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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 sir are a hero, thank you!!!

Like Jim_Snape likes this

Brilliant - thanks for posting this...

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.

@Fred Chong Ruth1  Lifesaver, Thank you.

 

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

Thank you Fred!  This worked perfectly!

Beautiful!! Thank you sir!

0 votes

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
TAGS
Community showcase
Published in Jira Software

How to create Jira issus from Excel file?

When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...

4,528 views 22 32
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you