@Nic Brough [Adaptavist], the case is as described in article.
Diagnosis query select * from os_wfentry where id = (select workflow_id from jiraissue where issuenum = 4 and project = (select id from project where pkey = 'TTWO')); has shown that state is 0.
But even after 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')); and having state equal to 1, buttons in issue are still absent.
When you run almost any SQL on JIRA, you must have it shut down when you do it. If it's SQL affecting issues like this, then it's a definite. (The "almost" is because there are filter stuff you can change). Stop JIRA, check that the data you've changed is still changed in the database, and then restart it.
@Nic Brough [Adaptavist],there is "Only the assignee of the issue can execute this transition" on one of them, "Only users with Resolve Issues permission can execute this transition" on another one, and two transiotions without any conditions. Permission Checker confirms I have all necessary permissions. Another ticket of the same Issue Type works just fine.
@Nic Brough [Adaptavist],I had assigned a copy of current workflowto this issue type, and it soled the problem. So, as conclusion, if changing state to 1 is not enough, I shold assign copy of workflow. Or start with reassigning workflow, and it will work even without running SQL query.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events