Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Hello,
Here is online document about:TalendHelpCenter: ServiceNow components
Do you have some problem when use tServiceNowConnection component in talend?
Best regards
Sabrina
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
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]
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
Hi,
I am getting below error while connecting via Talend. But when I am tring using Browser, it is working fine. Auto login is there in browser.
Please let me know your comments.
For us, we got the cert from our service now web site. Then we stored it in a share folder and point the talend component to it. To see the cert, left click on the little lock or info icon on the left (in chrome) next to the url in your browser. You can then export it.