Workflow transition button disappeared from the issue view page

Still need help?

The Atlassian Community is here for you.

Ask the community

This Knowledge Base article was written specifically for the Atlassian Server platform. Due to the Restricted functions in Atlassian Cloud apps, the contents of this article cannot be applied to Atlassian Cloud applications.

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 issue is with the key "TTWO-4")

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 other issue type 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'));

Last modified on Jul 17, 2017

Was this helpful?

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