My Oracle Support Banner

Problem - MSSQL Discovery fails with WMI error 0x800706ba (Doc ID 1606927.1)

Last updated on OCTOBER 01, 2018

Applies to:

Enterprise Manager for Miscellaneous Plug-ins - Version 12.1.0.3.0 and later
Information in this document applies to any platform.

Symptoms

Reported with the following configuration:

EM Version: 12.1.0.3
MSSQL Plugin version: 12.1.0.3
Agent OS: windows server 2008 R2 64-bit
MSSQL Version: 2008 R2 (SP2)
Remote monitoring
SQL based Authentication
Clustered target

After successful discovery of the target where the test-connection worked fine the following metric collection error occurs:

"Target {microsoft_sqlserver_database.clbilbaoz02_STBF} is broken: Dynamic Category property error,Get dynamic property error - No rows returned for dynamic property [exists_instance] target [microsoft_sqlserver_database.clbilbaoz02_STBF$36]"


When doing a test connection again after that it fails with the following error:

_WinAuthDLLToLoadDynamicProp;Can't resolve a non-optional query descriptor property [url] (url)

gcagent.log shows the following error:

2013-11-18 09:48:24,173 [338036:EA526B61] DEBUG - OSChannel: [C:\oracle\product\agent12c\core\12.1.0.3.0\perl\bin/perl C:\oracle\product\agent12c\plugins\oracle.em.smss.agent.plugin_12.1.0.3.0\scripts/emx/microsoft_sqlserver_database/regvalues.pl jdbcurl=jdbc:sqlserver://mssql-host:1433 "wbem_remote=1"   metricname=Dynamic "servername_from_jdbc=CLBILBAOZ02\STBF" namespace=root\\default class="StdRegProv" "metricResultDelimiter=|"] STDIN={WBEM_USERNAME=oem_plugin
SYSUSERNAME=oem_plugin_user
USERNAME=snb_dbms_oem
PASSWORD=***
}
2013-11-18 09:48:24,407 [338036:EA526B61] DEBUG - Execution error:
oracle.sysman.emSDK.agent.fetchlet.exception.FetchletException: em_error=em_error=Could not connect. Error code = 0x800706ba

at oracle.sysman.gcagent.addon.fetchlet.osfetchlet.BaseOSFetchlet.getOSMetric(BaseOSFetchlet.java:1055)
at oracle.sysman.gcagent.addon.fetchlet.osfetchlet.BaseOSFetchlet.getMetric(BaseOSFetchlet.java:439)
at oracle.sysman.gcagent.target.interaction.execution.FetchletFactory.getMetric(FetchletFactory.java:425)
[...]
2013-11-18 09:48:24,407 [338036:EA526B61] DEBUG - Computing of dynamic property: [exists_instance] is done (234 msec, error=true)
2013-11-18 09:48:24,407 [338036:BAD7D33:GC.DPExecutor2.3867] DEBUG - End task CDProps:microsoft_sqlserver_database.clbilbaoz02_STBF:exists_instance
2013-11-18 09:48:24,407 [338015:F1FBA5B0] DEBUG - Error during dynamic property exists_instance calculation: critical=false, missingCatProps=[exists], missingProps=[exists]
oracle.sysman.gcagent.metadata.MetadataExecutionException: No rows returned for dynamic property [exists_instance] target [microsoft_sqlserver_database.clbilbaoz02_STBF$19]
at oracle.sysman.gcagent.metadata.impl.DynamicProperties.computeProperties(DynamicProperties.java:269)
at oracle.sysman.gcagent.metadata.impl.TargetInstanceImpl$CalcDynamicPropsAction.call(TargetInstanceImpl.java:3375)
[...]
2013-11-18 09:48:24,407 [338039:ECA8DB71:GC.OnDemand.21] DEBUG - threadStarted : 338039 using slot index 0
2013-11-18 09:48:24,407 [338039:ECA8DB71] DEBUG - Begin task Real-Time Metric Request;microsoft_sqlserver_database.clbilbaoz02_STBF;Response on Thread: GC.OnDemand.21
2013-11-18 09:48:24,407 [338039:109AE33E:GC.OnDemand.21 (Real-Time Metric Request;microsoft_sqlserver_database.clbilbaoz02_STBF;Response)] DEBUG - Diag handle exception (non-critical)
java.lang.Exception: oracle.sysman.gcagent.target.interaction.execution.ExecuteTask$NoSuchItemException: targetId: microsoft_sqlserver_database.clbilbaoz02_STBF; itemId: Response
at oracle.sysman.gcagent.tmmain.diag.DiagManager.handleException(DiagManager.java:856)
at oracle.sysman.gcagent.tmmain.diag.DiagManager.handleException(DiagManager.java:677)
[...]
at oracle.sysman.gcagent.task.executor.TrackThreadFactory$1.run(TrackThreadFactory.java:54)
at oracle.sysman.gcagent.util.system.GCAThread$RunnableWrapper.run(GCAThread.java:184)
at java.lang.Thread.run(Thread.java:662)
Caused by: oracle.sysman.gcagent.target.interaction.execution.ExecuteTask$NoSuchItemException: targetId: microsoft_sqlserver_database.clbilbaoz02_STBF; itemId: Response
[...] 

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.