I cannot transition subtasks and the parent is closed

[Jessica Mathers]

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

[Laurent Bierge]

Hi,

You may try this KB:

https://confluence.atlassian.com/jirakb/workflow-transition-button-disappeared-from-the-issue-view-page-800304645.html

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

[Patrick Cartier [Candylio]]

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:

https://community.atlassian.com/t5/Answers-Developer-Questions/Block-subtask-transition-based-on-parent-s-status/qaq-p/499408

hope this helps!