Problem connecting to Salesforce (connection timeout)

One Star

Problem connecting to Salesforce (connection timeout)

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.
Moderator

Re: Problem connecting to Salesforce (connection timeout)

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: Problem connecting to Salesforce (connection timeout)

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?

Forteen Stars TRF
Forteen Stars

Re: Problem connecting to Salesforce (connection timeout)

This is a new topic

TRF
Moderator

Re: Problem connecting to Salesforce (connection timeout)

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

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