SC Server - Unable to delete hosts - Foreign Key Constraint error
Applies to
SnapCenter (All Versions)
Issue
A host cannot be deleted due to toe error listed below.
2021-07-19T15:04:20.0648348+00:00 DEBUG SnapManagerWeb_9241 PID=[3756] TID=[28] Failed to remove file system resource. Details: Cannot delete or update a parent row: a foreign key constraint fails (`nsm`.`nsm_smsql_databasefile`, CONSTRAINT `FK_nsm_smsql_DatabaseFile_nsm_StorageFootprint` FOREIGN KEY (`nsm_StorageFootPrint_id`) REFERENCES `nsm_StorageFootprint` (`nsm_StorageFootprint_id`)
2021-07-19T15:04:20.0648348+00:00 DEBUG SnapManagerWeb_9241 PID=[3756] TID=[28] RemoveSCWResource - exit
2021-07-19T15:04:20.0648348+00:00 DEBUG SnapManagerWeb_9241 PID=[3756] TID=[28] Catch an exception in RemoveSCWResource: Cannot delete or update a parent row: a foreign key constraint fails (`nsm`.`nsm_smsql_databasefile`, CONSTRAINT `FK_nsm_smsql_DatabaseFile_nsm_StorageFootprint` FOREIGN KEY (`nsm_StorageFootPrint_id`) REFERENCES `nsm_StorageFootprint` (`nsm_StorageFootprint_id`)