nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How can I delete orphaned sprints?

EdwardC_9bdcx9

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.

Accepted answers

All comments

WeAreAllJustinNow

You can delete the sprint in the database.

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

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

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

Create a Filter that gets all issues across all projects
Create a Board based on the filter from step 1
Create a random Issue, and associate it with the Sprint that you want to delete
The orphaned / unavailable Sprint now shows up in the Board from step 2
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_k32ufl

you sir are a hero, thank you!!!

Stuart Tiedeman

Brilliant - thanks for posting this...

Warren Sergent_xnlbhu

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-software

jira-cloud