Removing Workflow Step Fails with No status with that ID could be found, it may have been deleted.

Problem

When trying to remove a step from a workflow in Jira Server, an error occurs: "No status with that ID could be found, it may have been deleted."

Resolution

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:

    1 2 3 <step id="12" name="deletemestatus"> <meta name="jira.status.id">10200</meta> </step>

• In this example case, the ID is 10200

Workaround - Database Fix

1. Create a brand new status ( Jira Admin > Issues > Statuses > Add status)

   1. For this example, I will name the new status "deletemestatus2"

2. Access the database and run the following query:

   1 select * from issuestatus where pname = 'deletemestatus2';

   1. Take note of the ID that is returned from the SQL query

3. We now have the ID from the problematic workflow step, 10200, and the ID from the newly created status.

4. Update the newly created status to use ID 10200.

   1 update issuestatus set id = '10200' where id = 'XXXXX';

   • Replace XXXXX with the ID from in from step 2 above.

   • If you are connected Jira with Oracle database, please execute the commit command after run the UPDATE statement:

     1 commit;

5. 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.

6. Finally, go back to editing the workflow and remove the workflow step.

7. You can also clean up the additional statuses that we created.