Problem connecting to Salesforce (connection timeout)

_AnonymousUser — Sat, 16 Nov 2024 11:00:20 GMT

Hi there,
We`ve been using Talend for a while and there were no problems with our jobs. But a day ago all jobs started to fire Connection timeout errors:
Exception in component tSalesforceInput_1
org.apache.axis2.AxisFault: Connection timed out: connect
at org.apache.axis2.AxisFault.makeFault(AxisFault.java:430)
at org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:197)
at org.apache.axis2.transport.http.HTTPSender.send(HTTPSender.java:75)
at org.apache.axis2.transport.http.CommonsHTTPTransportSender.writeMessageWithCommons(CommonsHTTPTransportSender.java:404)
at org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsHTTPTransportSender.java:231)
at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:443)
at org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:406)
at org.apache.axis2.description.OutInAxisOperationClient.executeImpl(OutInAxisOperation.java:229)
at org.apache.axis2.client.OperationClient.execute(OperationClient.java:165)
at com.salesforce.soap.partner.SforceServiceStub.query(SforceServiceStub.java:8069)
at org.talend.salesforce.SforceManagementImpl.query(SforceManagementImpl.java:920)
at project1.coolair_accountbalance_0_1.CoolAir_AccountBalance.tSalesforceInput_1Process(CoolAir_AccountBalance.java:4623)
at project1.coolair_accountbalance_0_1.CoolAir_AccountBalance.tMSSqlInput_1Process(CoolAir_AccountBalance.java:2484)
at project1.coolair_accountbalance_0_1.CoolAir_AccountBalance.tJava_1Process(CoolAir_AccountBalance.java:1314)
at project1.coolair_accountbalance_0_1.CoolAir_AccountBalance.runJobInTOS(CoolAir_AccountBalance.java:5940)
at project1.coolair_accountbalance_0_1.CoolAir_AccountBalance.main(CoolAir_AccountBalance.java:5799)
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.security.ssl.SSLSocketImpl.connect(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.commons.httpclient.protocol.ReflectionSocketFactory.createSocket(ReflectionSocketFactory.java:140)
at org.apache.commons.httpclient.protocol.SSLProtocolSocketFactory.createSocket(SSLProtocolSocketFactory.java:130)
at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:707)
at org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.open(MultiThreadedHttpConnectionManager.java:1361)
at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:387)
at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397)
at org.apache.axis2.transport.http.AbstractHTTPSender.executeMethod(AbstractHTTPSender.java:621)
at org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:193)
... 14 more
That is weird because nothing have changed in Salesforce and on our sever(where jobs are scheduled to run every 15 min.)
We are using Salesforce live environment, and from what I can see Talend can log in to Salesforce but looks like then it is waiting for query to execute or so which should not be an issue as query is small and returns just few records.
Do you have any suggestions what can be wrong here?
Thanks.

Re: Problem connecting to Salesforce (connection timeout)

Anonymous — Sat, 10 Oct 2015 04:14:29 GMT

Hi Oles,
On which official version did you get that? Did you set timeout on component tSalesforceInput? Are you connecting through a proxy?
Best regards
Sabrina

Re: Problem connecting to Salesforce (connection timeout)

Anonymous — Mon, 11 Jun 2018 16:47:24 GMT

If I'm using a proxy, Do I need to set the proxy in talend preferences or setting the proxy in Salesforce metadata advanced setting will work?

Re: Problem connecting to Salesforce (connection timeout)

TRF — Mon, 11 Jun 2018 17:05:53 GMT

This is a new topic

Re: Problem connecting to Salesforce (connection timeout)

Anonymous — Tue, 03 Jul 2018 09:18:06 GMT

Hello,

Please go to Studio settings: Studio > Window -> Preferences-> General -> Network connections and configure following JVM arguments in the .ini file of the studio and relaunched, this was helpful to launch the application

-DproxyHost=XXXX
-DproxyPort=XXXX
-Dhttp.proxySet=true
-Dhttp.nonProxyHosts=XXXX

Best regards

Sabrina

topic Re: Problem connecting to Salesforce (connection timeout) in Talend Studio

Problem connecting to Salesforce (connection timeout)

Re: Problem connecting to Salesforce (connection timeout)

Re: Problem connecting to Salesforce (connection timeout)

Re: Problem connecting to Salesforce (connection timeout)

Re: Problem connecting to Salesforce (connection timeout)