Workaround for Issue state inconsistency was not helpful.

This question is in reference to Atlassian Documentation: Workflow transition button disappeared from the issue view page

Ask your question here...

1 answer

1 vote

You'll need to go into a bit more detail for your exact case.

@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.

 

Did you try the integrity checker?  Was JIRA shutdown when you ran the SQL?

@Nic Brough [Adaptavist], Yes, I did, but the page didn 't show the results as it should (We have large enough enstance). No, JIRA wasn't shutdown.

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], Thanks a lot. Will try it today in the evening and keep you posted.

@Nic Brough [Adaptavist], I had stopped JIRA by stop-jira.sh command, had run SQL query, started jira, but still see buttons in ticket are absent. State is equal 1.

Hmm.  I'd still have expected the integrity checker to have picked it up, even if it could not fix it.

I'd like to take a step back - what are the conditions on the outgoing transitions for that status?

@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.

Changing the workflow does the same job as the integrity checker - rebuilds the pair of tables.  So it's a valid solution.

@Nic Brough [Adaptavist], thank you for your assitance.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted yesterday in Jira Service Desk

Looking for anyone who has switched from Zendesk to Jira Service Desk

Hi Community! The Jira Service Desk marketing team is looking for customers who have successfully switched from Zendesk to Jira Service Desk!   We’d love to hear your thoughts on the pros and ...

29 views 0 1
Join discussion

Atlassian User Groups

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!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you