JIRA ticket transition does not show

Question

In our JIRA instance there are two tickets which does not show the transition button.This is only for two tickets rest of the tickets in the same workflow works perfectly. The affected two tickets are in OPEN status and there are out transitions from the OPEN status in the workflow , but it does not show in the specific tickets. We need to close those two tickets. Also i have checked the out condition of OPEN status, no issues of it.

Nic Brough -Adaptavist- · Answer

Yes, but they are horrid and most people don't understand them, and you can't use SQL to fix the problem unless you know *exactly* what you are doing.  Please, use the integrity checker, OR try to create a new set of workflows for the project and migrate to it (as changing the workflow on an issue to anything else, even an identical copy will force the correction of the underlying data)

JIRA Team Mailb · Answer

Is there any SQL queries to check the integrity ?

unknown · Answer

This maybe a bug triggered by something (an add-on or other stuff). You may want to try:

* Running the JIRA Integrity Checker https://confluence.atlassian.com/jira/navigating-to-the-integrity-checker-308609302.html
* JIRA indexing https://confluence.atlassian.com/jira/search-indexing-185729671.html