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).
Windows Server 2008 / SQL Server 2008 R2 / Tomcat