How do I remove a created issue from a Crucible review Comment?

[Geoff Wilson]

Environment: JIRA v7.0 with an established Application Link to Crucible + Fisheye v3.9.1, both using same Crowd user directory for Single Sign-On between the applications

I need to know how to remove a JIRA issue that was created from a Comment on a Crucible review.  Upon using the "Create Issue" link on a review Comment, it creates the issue & link on JIRA and then is shown in the review's Issues Raised From Comments section.  However, I've learned 2 things: 1) if that JIRA issue is deleted then crucible shows "Error retrieving issue from JIRA" but doesn't remove it, and 2) if on the JIRA issue I remove the link to the Crucible Comment, it also still is shown on the review as if nothing changed. 

So how do I remove the reference to an issue created on a comment, if say that issue is delete OR more importantly if somebody creates a bad issue, gets it deleted, and wants to create a new issue off of the comment?

[lpater · Accepted solution]

Hi Geoff,

Deleting JIRA issues is not very common in most configurations (as it removes all traces of the issue ever existing). Usually a better idea is to have a workflow state in JIRA noting that the issue is no longer relevant.

There currently isn't a UI feature to handle such a case for issues created from comments in Crucible (there are many reasons for this, including we don't really know if the issues has been removed, it might very well just be inaccessible for the current user). There is a feature request related to this functionality, you might want to vote for it, and let us about your use case in the comments.

If it's a one-off operation that you want to do as an administrator, you could stop Crucible, hava a look at the AO_2913F5_COMMENT_ISSUE table in the SQL database, and remove the rows which have the ISSUE_KEY column set to the removed issue(s). After restarting Crucible you should no longer see the issues in the comments.

[Geoff Wilson]

Thanks for the heads up and I agree that deleting would be very rare (but in admin-mode, i am deleting all the tests afterwards). I guess also then if say they created an inline issue from a Comment but accidentally made the wrong type of issue, they can always go in JIRA and use the Convert to Subtask or Move option to change it as necessary instead of being disgruntled that they can't just mark the one they created as invalid and create another from the Comment.