Error 'Could not find workflow status for issue' is thrown when accessing issue
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Fisheye および Crucible は除く
症状
- Issue is exist in the database, but stack trace is thrown
- Project's Workflow Scheme cannot be switch
atlassian-jira.log に次のメッセージが表示される。
ERROR [500ErrorPage.jsp] Exception caught in 500 page Could not find workflow status for issue DEMO-837.
java.lang.RuntimeException: Could not find workflow status for issue DEMO-837.
at com.atlassian.jira.permission.PermissionContextImpl.getStatusGV(PermissionContextImpl.java:113)
at com.atlassian.jira.permission.PermissionContextImpl.getRelevantStepDescriptor(PermissionContextImpl.java:90)
at com.atlassian.jira.permission.WorkflowPermissionFactory.getWorkflowPermissions(WorkflowPermissionFactory.java:30)
at com.atlassian.jira.security.WorkflowBasedPermissionManager.hasPermission(WorkflowBasedPermissionManager.java:75)
In Jira 8.13+:
Caused by: java.lang.RuntimeException: Could not find workflow status for issue DME-10.
at com.atlassian.jira.permission.PermissionContextImpl.getStatusSetOrFromIssue(PermissionContextImpl.java:94)
at com.atlassian.jira.permission.PermissionContextImpl.getRelevantStepDescriptor(PermissionContextImpl.java:76)
at com.atlassian.jira.permission.WorkflowPermissionFactory.getWorkflowPermissions(WorkflowPermissionFactory.java:33)
at com.atlassian.jira.security.WorkflowBasedPermissionManager.workflowPermissionCheck(WorkflowBasedPermissionManager.java:196)
at com.atlassian.jira.security.WorkflowBasedPermissionManager.workflowPermissionCheck(WorkflowBasedPermissionManager.java:172)
at com.atlassian.jira.security.WorkflowBasedPermissionManager.hasPermission(WorkflowBasedPermissionManager.java:83)診断
Run the SQL query below against the JIRA database to check if there any issue with non-existing status.
For versions JIRA 6+
select (p.pkey || '-' || i.issuenum) as issuekey, i.issuestatus
from jiraissue i, project p
where i.project = p.id
and i.issuestatus not in (select id from issuestatus);For versions before JIRA 6
select pkey,issuestatus from jiraissue where issuestatus not in (select id from issuestatus);原因
- Database inconsistency that might be caused by recent workflow switch that is incomplete and
- incomplete status removal
ソリューション
- Create new status(es) to replace the deleted status(es)
Ensure that the inaccessible issues are now visible
- Switch the Project's Workflow Scheme
最終更新日 2024 年 6 月 26 日
Powered by Confluence and Scroll Viewport.