Unable to remove decommissioned Oracle hosts from SnapCenter
Applies to
- SnapCenter Server (SC) 6.1P1
- SnapCenter Plug-in for Oracle Databases (SCO) 6.1P1
Issue
Removing decommissioned Oracle hosts from the SnapCenter UI fails with the following errors seen:
- 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.