Highlighted
Honored Contributor.
Honored Contributor.
768 views

Issues in host resources and application discovery by WMI

Hi,

I have UCDMB 10.30 and DFP 10.30 installed on seperate server.

During execution of discovery jobs, ICMP discovery, host connection discovery is successfully completed.

But all the triggered CIs for discovery job "Host Resources and Applications by WMI" doest not discover any CIs even though communication to triggered CIs is successful.

Output of discovery job on triggere CI "Host Resources and Applications by WMI"

<< Progress message, Severity: Fatal>>

Error processing results, for more details please check UCMDB server log files

 Recommended log files on UCMDB: error.log, cmdb.reconciliation.log, mam.autodiscovery.log

runtime/logs( from ucmdb server):

Host Resources and Applications by WMI] - !!! Operation Tql Query: Get Ad Hoc Map (By Pattern). Pattern [Identification for [node]]() ID: 1457286263 FAILED (running time: 7 ms[ms])

com.mercury.topaz.cmdb.server.manage.dal.CmdbDalException: [ErrorCode [-2147483648] undefined error code]
SQL error executing statement SELECT cmdb_id , A_GLOBAL_ID FROM CDM_ROOT_1 WHERE cmdb_id IN ( ? )

I think issue might be with query which take cmdb_id instead of CMDB_ID, I have attached the log files for the reference

1) mam.autodiscovery.log

2016-12-16 11:20:24,747 ERROR [Process Results Thread-MZ_DISCOVER-MGMT_ Host Application by WMI_Host Applications by WMI] - Error processing results from task: MZ_DISCOVER-MGMT_ Host Application by WMI_Host Applications by WMI
appilog.framework.shared.manage.impl.MamResponseException: [ErrorCode [63000] Reconciliation DataIn general error.]
appilog.framework.shared.manage.impl.MamResponseException: [ErrorCode [63000] Reconciliation DataIn general error.]
CMDB Operation Internal Error: class appilog.framework.shared.manage.impl.MamResponseException : [ERROR CODE- 63000] appilog.common.system.exceptions.AppilogDataException: appilog.framework.shared.manage.impl.MamResponseException: [ErrorCode [63000] Reconciliation DataIn general error.]
CMDB Operation Internal Error: class com.hp.ucmdb.reconciliation.datain.exception.DataInException : appilog.framework.shared.manage.impl.MamResponseException: [ErrorCode [-2147483648] undefined error code]
appilog.framework.shared.manage.impl.MamResponseException: [ErrorCode [-2147483648] undefined error code]
CMDB Operation Internal Error: class appilog.framework.shared.manage.impl.MamResponseException : appilog.framework.shared.manage.impl.MamResponseException: [ErrorCode [-2147483648] undefined error code]
CMDB Operation Internal Error: class com.mercury.topaz.cmdb.server.manage.dal.CmdbDalException : SQL error executing statement SELECT cmdb_id , A_GLOBAL_ID FROM CDM_ROOT_1 WHERE cmdb_id IN ( ? , ? , ? , ? , ? ) : operation Tql Query: Get Ad Hoc Map (By Pattern). Pattern [Identification for [node]] : class com.mercury.topaz.cmdb.shared.base.CmdbException :
CMDB Internal Error: Error while handling request: {request: ID='40ea0c1bc30b0800bb7abdad5e4e463c' Message='General CMDB request' Operation='com.mercury.topaz.cmdb.shared.tql.operation.query.impl.TqlQueryGetAdHocMap@1841eb7a' Customer ID='1'
Context='CMDB Context: Customer id = '1' , User ID = '911' , Caller Application = 'AutoDiscovery''} : operation IdentifyVsCmdbQuery : class com.mercury.topaz.cmdb.shared.base.CmdbException :
CMDB Internal Error: Error while handling request: {request: ID='41ea92bf1b751bd6ab23100d6885412a' Message='General CMDB request' Operation='com.hp.ucmdb.reconciliation.identification.operation.IdentifyVsCmdbQuery@2b4fa633' Customer ID='1'
Context='CMDB Context: Customer id = '1' , User ID = '911' , Caller Application = 'AutoDiscovery''} : operation DataInAddOrUpdateData : class com.mercury.topaz.cmdb.shared.base.CmdbException :
CMDB Internal Error: Error while handling request: {request: ID='4dfd15f8c59c42448ee5d609f78c65a9' Message='General CMDB request' Operation='com.hp.ucmdb.reconciliation.datain.operation.DataInAddOrUpdateData : FAILED!! [ID= 528098473] [Customer ID=1] [Changer=UCMDBDiscovery: MZ_DISCOVER-MGMT_ Host Application by WMI_Host Applications by WMI Probe: UDPROBE] [total= 0.031 , datain.lock= 0.031 , datain.lock.identification= 0.031 , identification.query= 0.015 ] [durations: identify= 0.000 dataIn= 0.000] [Ignore From Cmdb- 0 Ignore From Bulk- 0 Merge Operations- 0 Merged CIs- 0 Type Changes- 0 Max Topology Level- 0] [Datas to update- 170] [Referenced Data- 0] addOrUpdate : [Objects For Update- node(10) process(42) adam(1) sqlserver(5) postgresql(1) tomcat(1) jbossas(1) ip_address(5) running_software(3)] [Links For Update- containment(5) composition(54) dependency(42)] [Referenced Objects-] [Referenced Links-] Message: ion.IdentifyVsCmdbQuery@2b4fa633' Customer ID='1' Context='CMDB Context: Customer id = '1' , User ID = '911' , Caller Application = 'AutoDiscovery''}' Customer ID='1'
Context='CMDB Context: Customer id = '1' , User ID = '911' , Caller Application = 'AutoDiscovery''} : operation com.hp.ucmdb.discovery.framework.world.operation.update.impl.WorldOperationCreateOrUpdateObjectBulk : class com.mercury.topaz.cmdb.shared.base.CmdbException :
CMDB Internal Error: Error while handling request: {request: ID='4f9c92db3a874144b5a406616ed2ba61' Message='General CMDB request' Operation='com.hp.ucmdb.discovery.framework.world.operation.update.impl.WorldOperationCreateOrUpdateObjectBulk@3af47596' Customer ID='1'
Context='CMDB Context: Customer id = '1' , User ID = '911' , Caller Application = 'AutoDiscovery''}

 

2) cmdb.reconciliation.log

2016-12-16 10:15:43,969 ERROR [qtp1691036685-12610] - !!!FAILED!!![Operation #1622744185 Name=DataInAddOrUpdateData]
appilog.framework.shared.manage.impl.MamResponseException: [ErrorCode [-2147483648] undefined error code]
appilog.framework.shared.manage.impl.MamResponseException: [ErrorCode [-2147483648] undefined error code]
CMDB Operation Internal Error: class appilog.framework.shared.manage.impl.MamResponseException : appilog.framework.shared.manage.impl.MamResponseException: [ErrorCode [-2147483648] undefined error code]
CMDB Operation Internal Error: class com.mercury.topaz.cmdb.server.manage.dal.CmdbDalException : SQL error executing statement SELECT cmdb_id , A_GLOBAL_ID FROM CDM_ROOT_1 WHERE cmdb_id IN ( ? , ? ) : operation Tql Query: Get Ad Hoc Map (By Pattern). Pattern [Identification for [ip_address]] : class com.mercury.topaz.cmdb.shared.base.CmdbException :
CMDB Internal Error: Error while handling request: {request: ID='406d45f0b4a9a77caa3a570d1b088f6c' Message='General CMDB request' Operation='com.mercury.topaz.cmdb.shared.tql.operation.query.impl.TqlQueryGetAdHocMap@f371783' Customer ID='1, id name: Default Client'
Context='CMDB Context: Customer id = '1, id name: Default Client' , User ID = '911' , Caller Application = 'UCMDB-UI,loggedInUser:{admin}''} : operation IdentifyVsCmdbQuery : class com.mercury.topaz.cmdb.shared.base.CmdbException :
CMDB Internal Error: Error while handling request: {request: ID='46f5f17fa40075bdbd019e3444cce52d' Message='General CMDB request' Operation='com.hp.ucmdb.reconciliation.identification.operation.IdentifyVsCmdbQuery@5fc8969e' Customer ID='1, id name: Default Client'
Context='CMDB Context: Customer id = '1, id name: Default Client' , User ID = '911' , Caller Application = 'UCMDB-UI,loggedInUser:{admin}''}

 

2016-12-16 11:20:25,341 ERROR [Process Results Thread-MZ_DISCOVER-MGMT_Host Application by WMI_Host Applications by WMI] - !!!FAILED!!![Operation #838139435 Name=DataInAddOrUpdateData]
appilog.framework.shared.manage.impl.MamResponseException: [ErrorCode [-2147483648] undefined error code]
appilog.framework.shared.manage.impl.MamResponseException: [ErrorCode [-2147483648] undefined error code]
CMDB Operation Internal Error: class appilog.framework.shared.manage.impl.MamResponseException : appilog.framework.shared.manage.impl.MamResponseException: [ErrorCode [-2147483648] undefined error code]
CMDB Operation Internal Error: class com.mercury.topaz.cmdb.server.manage.dal.CmdbDalException : SQL error executing statement SELECT cmdb_id , A_GLOBAL_ID FROM CDM_ROOT_1 WHERE cmdb_id IN ( ? ) : operation Tql Query: Get Ad Hoc Map (By Pattern). Pattern [Identification for [node]] : class com.mercury.topaz.cmdb.shared.base.CmdbException :
CMDB Internal Error: Error while handling request: {request: ID='4fb964cadc5ea869a068c930426b3f64' Message='General CMDB request' Operation='com.mercury.topaz.cmdb.shared.tql.operation.query.impl.TqlQueryGetAdHocMap@3eb1835d' Customer ID='1'
Context='CMDB Context: Customer id = '1' , User ID = '911' , Caller Application = 'AutoDiscovery''} : operation IdentifyVsCmdbQuery : class com.mercury.topaz.cmdb.shared.base.CmdbException :
CMDB Internal Error: Error while handling request: {request: ID='49b21c8accaa9288915f6a053f6604f6' Message='General CMDB request' Operation='com.hp.ucmdb.reconciliation.identification.operation.IdentifyVsCmdbQuery@677d0c5f' Customer ID='1'
Context='CMDB Context: Customer id = '1' , User ID = '911' , Caller Application = 'AutoDiscovery''}

 

 

Please suggest possible solution for the above issue.

 

Thanks 

Rohit 

 

0 Likes
1 Reply
Highlighted
Honored Contributor.
Honored Contributor.

Re: Issues in host resources and application discovery by WMI

In the attached screenshot, error can be seen. 

Not sure why there is an issue in reconciliation process even the communication logs shows that probe is successfully able to fetch the information but then it is getting stuck at sending the resulting vector back UCDMB to put the same into database it fails to insert/update for existing Node, IPaddress CIs for instance because while it is searching for cmdb_id (though actual attribute is CMDB_ID) in CDM_ROOT_1 table. Please check my above post for exact error message.

Have anyone faced similar issue in UCMDB 10.30 ? How to resolve this issue ?

 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.