SnapCenter Plug-in for MS SQL Server does not recognize disks for a specific host
Applies to
- SnapCenter Plug-in for Microsoft SQL Server 4.3, 4.4
- Microsoft HyperV
- Microsoft Windows Server 2019
- Microsoft SQL 2017
Issue
- SnapCenter does not recognize disks for a specific host
- In the SCWDebug.log we can see a problem with WMI repository:
2020-12-03T10:47:13.5432222+02:00 Verbose SDW PID=[13876] TID=[16680] query: select * from MSFT_Disk
2020-12-03T10:47:13.5432222+02:00 Verbose SDW PID=[13876] TID=[16680] scope: \\SQL\root\Microsoft\Windows\Storage
2020-12-03T10:47:13.5588456+02:00 Verbose SDW PID=[13876] TID=[9844] query: select * from MSFT_Partition
2020-12-03T10:47:13.5588456+02:00 Verbose SDW PID=[13876] TID=[9844] scope: \\SQL\root\Microsoft\Windows\Storage
2020-12-03T10:47:13.5744648+02:00 Error SDW PID=[13876] TID=[16680] Error: Failed to get disks
2020-12-03T10:47:13.5744648+02:00 Verbose SDW PID=[13876] TID=[16680] GetDisks caught exception 'Error: Failed to get disks', retry '2'...
2020-12-03T10:47:13.5901385+02:00 Verbose SDW PID=[13876] TID=[15832] query: select * from MSFT_Volume Where FileSystem = 'NTFS'
2020-12-03T10:47:13.5901385+02:00 Verbose SDW PID=[13876] TID=[15832] scope: \\SQL\root\Microsoft\Windows\Storage
2020-12-03T10:47:13.5901385+02:00 Error SDW PID=[13876] TID=[9844] Error: Failed to get partitions
2020-12-03T10:47:13.5901385+02:00 Verbose SDW PID=[13876] TID=[9844] GetPartitions caught exception 'Error: Failed to get partitions', retry '2'...
2020-12-03T10:47:13.6525957+02:00 Error SDW PID=[13876] TID=[15832] Error: Failed to get Windows volumes
2020-12-03T10:47:13.6525957+02:00 Verbose SDW PID=[13876] TID=[15832] GetWindowsVolumes caught exception 'Error: Failed to get Windows volumes', retry '2'...