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

This article only applies to the Atlassian server platform. Learn more about the differences between cloud and server.



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
Option 1 - 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.
Option 2 - Creating a new workflow with the XML
  1. Remove the entire step via the XML and re-import the XML.
    1. From the above example, it means removing all contents from where we see the <step id...> until the </step> flag.
  2. Once done Import the XML as a new workflow
  3. Migrate all issue types using the old workflow to the new
  4. 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


Last modified on Aug 9, 2018

Was this helpful?

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