Workflow transition button missing from the issue view page in Jira server
This article only applies to the Atlassian server platform. Learn more about the differences between cloud and server.
The workflow transition button is no longer available on the issue view page although the issue is not in a closed status.
Run the following query against the JIRA database (in this example, the database is and the issue is with the key "TTWO-4"; table name 'os_wfentry' is case sensitive and is 'OS_WFENTRY' in mysql)
jira_6412=# select * from os_wfentry where id = (select workflow_id from jiraissue where issuenum = 4 and project = (select id from project where pkey = 'TTWO')); id | name | initialized | state -------+------+-------------+------- 10100 | test | | 3 (1 row)
There are 3 possible causes:
- The workflow applied (value of the "name" column) on this issue is no longer associated with the project.
- The issue state is not active. (The value for the "state" column: 0 for Inactive, 1 for Active, 3 for Killed, 4 for Complete)
- Refer to JIRA doesn't display any transitions for issues in the issue view page if cause 1 and 2 doesn't apply
Alwaysyour data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
Please run the integrity checker to fix the issue.
In case the integrity checker is not able to fix the issue:
- Workflow inconsistency : Please move the issue to another Issue Type or Project then move it back to force JIRA to trigger a workflow remap.
update os_wfentry set state = 1 where id = (select workflow_id from jiraissue where issuenum = 4 and project = (select id from project where pkey = 'TTWO'));