Summary
JIRA Status at Statuses page shows "No associated workflows", if you tried to Delete the status, you will get following error: Given status is currently associated with a workflow(s) and cannot be deleted .
It's not clear if status is used or not. In this case status is used, but Statuses page shows incorrect data.
Steps to Reproduce
- Create status status1 and associate with workflow Workflow1
- Edit workflow_Workflow1_ and remove status status1
Normally this is not possible as JIRA would not allow removing statuses from active workflow
- Don't safe the Workflow1 and keep the draft
- Navigate to [ Admin > Issues > Statuses ]
- Check status for status1
Expected Results
Status has 1 associated workflow
Actual Results
No associated workflows
Notes
- If you proceed with Delete, you will get following error: Given status is currently associated with a workflow(s) and cannot be deleted
- The problem is caused by chain of factors
- Initial Workflow1 had status1
- Workflow1 was edited and draft was not saved
- The draft workflow doesn't have status1
- During computation of workflows for statuses draft workflow is used, so JIRA couldn't detect the status.
Workaround
To fix the problem, please follow the steps below:
- Check status in workflows tables running the SQL query below:
select id,workflowname from jiraworkflows where descriptor like '%status1%';
select parentname from jiradraftworkflows where descriptor like '%status1%';
- Take note on the workflow name from the output.
- Go to the workflow page and edit the workflow.
- Discard or publish the draft workflow and then we will see the status associated with the workflow.
Same issue for 9.12.15 version