• Community
  • Products
  • Jira
  • Questions
  • Erroneous warning "You cannot perform this action. The approval "my-approval" is currently used in some Workflow. Do you want delete from all mappings?" when deleting an approval

Erroneous warning "You cannot perform this action. The approval "my-approval" is currently used in some Workflow. Do you want delete from all mappings?" when deleting an approval

Can confirm that the approval to be deleted is isolated away from any workflows or mappings and confirming the deletion via the prompt did not net any negative effect on our current configurations.
Can this be modified so as to not give administrators cause to review their configuration when deleting an approval?

1 answer

1 accepted

Hello Daniel,

I suppose that the Approval that you have deleted is used in an approval configuration specialized for a single issue (https://chicago.herzum.com/confluence/display/HAP/Define+Approvals+for+an+issue).

The add-on alerts if the approval that you are going to delete has been used in an approval mapping or in an approval configuration specialized for a single issue.

Obviously the alert is misleading because doesn't give evidence of the second aspect.

We will update the text on the warning.

 

In order to validate my hypothesis, could you please run the following query on the database?

SELECT DISTINCT project.pkey as ProjectKey, jiraissue.issuenum as IssueNumber,
AO_D195E9_ISSUE_APPROVAL.ISSUE_ID as IssueId
FROM [database_name].AO_D195E9_APPROVAL LEFT JOIN 
[database_name].AO_D195E9_ISSUE_APPROVAL ON
AO_D195E9_APPROVAL.ID = AO_D195E9_ISSUE_APPROVAL.APPROVAL_ID
LEFT JOIN 
[database_name].jiraissue ON jiraissue.ID = AO_D195E9_ISSUE_APPROVAL.ISSUE_ID
LEFT JOIN [database_name].project ON project.ID = jiraissue.PROJECT
WHERE
AO_D195E9_APPROVAL.NAME = 'my-approval'
AND AO_D195E9_ISSUE_APPROVAL.TYPE = 'SINGLE_ISSUE';

The query returns the issues associated to 'my-approval' and having an approval configuration specialized for single issue.

 

Please, let me know if it fixes the issue.

 

Sincerely,
Antonella

Hello Antonella,

Late reply again.

Given your explanation I guess my error showed up because instead of deleting the mapping first, I deleted the project before I went and deleted the approval. A record must have dangled due to that and promptly shown the error.

We don't use the single issue approval definition feature but extra logging when things aren't right is always a plus.

Thanks again for the prompt reply.

Daniel

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published yesterday in Jira

Mission-critical battery manufacturer fulfills FAA software requirements with Commit Policy Plugin

EaglePicher Technologies is a leading manufacturer of battery systems for diverse industries like defense, aviation, space or medical. As they operate in highly regulated industries, keeping a clear ...

115 views 0 2
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you