Jira Errors due to non-existing status

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 attempting to perform various actions it fails with errors.  This includes searches, viewing issues, view Agile boards, creating Agile boards, etc.

The following errors may appear in the atlassian-jira.log, depending on the various actions:

2018-08-08 09:23:41,367 https-jsse-nio-8443-exec-20 WARN admin 563x439985x1 4het9v 0:0:0:0:0:0:0:1 /secure/QueryComponent!Jql.jspa [c.a.jira.workflow.AbstractJiraWorkflow] Workflow 'Test Workflow' contains step 'In Progress' (ID:17) which is linked to non-existing status (ID:12345)

2018-08-08 10:07:23,972 https-jsse-nio-8443-exec-17 WARN admin 607x445953x1 j8un30 0:0:0:0:0:0:0:1 /secure/QuickSearch.jspa [c.a.jira.workflow.AbstractJiraWorkflow] Workflow 'Test Workflow' contains step 'In Progress' (ID:17) which is linked to non-existing status (ID:12345)

2018-08-08 09:06:13,666 https-jsse-nio-8443-exec-29 WARN admin 546x438605x1 1gsdonq 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/rapidview/create/advanced [c.a.jira.workflow.AbstractJiraWorkflow] Workflow 'Test Workflow' contains step 'In Progress' (ID:17) which is linked to non-existing status (ID:12345)

2018-08-08 09:03:25,953 https-jsse-nio-8443-exec-15 WARN admin 543x438362x1 y635u9 0:0:0:0:0:0:0:1 /browse/TEST-5619 [c.a.jira.workflow.AbstractJiraWorkflow] Workflow 'Test Workflow' contains step 'In Progress' (ID:17) which is linked to non-existing status (ID:12345)

2018-08-08 08:57:53,339 https-jsse-nio-8443-exec-16 WARN admin 537x437593x1 y635u9 0:0:0:0:0:0:0:1 /issues/ [c.a.jira.workflow.AbstractJiraWorkflow] Workflow 'Test Workflow' contains step 'In Progress' (ID:17) which is linked to non-existing status (ID:12345)


Diagnosis

From the errors above, we know the following information:

  • The workflow involved is "Test Workflow"
  • The Step that is linked to a missing project is Step with ID 17
  • The Status ID that is expected, but missing, has the ID 12345

If we check the database, we can confirm that there is no step with ID 12345

select * from issuestatus where id = '12345';

Resolution

Remove the step that is linked to an non-existing status.  Note that this will likely fail, so you'll need to follow the steps here:

Last modified on Aug 9, 2018

Was this helpful?

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