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

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.



Problem

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



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:

          <step id="12" name="deletemestatus">
            <meta name="jira.status.id">10200</meta>
          </step>
  • In this example case, the ID is 10200
Workaround - Database Fix

Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.

  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:

    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.
  5. update issuestatus set id = '10200' where id = 'XXXXX';
    1. Replace XXXXX with the ID from in from step 2 above.
  6. 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.
  7. Finally, go back to editing the workflow and remove the workflow step.
  8. You can also clean up the additional statuses that we created.


Last modified on Jul 21, 2020

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.