Workflow transition button missing from the issue view page in Jira server

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

The workflow transition button is no longer available on the issue view page although the issue is not in a closed status.

Diagnosis

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) 

Cause

There are 3 possible causes: 

  1. The workflow applied (value of  the "name" column) on this issue is no longer associated with the project.
  2. The issue state is not active. (The value for the "state" column: 0 for Inactive, 1 for Active, 3 for Killed, 4 for Complete)
  3. Refer to JIRA doesn't display any transitions for issues in the issue view page if cause 1 and 2 doesn't apply

Workaround

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.

  • 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.
    • Issue state inconsistency ( JRA-26454 - Getting issue details... STATUS ): Please run the following query against the database:

      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'));

DescriptionThe workflow transition button is no longer available on the issue view page although the issue is not in a closed status.
ProductJira
PlatformServer
Last modified on Sep 25, 2019

Was this helpful?

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