1 つ以上のホストで SQL データベースが検出されませんでした
環境
- SnapCenter サーバ（ SC ） 4.4
- データベース検出
問題
- SQL データベースが 1 つ以上のホストで検出されませんでした
- ディスクが見つかりました
- SC GUI にエラーは表示されませんが、以下を参照してください のエントリ
<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)