Problem connecting to Salesforce (connection timeout)

[_AnonymousUser]

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.

[Anonymous]

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

[Anonymous]

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?

[TRF]

This is a new topic

[Anonymous]

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