SnapCenter fails to delete policy when resource group is attached
- Views:
- 589
- Visibility:
- Public
- Votes:
- 1
- Category:
- snapcenter
- Specialty:
- snapx
- Last Updated:
- 4/8/2022, 8:34:20 AM
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)