Salesforce Proxy Issues

One Star

Salesforce Proxy Issues

Am able to create schemas from SFDC all day in Talend, no issues whatsoever.  When I try to use any of them in a job, they fail with "The host did not accept the connection within timeout of..."  VERY FRUSTRATING.  This should be simple, but it appears to not be using the proxy settings inside a job.  How the heck to fix this.  Would love to use Talend, but this is a huge setback.

                                                
One Star

Re: Salesforce Proxy Issues

BTW, I'm using (or trying to use) Talend 6.1.1 on Windows 7.
One Star

Re: Salesforce Proxy Issues

connecting to socket on port 3544
connected

Exception in component tSalesforceInput_1

org.apache.axis2.AxisFault: The host did not accept the connection within timeout of 10000 ms

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.login(SforceServiceStub.java:17180)

at org.talend.salesforce.SforceBasicConnection.renewSession(SforceBasicConnection.java:77)

at org.talend.salesforce.SforceBasicConnection.init(SforceBasicConnection.java:71)

at org.talend.salesforce.SforceBasicConnection.<init>(SforceBasicConnection.java:49)

at org.talend.salesforce.SforceBasicConnection.<init>(SforceBasicConnection.java:25)

at org.talend.salesforce.SforceBasicConnection$Builder.build(SforceBasicConnection.java:125)

at salesforcetest.salesforcetest1_0_1.SalesforceTest1.tSalesforceInput_1Process(SalesforceTest1.java:2465)

at salesforcetest.salesforcetest1_0_1.SalesforceTest1.runJobInTOS(SalesforceTest1.java:5911)

at salesforcetest.salesforcetest1_0_1.SalesforceTest1.main(SalesforceTest1.java:5768)

Caused by: org.apache.commons.httpclient.ConnectTimeoutException: The host did not accept the connection within timeout of 10000 ms

at org.apache.commons.httpclient.protocol.ReflectionSocketFactory.createSocket(ReflectionSocketFactory.java:155)

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)

... 16 more

Caused by: java.net.SocketTimeoutException: connect timed out

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)

... 24 more


disconnected

Job SalesforceTest1 ended at 11:15 04/04/2016.
One Star

Re: Salesforce Proxy Issues

OK, this is really hard to believe, but, despite having a perfectly working connection with the proxy settings in tSalesforceConnection, they are apparently ignored in a job, and will time out every time the job runs.
So, add a tSetproxy, with the EXACT SAME settings, and set its output to the tSalesforceConnection widget, and it will work.  Crazy, but true.