Exception in component tSalesforceBulkExec_1

One Star

Exception in component tSalesforceBulkExec_1

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
One Star

Re: Exception in component tSalesforceBulkExec_1

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

Re: Exception in component tSalesforceBulkExec_1

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.
One Star

Re: Exception in component tSalesforceBulkExec_1

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/