SQL databases are not discovered on one or more host
Applies to
- SnapCenter Server (SC) 4.4
- Database discovery
Issue
- SQL databases are not discovered one one or more host
- Disks are found successfully
- No error seen in SC GUI but see the following entries in
<installation_path>\NetApp\SnapCenter\App_Data\log\SnapManagerWeb_<id>.logDEBUG SnapManagerWeb_1301160 PID=[2996] TID=[1] PluginCode: SMSQL
DEBUG SnapManagerWeb_1301160 PID=[2996] TID=[1] ShouldDeletesmObject enter for nsmObject: <SQL_Instance\database>
DEBUG SnapManagerWeb_1301160 PID=[2996] TID=[1] isObject Deleted: True BackupExists: False
DEBUG SnapManagerWeb_1301160 PID=[2996] TID=[1] Perform RemoveSQLResource
DEBUG SnapManagerWeb_1301160 PID=[2996] TID=[1] Found the SQL Database (<SQL_Instance\database>) registered with host (<hostname>).
DEBUG SnapManagerWeb_1301160 PID=[2996] TID=[1] Perform RemoveSmObjectFromDiscovery
DEBUG SnapManagerWeb_1301160 PID=[2996] TID=[1] Perform RemoveSmObjectFromCredentialMapping
DEBUG SnapManagerWeb_1301160 PID=[2996] TID=[1] Perform Object (SQL_Instance\database) cleanup
ERROR SnapManagerWeb_1301160 PID=[2996] TID=[1] Failed to remove the resource with id (object_id). Error: 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_backupvolumesharing`, CONSTRAINT `FK_nsm_BackupVolumeSharing_nsm_sm_object` FOREIGN KEY (`nsm_sm_object_id`) REFERENCES `nsm_sm_object` (`nsm_sm_object_id`) ON DELETE NO ACTION ON U)