Removing Workflow Step Fails with No status with that ID could be found, it may have been deleted.
This article only applies to the Atlassian server platform. Learn more about the differences between cloud and server.
When trying to remove a step from a workflow, an error occurs: "No status with that ID could be found, it may have been deleted."
Determine the ID of the missing Status
- Export the Workflow to XML (While editing the workflow, click Export > As XML)
- Open the XML and search for the step/status name. For example, in the above screenshot, we see DELETEMESTATUS
You will see something like this:
<step id="12" name="deletemestatus"> <meta name="jira.status.id">10200</meta> </step>
- In this example case, the ID is 10200
Option 1 - Database Fix
Alwaysyour data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
- Create a brand new status ( JIRA Admin > Issues > Statuses > Add status)
- For this example, I will name the new status "deletemestatus2"
Access the database and run the following query:
select * from issuestatus where pname = 'deletemestatus2';
- Take note of the ID that is returned from the SQl query
- We now have the ID from the problematic workflow step, 10200, and the ID from the newly created status.
- Update the newly created status to use ID 10200.
update issuestatus set id = '10200' where id = 'XXXXX';
- Replace XXXXX with the ID from in from step 2 above.
- Next, we need Jira to refresh caches to reflect the new database change. To do this, create yet another new status, just like from step 1.
- Finally, go back to editing the workflow and remove the workflow step.
- You can also clean up the additional statuses that we created.
Option 2 - Creating a new workflow with the XML
- Remove the entire step via the XML and re-import the XML.
- From the above example, it means removing all contents from where we see the <step id...> until the </step> flag.
- Once done Import the XML as a new workflow
- Migrate all issue types using the old workflow to the new
- Delete the old workflow
Resolutions are ways to fix problems in the application once and for all, generally these wouldn't be hacky solutions.
- This is optional depending whether or not a resolution exists, maybe there's only a workaround, or maybe there's a workaround and a resolution
- Give specific step by step directions
You can use a bulleted or numbered list