Highlighted
Absent Member.
Absent Member.
1353 views

datain general error UCMDB 10.20

Hello All,

 

Kindly help me to advice the cause for this error (datain general error) this error generated while creating any CI on the Database.

 

anyone one can help please 

0 Likes
3 Replies
Highlighted
Honored Contributor.. Honored Contributor..
Honored Contributor..

Re: datain general error UCMDB 10.20

Can you provide more detail like is the error happening while creating CIs with discovery or integration or manual?

 

It's also helpful if you can attach snippets of logs like the error.log, cmdb.reconciliation.audit.log, cmdb.dal, cmdb.reconciliation.datain.ignored, cmdb.reconciliation.datain.merged  when this data-in error occurs.

I suggest using a tool like Baretail.

 

The Data In service creates or merges CIs that have gone through the identification service after discovery or an integration like a population. The Data In service also decides what to do with CIs with identifying attributes or relationships that matches multiple CIs by using match criterea set in the reconciliation rule for that CI Type

Rey Lejano

effectualsystems.com
0 Likes
Highlighted
Established Member..
Established Member..

Re: datain general error UCMDB 10.20

Hi Rey.

We are also experiencing this error. With us it happens when we run the integration between RTSM and the CMDB. RTSM version 9.25, CMDB 10.21

cmdb.reconciliation.datain.error log extract:

2015-11-20 07:59:29,474 ERROR [Process Results Thread-DS_CMS Prod to BSM Prod_RTSM to CMS Population job] - !!!FAILED!!![Operation #1487178320 Name=DataInAddOrUpdateData]
com.hp.ucmdb.reconciliation.datain.operation.DataInOperationException: [ErrorCode [63000] Reconciliation DataIn general error.]
Error while trying to [addOrUpdate] on level [1]! appilog.framework.shared.manage.impl.MamResponseException: [ErrorCode [-2147483648] undefined error code]
CMDB Operation Internal Error: class java.lang.RuntimeException : Failed to calculate attribute attribute: name [display_label] type [string] isFactory [true] isUserUpdated [false] size limit [900] within class [router] : operation Model Update: Update model with bulk of operations in mixed OPTIMISTIC/STRICT mode : class com.mercury.topaz.cmdb.shared.base.CmdbException :
CMDB Internal Error: Error while handling request: {request: ID='4e9fc2737ec13aacd9fbc6b8a831b4be' Message='General CMDB request' Operation='com.mercury.topaz.cmdb.shared.model.operation.update.impl.bulk.ModelUpdateBulksMixed@48fc067f' Customer ID='1'
Context='CMDB Context: Customer id = '1' , User ID = '911' , Caller Application = 'AutoDiscovery''}
at com.hp.ucmdb.reconciliation.datain.operation.AbstractDataInUpdateOperation.handleBulk(AbstractDataInUpdateOperation.java:699)

 

cmdb.dal extract:

2015-11-20 07:59:00,660 INFO [Process Results Thread-DS_CMS Prod to BSM Prod_RTSM to CMS Population job] - 16ms 717048404 2027800740 2130060918 626079799 21503548 1568501323 372257918 1534341164 SELECT NODE_1.CMDB_ID FROM NODE_1 NODE_1 WHERE 1=1 AND (lower(NODE_1.A_SNMP_SYS_NAME) IN (lower(?))) ; Values: 'nltd-0143-ellisras-ce-1.yourdo<...(38)>'
2015-11-20 07:59:00,676 INFO [Process Results Thread-DS_CMS Prod to BSM Prod_RTSM to CMS Population job] - 16ms 717048404 2027800740 2130060918 626079799 21503548 1568501323 372257918 1218675959 SELECT NODE_1.CMDB_ID FROM NODE_1 NODE_1 WHERE 1=1 AND (NODE_1.A_PRIMARY_DNS_NAME IN (?)) ; Values: '10.21.25.1'
2015-11-20 07:59:00,691 INFO [Process Results Thread-DS_CMS Prod to BSM Prod_RTSM to CMS Population job] - 0ms 717048404 2027800740 2130060918 626079799 21503548 1568501323 1539778065 1533510348 SELECT INTERFACE_1.CMDB_ID FROM INTERFACE_1 INTERFACE_1 WHERE 1=1 AND (INTERFACE_1.A_MAC_ADDRESS IN (?, ?, ?)) ; Values: '30F70D249123','30F70D249120','30F70D249121'
2015-11-20 07:59:00,707 INFO [Process Results Thread-DS_CMS Prod to BSM Prod_RTSM to CMS Population job] - 0ms 717048404 2027800740 2130060918 626079799 21503548 1568501323 1156085867 300434752 SELECT CDM_ROOT_1.CMDB_ID FROM CDM_ROOT_1 CDM_ROOT_1 WHERE 1=1 AND CDM_ROOT_1.A_ROOT_CLASS IN (SELECT CLASS_NAME FROM CLASS_MODEL_ENCODING WHERE PATH LIKE ((SELECT PATH FROM CLASS_MODEL_ENCODING WHERE CLASS_NAME=? AND CUSTOMER_ID=?) + '%') AND CUSTOMER_ID=?) AND (CDM_ROOT_1.A_GLOBAL_ID IN (?)) ; Values: 'root',1,1,'96a93eb487447f2dccc9f41a9e86d5<...(32)>'
2015-11-20 07:59:00,722 INFO [Process Results Thread-DS_CMS Prod to BSM Prod_RTSM to CMS Population job] - 0ms 717048404 2027800740 2130060918 626079799 21503548 1568501323 1507470202 1668721707 SELECT IP_ADDRESS_1.CMDB_ID FROM IP_ADDRESS_1 IP_ADDRESS_1 WHERE 1=1 AND (IP_ADDRESS_1.A_NAME IN (?, ?, ?) AND IP_ADDRESS_1.A_ROUTING_DOMAIN IN (?) AND IP_ADDRESS_1.A_IP_LEASE_TIME IN (?)) ; Values: '10.21.25.1','165.144.50.54','165.144.119.87','DefaultDomain',0

0 Likes
Highlighted
Honored Contributor.. Honored Contributor..
Honored Contributor..

Re: datain general error UCMDB 10.20

At first I thought it was a fuse issue, I was going to ask how many CIs is the output of the integration TQL used for the RTSM/UCMDB integration and suggest trying a TQL that outputs a very small amount of CIs

But I remembered that there are differences with the class models between UCMDB and RTSM since RTSM is usually on an older class model

Align the class models between the two, we upgrade RTSM's class model to UCMDB's

 

Rey Lejano

effectualsystems.com
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.