Service Now Components (tServiceNowConnection)

Four Stars

Service Now Components (tServiceNowConnection)

This may be more of a how-to question - but I was wondering if anyone has any experience using the Service Now Components available in Talend Integration Services?

Moderator

Re: Service Now Components (tServiceNowConnection)

Hello,

Here is online document about:TalendHelpCenter: ServiceNow components

Do you have some problem when use tServiceNowConnection component in talend?

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Service Now Components (tServiceNowConnection)

Yes - I have read the documentation. Sounds straight forward however I have been unsuccessful making a connection. I was wondering if there are any configurations, like certificates or anything that need to be installed on the server or workstation? Thanks for you help

Four Stars

Re: Service Now Components (tServiceNowConnection)

Here is the error I get when I try a Service Now Connections? Any idea what is causing that? Seems like there may be a certificate needed?

 

Starting job zzzServiceNowDemo at 10:52 21/03/2018.

[statistics] connecting to socket on port 3680
[statistics] connected
Exception in component tServiceNowConnection_1
[FATAL] 2018-03-21 10:52:12,041: epic_data_migration.zzzservicenowdemo_0_1.zzzServiceNowDemo - tServiceNowConnection_1 sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at sun.security.ssl.Alerts.getSSLException(Unknown Source)
at sun.security.ssl.SSLSocketImpl.fatal(Unknown Source)
at sun.security.ssl.Handshaker.fatalSE(Unknown Source)
at sun.security.ssl.Handshaker.fatalSE(Unknown Source)
at sun.security.ssl.ClientHandshaker.serverCertificate(Unknown Source)
at sun.security.ssl.ClientHandshaker.processMessage(Unknown Source)
at sun.security.ssl.Handshaker.processLoop(Unknown Source)
at sun.security.ssl.Handshaker.process_record(Unknown Source)
at sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source)
at sun.security.ssl.SSLSocketImpl.performInitialHandshake(Unknown Source)
at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
at org.apache.http.conn.ssl.SSLConnectionSocketFactory.connectSocket(SSLConnectionSocketFactory.java:261)
at org.apache.http.impl.conn.HttpClientConnectionOperator.connect(HttpClientConnectionOperator.java:118)
at org.apache.http.impl.conn.PoolingHttpClientConnectionManager.connect(PoolingHttpClientConnectionManager.java:314)
[statistics] disconnected
at org.apache.http.impl.execchain.MainClientExec.establishRoute(MainClientExec.java:357)
at org.apache.http.impl.execchain.MainClientExec.execute(MainClientExec.java:218)
at org.apache.http.impl.execchain.ProtocolExec.execute(ProtocolExec.java:194)
at org.apache.http.impl.execchain.RetryExec.execute(RetryExec.java:85)
at org.apache.http.impl.execchain.RedirectExec.execute(RedirectExec.java:108)
at org.apache.http.impl.client.InternalHttpClient.doExecute(InternalHttpClient.java:186)
at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:82)
at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:106)
at epic_data_migration.zzzservicenowdemo_0_1.zzzServiceNowDemo.tServiceNowConnection_1Process(zzzServiceNowDemo.java:731)
at epic_data_migration.zzzservicenowdemo_0_1.zzzServiceNowDemo.runJobInTOS(zzzServiceNowDemo.java:5103)
at epic_data_migration.zzzservicenowdemo_0_1.zzzServiceNowDemo.main(zzzServiceNowDemo.java:4846)
Caused by: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at sun.security.validator.PKIXValidator.doBuild(Unknown Source)
at sun.security.validator.PKIXValidator.engineValidate(Unknown Source)
at sun.security.validator.Validator.validate(Unknown Source)
at sun.security.ssl.X509TrustManagerImpl.validate(Unknown Source)
at sun.security.ssl.X509TrustManagerImpl.checkTrusted(Unknown Source)
at sun.security.ssl.X509TrustManagerImpl.checkServerTrusted(Unknown Source)
... 22 more
Caused by: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at sun.security.provider.certpath.SunCertPathBuilder.build(Unknown Source)
at sun.security.provider.certpath.SunCertPathBuilder.engineBuild(Unknown Source)
at java.security.cert.CertPathBuilder.build(Unknown Source)
... 28 more
Job zzzServiceNowDemo ended at 10:52 21/03/2018. [exit code=1]

Moderator

Re: Service Now Components (tServiceNowConnection)

Hello,

It indicates that your Service Now instance requires certification.

Usually, we use tSetKeystore component to load the cert before you connect to Service Now instance using tServiceNowConnection.

Best regards

Sabrina

 

 
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.