OCI Stack Monitoring Service - Microsoft SQL Server Resource Discovery Fails - Error while executing query. Invalid object name 'sys.dm_os_host_info'
(Doc ID 2989833.1)
Last updated on NOVEMBER 28, 2023
Applies to:
OCI Stack Monitoring - Version N/A and laterInformation in this document applies to any platform.
Symptoms
Trying to perform a Resource Discovery of Microsoft SQL Server 2016 fails.
Following error is reported in the Output Log:
ERROR [sql_server] Discovery failure: ExecutionException: FetchletException: Error while executing query. Invalid object name 'sys.dm_os_host_info'. due to FetchletException: Error while executing query. Invalid object name 'sys.dm_os_host_info'.;
ERROR [sql_server] Discovery failure: ExecutionException: FetchletException: Error while executing query. Invalid object name 'sys.dm_os_host_info'. due to FetchletException: Error while executing query. Invalid object name 'sys.dm_os_host_info'.;
ERROR Discovery failed for sql_server; work item, wi-51809217-10c7-4d9f-a174-fd55d0005265; ExecutionException: FetchletException: Error while executing query. Invalid object name 'sys.dm_os_host_info'. due to FetchletException: Error while executing query. Invalid object name 'sys.dm_os_host_info'.
ERROR [sql_server] Discovery failure: ExecutionException: FetchletException: Error while executing query. Invalid object name 'sys.dm_os_host_info'. due to FetchletException: Error while executing query. Invalid object name 'sys.dm_os_host_info'.;
ERROR Discovery failed for sql_server; work item, wi-51809217-10c7-4d9f-a174-fd55d0005265; ExecutionException: FetchletException: Error while executing query. Invalid object name 'sys.dm_os_host_info'. due to FetchletException: Error while executing query. Invalid object name 'sys.dm_os_host_info'.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |