Hi,
Hopefully someone might be able to help me with this issue. I am uploading data to SalesForce. I can successfully upload data using the tSalesforceOutput component (screenshot 1). This takes the data from a csv file and inserts it into the Salesforce Account object.
However when I try and use the tSalesForceBulkExec component (screenshot 2) I receive the following error:
Exception in component tSalesforceBulkExec_1
com.sforce.ws.ConnectionException: Failed to send request to
https://test.salesforce.com/services/Soap/u/22.0 at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:113)
at com.sforce.soap.partner.PartnerConnection.login(PartnerConnection.java:1)
at com.sforce.soap.partner.PartnerConnection.<init>(PartnerConnection.java:1)
at org.talend.salesforceBulk.SalesforceBulkAPI.getRestConnection(SalesforceBulkAPI.java:161)
at org.talend.salesforceBulk.SalesforceBulkAPI.login(SalesforceBulkAPI.java:93)
at td_to_sfdc.test_0_1.Test.tSalesforceBulkExec_1Process(Test.java:828)
at td_to_sfdc.test_0_1.Test.tSetProxy_1Process(Test.java:765)
at td_to_sfdc.test_0_1.Test.runJobInTOS(Test.java:3686)
at td_to_sfdc.test_0_1.Test.main(Test.java:3397)
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.DualStackPlainSocketImpl.connect0(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.security.ssl.BaseSSLSocketImpl.connect(Unknown Source)
at sun.net.NetworkClient.doConnect(Unknown Source)
at sun.net.
www.http.HttpClient.openServer(Unknown Source)
at sun.net.
www.http.HttpClient.openServer(Unknown Source)
at sun.net.
www.protocol.https.HttpsClient.<init>(Unknown Source)
at sun.net.
www.protocol.https.HttpsClient.New(Unknown Source)
at sun.net.
www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(Unknown Source)
at sun.net.
www.protocol.http.HttpURLConnection.plainConnect(Unknown Source)
at sun.net.
www.protocol.https.AbstractDelegateHttpsURLConnection.connect(Unknown Source)
at sun.net.
www.protocol.http.HttpURLConnection.getOutputStream(Unknown Source)
at sun.net.
www.protocol.https.HttpsURLConnectionImpl.getOutputStream(Unknown Source)
at com.sforce.ws.transport.JdkHttpTransport.connectLocal(JdkHttpTransport.java:97)
at com.sforce.ws.transport.JdkHttpTransport.connect(JdkHttpTransport.java:82)
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:99)
... 8 more
It should be noted that I am connecting through a proxy. In both scenerios I set the HTTP proxy first using the tSetProxy component. I can use all the SalesForce components fine except for the bulk components (I have tried the tSalesForceBulkExec component and the tSalesForceOutputBulkExec components and received the same error for both).
Does anyone know what is causing this? I can't see how it would be a problem with the proxy server (given that I can successfully connect and upload using tSalesforceOutput). I can't see how it could be a credentials issue either (given that I use the same credentials for tSalesforceOutput). Any help would be much appreciated.
Thanks a lot,
Ian
Same problem. With the tSalesforceOutputComponent, it works fine. With the ?bulk? components (either tSalesforceOutputBulkExec alone or tSalesforceOutputBulk with tSalesforceBulkExec), I got exactly the same exception. I tried with TOS 4.1.3 and 4.2.3.
