@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 a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot