Hi all,
I have come across a bunch of old subtasks which I cannot transition through any of my workflow, also the parent ticket is closed.
I have checked the workflow and 'subtask' issue types are included.
I also tried to go into issue navigator and 'Bulk Change' but where it would usually say this it says 'No available option(s)'
Any ideas?
Thank you,
Jess
Hi,
You may try this KB:
Try the integrity checker. Else if you have access to the database here's two MYSQL queries that can help to identify broken issue. (it only check inactive issue)
identify:
select p.pkey, ji.issuenum from jiraissue ji, project p, OS_WFENTRY ow WHERE ji.PROJECT = p.ID AND ji.WORKFLOW_ID = ow.ID AND ow.STATE = 0 order by p.pkey;
fix:
UPDATE OS_WFENTRY ow SET ow.STATE = 1 where ow.ID IN (SELECT ji.WORKFLOW_ID from jiraissue ji, OS_WFENTRY ow2 where ji.WORKFLOW_ID = ow2.ID and ow2.STATE = 0);
(You may have to restart Jira)
Regards,
Laurent
Hi @Jessica Mathers,
Is this happening with all issues or just the subtask issue types?
Do you have the transition issue permission?
How are you trying to transition the issues? dragging and dropping or clicking the workflow button and selecting the status?
You might have some conditions on your workflow that are preventing the subtasks from transitioning based on the parent's status like in this answer:
hope this helps!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.