SnapCenter discovery fails after data has been migrated to new storage
Applies to
Issue
The following entries are recorded towards the end of SnapManagerWeb.log
System.Data.Entity.Infrastructure.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. --->
System.Data.Entity.Core.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Devart.Data.MySql.MySqlException: Cannot delete or update a parent row: a foreign key constraint fails (`nsm`.`nsm_sce_databasefile`, CONSTRAINT `FK_nsm_sce_DatabaseFile_nsm_storagefilesystem` FOREIGN KEY (`nsm_storagefilesystem_id`) REFERENCES `nsm_StorageFileSystem` (`nsm_StorageFileSystem_Id`) at SnapManager.SMSCore.Discovery.DiscoveryBizHelper.DiscoverHostResourcesInternal(SmDiscoverResourcesRequest request) : Detailed Exception An error occurred while updating the entries. See the inner exception for details. An error occurred while updating the entries. See the inner exception for details. Cannot delete or update a parent row: a foreign key constraint fails (`nsm`.`nsm_sce_databasefile`, CONSTRAINT `FK_nsm_sce_DatabaseFile_nsm_storagefilesystem` FOREIGN KEY (`nsm_storagefilesystem_id`) REFERENCES `nsm_StorageFileSystem` (`nsm_StorageFileSystem_Id`) : BaseException Cannot delete or update a parent row: a foreign key constraint fails (`nsm`.`nsm_sce_databasefile`, CONSTRAINT `FK_nsm_sce_DatabaseFile_nsm_storagefilesystem` FOREIGN KEY (`nsm_storagefilesystem_id`) REFERENCES `nsm_StorageFileSystem` (`nsm_StorageFileSystem_Id`)