JIRA ticket transition does not show

[JIRA Team Mailbox]

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.

[Deleted user]

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

[JIRA Team Mailbox]

Is there any SQL queries to check the integrity ?

[Nic Brough -Adaptavist-]

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)

[Vasiliy Zverev]

Check that this issue type exsisits into default issue type scheme and into issue type scheme assotiated with this project.