SnapCenter fails to delete policy when resource group is attached

Applies to

SnapCenter Server (SC) all versions

Issue

• Attempts to delete a policy fail with the error: “Failed – This policy has Resource Group attached. Please detach the policy from Resource Group before removing the policy”.
• May also see the following error when trying to remove the policies with the PowerShell (PS) command Remove-SmPolicy -PolicyNames -force -Confirm:$false

See the inner exception for details.
InnerException Cannot delete or update a parent row: a foreign key constraint fails
(`nsm`.`nsm_datasetverificationconfig`, CONSTRAINT `FK_nsm_DatasetVerificationConfig_nsm_Policy`
FOREIGN KEY (`nsm_Policy_Id`) REFERENCES `nsm_Policy` (`nsm_Policy_Id`) ON DELETE NO ACTION ON U)