A role which was used in a post function has been removed, and now we cannot remove the post function which referenced that role

Description

We had several post functions on the create transition of a workflow which "Set Issue Security from Role Member". Correspondingly, another admin removed a few roles which were referenced by these post functions.

We now cannot remove the offending post functions via the JIRA UI.

What options do we have at this point, as it seems that re-creating the roles is not an option due to the fact that the post function references the project role ID, which will not be the same.

Could you point us at the table we'd need to remove a row from to fix this (we're comfortable editing SQL if that's the case).

Environment

Windows Server 2008 / SQL Server 2008 R2 / Tomcat

Customer Info

None

Assignee

Unassigned

Reporter

Eban Tomlinson

Labels

None

Internal Complexity

Unknown

Internal Value

Unknown

SEN

None

Requires documentation

None

Impact

None

Fix versions

Affects versions

Priority

Major
Configure