Exception in component tSalesforceBulkExec_1

Anonymous — Sat, 16 Nov 2024 12:36:08 GMT

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

Re: Exception in component tSalesforceBulkExec_1

Anonymous — Wed, 02 Nov 2011 09:40:12 GMT

Hi,
Does anyone have any ideas about this? Thanks a lot,
Ian

Re: Exception in component tSalesforceBulkExec_1

_AnonymousUser — Fri, 13 Jan 2012 13:05:44 GMT

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.

Re: Exception in component tSalesforceBulkExec_1

Anonymous — Tue, 30 Sep 2014 09:16:02 GMT

Hi, i think you should upgrade Talend , as this is a common issues in the version 5.2 ( or less )
When i used recent version it works fine, and i had the same issue when using old versions
http://talendexpert.com/exception-component-tsalesforcebulkexec_1/

topic Re: Exception in component tSalesforceBulkExec_1 in Talend Studio

Exception in component tSalesforceBulkExec_1

Re: Exception in component tSalesforceBulkExec_1

Re: Exception in component tSalesforceBulkExec_1

Re: Exception in component tSalesforceBulkExec_1