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)