tServiceNowInput

adelaoc — Tue, 15 May 2018 17:56:02 GMT

Hello,

Im trying to connect to a serviceNow instace to bring into my workflow some data, however Im getting this error

Notes: I already have a ODBC connection and it works in another server using the same credentials we are just trying to migrate to talend.

Workflow: tSetProxy -> tServiceNowInput -> tLogRow

Do I need to configure something else ?

Exception in component tServiceNowInput_1 (snow)
org.apache.http.conn.HttpHostConnectException: Connect to <<my instance>>:<<port>> [<<my instance>>/<<IP>>] failed: Connection timed out: connect
at org.apache.http.impl.conn.HttpClientConnectionOperator.connect(HttpClientConnectionOperator.java:138)
at org.apache.http.impl.conn.PoolingHttpClientConnectionManager.connect(PoolingHttpClientConnectionManager.java:314)
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)
[FATAL]: operations.snow_0_1.snow - tServiceNowInput_1 Connect to <<my instance>>:<<port>> [<<my instance>>/<<IP>>] failed: Connection timed out: connect
org.apache.http.conn.HttpHostConnectException: Connect to <<my instance>>:<<port>> [<<my instance>>/<<IP>>] failed: Connection timed out: connect
at org.apache.http.impl.conn.HttpClientConnectionOperator.connect(HttpClientConnectionOperator.java:138)
at org.apache.http.impl.conn.PoolingHttpClientConnectionManager.connect(PoolingHttpClientConnectionManager.java:314)
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 operations.snow_0_1.snow.tServiceNowInput_1Process(snow.java:2538)
at operations.snow_0_1.snow.tSetProxy_1Process(snow.java:396)
at operations.snow_0_1.snow.runJobInTOS(snow.java:4919)
at operations.snow_0_1.snow.main(snow.java:4745)
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:589)
at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
at org.apache.http.conn.ssl.SSLConnectionSocketFactory.connectSocket(SSLConnectionSocketFactory.java:250)
at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:82)
at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:106)
at operations.snow_0_1.snow.tServiceNowInput_1Process(snow.java:2538)
at operations.snow_0_1.snow.tSetProxy_1Process(snow.java:396)
at operations.snow_0_1.snow.runJobInTOS(snow.java:4919)
at operations.snow_0_1.snow.main(snow.java:4745)
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:589)
at org.apache.http.impl.conn.HttpClientConnectionOperator.connect(HttpClientConnectionOperator.java:118)
... 13 more
at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
at org.apache.http.conn.ssl.SSLConnectionSocketFactory.connectSocket(SSLConnectionSocketFactory.java:250)
at org.apache.http.impl.conn.HttpClientConnectionOperator.connect(HttpClientConnectionOperator.java:118)
... 13 more
[statistics] disconnected
Job snow ended at 10:35 15/05/2018. [exit code=1]

Re: tServiceNowInput

Anonymous — Tue, 22 May 2018 08:52:38 GMT

Hello,

Have you tried to modify glide.soap.request_processing_timeout parameter of ServiceNow to see if it works? By default, it equals to 60 sec.

Best regards

Sabrina

topic tServiceNowInput in Talend Studio

tServiceNowInput

Re: tServiceNowInput

Re: tServiceNowInput