无法从 SnapCenter 中删除已停用的 Oracle 主机
适用于
- SnapCenter 服务器 (SC) 6.1P1
- 适用于 Oracle 数据库的 SnapCenter 插件 (SCO) 6.1P1
问题
从 SnapCenter UI 中删除已停用的 Oracle 主机失败,并显示以下错误:
- SnapCenter UI

- SnapManagerWeb_<JobID_Date_Time>.log
DEBUG SnapManagerWeb_<JobID> PID=[xxxx] TID=[xxxx] A root ambient transaction was completed before the nested transaction. The nested transactions should be completed first.DEBUG SnapManagerWeb_<JobID> PID=[xxxx] TID=[xxxx] DeleteBackup failed with error: A root ambient transaction was completed before the nested transaction. The nested transactions should be completed first.ERROR SnapManagerWeb_<JobID> PID=[xxxx] TID=[xxxx] System.InvalidOperationException: A root ambient transaction was completed before the nested transaction. The nested transactions should be completed first.DEBUG SnapManagerWeb_<JobID> PID=[xxxx] TID=[xxxx] Backup Deletion Failed: A root ambient transaction was completed before the nested transaction. The nested transactions should be completed first.ERROR SnapManagerWeb_<JobID> PID=[xxxx] TID=[xxxx] ErrorCode (-1), ErrorMessage (A root ambient transaction was completed before the nested transaction. The nested transactions should be completed first.)DEBUG SnapManagerWeb_<JobID> PID=[xxxx] TID=[xxxx] Delete host ProtectionGroups failed. An error occurred while saving the entity changes. See the inner exception for details.ERROR SnapManagerWeb_<JobID> PID=[xxxx] TID=[xxxx] Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details. ---> MySqlConnector.MySqlException (0x80004005): Cannot delete or update a parent row: a foreign key constraint fails (`nsm`.`nsm_datasetcredentialmapping`, CONSTRAINT `FK_nsm_DatasetCredentialMapping_nsm_protection_group` FOREIGN KEY (`DatasetId`) REFERENCES `nsm_protection_group` (`nsm_protection_group_id`))ERROR SnapManagerWeb_<JobID> PID=[xxxx] TID=[xxxx] Cannot remove the host related objects from the database. This issue might occur if you try to delete multiple hosts at the same time. You must delete one host at a time.