Removing Workflow Step Fails with No status with that ID could be found, it may have been deleted.
Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.
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
Workaround - 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.