Highlighted
Respected Contributor.. Respected Contributor..
Respected Contributor..
298 views

uCMDB-SNOW Integration via Push Adapter

I receive below error always while pushing CIs to snow. Connection is fine. But i can insert entry in snow via SOAPUI with same wsdl link and credentials. Let me know for any idea?

 

2019-07-29 11:16:46,979 TRACE [AdHoc:AD_HOC_TASK_PATTERN_ID-1129-1564391806685] - Adding u_imp_ucmdb_server RTN to the u_imp_ucmdb_server cache. ResultTreeNode. QueryNodeName: u_imp_ucmdb_server
ExternalCiId:***{UCMDB%0Ant%0A1%0Ainternal_id%3DSTRING%3D4a33dfc5e50e7497835c27875696ff7d%0A}***
class name: nt
isCmdbId: true
cmdbId: 4a33dfc5e50e7497835c27875696ff7d
Properties:
internal_id=4a33dfc5e50e7497835c27875696ff7d
Properties:
u_name = testci
u_rwe_correlationid = 4a33dfc5e50e7497835c27875696ff7d,

2019-07-29 11:16:46,979 ERROR [AdHoc:AD_HOC_TASK_PATTERN_ID-1129-1564391806685] - Ignoring u_imp_ucmdb_server RTN tree because of invalid key. ExternalCiId:***{UCMDB%0Ant%0A1%0Ainternal_id%3DSTRING%3D4a33dfc5e50e7497835c27875696ff7d%0A}***
class name: nt
isCmdbId: true
cmdbId: 4a33dfc5e50e7497835c27875696ff7d
Properties:
internal_id=4a33dfc5e50e7497835c27875696ff7d

2019-07-29 11:16:46,979 WARN [AdHoc:AD_HOC_TASK_PATTERN_ID-1129-1564391806685] - Unable to create global CI ID for RTN. Using the original ExternalCiId: ExternalCiId:***{UCMDB%0Ant%0A1%0Ainternal_id%3DSTRING%3D4a33dfc5e50e7497835c27875696ff7d%0A}***
class name: nt
isCmdbId: true
cmdbId: 4a33dfc5e50e7497835c27875696ff7d
Properties:
internal_id=4a33dfc5e50e7497835c27875696ff7d

java.lang.NullPointerException
at com.hpe.ucmdb.adapters.util.UcmdbUtils.createGlobalExternalCiId(UcmdbUtils.java:70)
at com.hpe.ucmdb.adapters.snow.push.ServiceNowPusher.reportAdditionStatus(ServiceNowPusher.java:623)
at com.hpe.ucmdb.adapters.snow.push.ServiceNowPusher.addOrUpdateRtn(ServiceNowPusher.java:229)
at com.hpe.ucmdb.adapters.snow.push.ServiceNowPusher.pushTreeNodes(ServiceNowPusher.java:203)
at com.hp.ucmdb.adapters.snow.ServiceNowGenericAdapter.pushTreeNodes(ServiceNowGenericAdapter.java:179)
at com.hp.ucmdb.adapters.GenericAdapter.pushToRemoteDataSource(GenericAdapter.java:575)
at com.hp.ucmdb.adapters.GenericAdapter.updateData(GenericAdapter.java:408)
at com.hp.ucmdb.dataAccess.manager.DirectBasicDataAdapterWrapper.updateData(DirectBasicDataA

0 Likes
3 Replies
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: uCMDB-SNOW Integration via Push Adapter

Hi @RahulGupta ,

In the last year I have extensively worked on the ServiceNow adapter and I can give you some outline of how to debug it:

1. Make sure you are using REST and not SOAP. It is far faster. In adapter.properties set:

connector.class=com.hpe.ucmdb.adapters.snow.connector.ServiceNowRestConnector
# connector.class=com.hpe.ucmdb.adapters.snow.connector.ServiceNowSoapConnector
push.connector.class=com.hpe.ucmdb.adapters.snow.connector.ServiceNowRestConnector

 

2. Enable debugging of servicenow adapter. This will show you the REST queries sent to ServiceNow and what has been received as a response. Ammend fcmdb.properties in DataFlowProbe\conf\log with:

 

#### ServiceNow Custom Configuration

log4j.category.servicenow.generic.adapter=TRACE,servicenow.generic.adapter.appender
log4j.appender.servicenow.generic.adapter.appender=com.mercury.topaz.cmdb.shared.base.log.BetterRollingFileAppender
log4j.appender.servicenow.generic.adapter.appender.File=${logs.dir}/servicenow.generic.adapter.log
log4j.appender.servicenow.generic.adapter.appender.MaxFileSize=10240KB
log4j.appender.servicenow.generic.adapter.appender.MaxBackupIndex=${def.files.backup.count}
log4j.appender.servicenow.generic.adapter.appender.layout=org.apache.log4j.PatternLayout
log4j.appender.servicenow.generic.adapter.appender.layout.ConversionPattern=${msg.layout}

 

3. Check the import set and transform map history logs in ServiceNow. If the data is properly sent there, you will be able to see what is the reason for rejection.

 

Regards,

Petko Popadiyski

Freelance Microfocus CMS UCMDB Consulting

Likes are appreciated!
Highlighted
Respected Contributor.. Respected Contributor..
Respected Contributor..

Re: uCMDB-SNOW Integration via Push Adapter

Hello, Thanks for your reply. I have already done first and second step. I cannot perform third step, as we don't have access to snow. Moreover, data is not reaching to snow staging tables and that's confirmed.

Let me know for any suggestions please.

 

Regards,

Rahul

Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: uCMDB-SNOW Integration via Push Adapter

if you have done 1 and 2, you have logs with the requests to ServiceNow. what are the request payloads and what are the responses?

Likes are appreciated!
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.