tSalesforceBulkExec Error - "Failed to create job"

Four Stars

tSalesforceBulkExec Error - "Failed to create job"

Hi,
I am stuck with tSalesforceBulkExec execution error. Please see the error below.
The load is working fine with tSalesforceOutput but I want to load this using Bulk load. Please see screenshot of the mapping attached
Starting job A1_LOAD_USER at 17:07 26/09/2016.
connecting to socket on port 3334
connected
Exception in component tSalesforceBulkExec_1
java.io.IOException:
at org.talend.components.salesforce.runtime.SalesforceBulkExecReader.start(SalesforceBulkExecReader.java:76)
at local_project.a1_load_user_0_1.A1_LOAD_USER.tSalesforceBulkExec_1Process(A1_LOAD_USER.java:12092)
at local_project.a1_load_user_0_1.A1_LOAD_USER.tOracleInput_1Process(A1_LOAD_USER.java:3915)
at local_project.a1_load_user_0_1.A1_LOAD_USER.tSetProxy_1Process(A1_LOAD_USER.java:441)
at local_project.a1_load_user_0_1.A1_LOAD_USER.runJobInTOS(A1_LOAD_USER.java:14541)
at local_project.a1_load_user_0_1.A1_LOAD_USER.main(A1_LOAD_USER.java:14398)
Caused by:
at com.sforce.async.BulkConnection.createOrUpdateJob(BulkConnection.java:121)
at com.sforce.async.BulkConnection.createJob(BulkConnection.java:96)
at org.talend.components.salesforce.runtime.SalesforceBulkRuntime.createJob(SalesforceBulkRuntime.java:454)
at org.talend.components.salesforce.runtime.SalesforceBulkRuntime.createJob(SalesforceBulkRuntime.java:157)
at org.talend.components.salesforce.runtime.SalesforceBulkRuntime.executeBulk(SalesforceBulkRuntime.java:111)
at org.talend.components.salesforce.runtime.SalesforceBulkExecReader.start(SalesforceBulkExecReader.java:61)
... 5 more
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.plainConnect0(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.getOutputStream0(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.connectRaw(JdkHttpTransport.java:136)
at com.sforce.ws.transport.JdkHttpTransport.connectLocal(JdkHttpTransport.java:100)
at com.sforce.ws.transport.JdkHttpTransport.connect(JdkHttpTransport.java:70)
at com.sforce.async.BulkConnection.createOrUpdateJob(BulkConnection.java:102)
... 10 more
Exception in component tSalesforceBulkExec_1
java.io.IOException:
at org.talend.components.salesforce.runtime.SalesforceBulkExecReader.start(SalesforceBulkExecReader.java:76)
at local_project.a1_load_user_0_1.A1_LOAD_USER.tSalesforceBulkExec_1Process(A1_LOAD_USER.java:12092)
at local_project.a1_load_user_0_1.A1_LOAD_USER.tSetProxy_2Process(A1_LOAD_USER.java:14315)
at local_project.a1_load_user_0_1.A1_LOAD_USER.runJobInTOS(A1_LOAD_USER.java:14553)
at local_project.a1_load_user_0_1.A1_LOAD_USER.main(A1_LOAD_USER.java:14398)
Caused by:
at com.sforce.async.BulkConnection.createOrUpdateJob(BulkConnection.java:121)
at com.sforce.async.BulkConnection.createJob(BulkConnection.java:96)
at org.talend.components.salesforce.runtime.SalesforceBulkRuntime.createJob(SalesforceBulkRuntime.java:454)
at org.talend.components.salesforce.runtime.SalesforceBulkRuntime.createJob(SalesforceBulkRuntime.java:157)
at org.talend.components.salesforce.runtime.SalesforceBulkRuntime.executeBulk(SalesforceBulkRuntime.java:111)
at org.talend.components.salesforce.runtime.SalesforceBulkExecReader.start(SalesforceBulkExecReader.java:61)
... 4 more
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.plainConnect0(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.getOutputStream0(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.connectRaw(JdkHttpTransport.java:136)
at com.sforce.ws.transport.JdkHttpTransport.connectLocal(JdkHttpTransport.java:100)
at com.sforce.ws.transport.JdkHttpTransport.connect(JdkHttpTransport.java:70)
at com.sforce.async.BulkConnection.createOrUpdateJob(BulkConnection.java:102)
... 9 more
disconnected
Job A1_LOAD_USER ended at 17:08 26/09/2016.

Moderator

Re: tSalesforceBulkExec Error - "Failed to create job"

Hi,
Could you please use tSalesforceOutputBulkExec instead to see if this issue repro?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: tSalesforceBulkExec Error - "Failed to create job"

Thanks for your response, its the same error with tSalesforceOutputBulkExec as well. Please see the screenshot for details.
Please help with some other possible option.

One Star

Re: tSalesforceBulkExec Error - "Failed to create job"

Hi,
Check carefully the fields name in the tSalesforcexxxx component.
On Salesforce side, go in Setup > Jobs > Bulk Data Load Jobs then locate the last job, you'll find the error on the page's right side.
Hope this helps.
Regards,
TRF  
Four Stars

Re: tSalesforceBulkExec Error - "Failed to create job"

Hi,
I have verified the column mapping and used tSalesforceConnection as well but its giving the same error message. Please suggest

One Star

Re: tSalesforceBulkExec Error - "Failed to create job"

I can see following error message in your code "Caused by: java.net.ConnectException: Connection timed out: connect"
Are you sure you have set all the parameters correctly?
Four Stars

Re: tSalesforceBulkExec Error - "Failed to create job"

Hi Sankalp,
Thanks for your response. I have verified the connections and am also using proxy settings so connection seems good. Please suggest if there is any other possible error
Four Stars

Re: tSalesforceBulkExec Error - "Failed to create job"

Hi,
I have tried and used 2 different tSetProxy as well - 1 for HTTPS and 1 for SOCKS proxy but its still giving the same error.
Please see the details below, would highly appreciate help in this matter as I am stuck with this couple of days now. Thanks!!
Starting job A1_LOAD_USER_OLD at 16:02 29/09/2016.
connecting to socket on port 4051
connected
Exception in component tSalesforceOutputBulkExec_1_tSalesforceBulkExec
java.io.IOException:
at org.talend.components.salesforce.runtime.SalesforceBulkExecReader.start(SalesforceBulkExecReader.java:76)
at local_project.a1_load_user_old_0_1.A1_LOAD_USER_OLD.tFileInputDelimited_1Process(A1_LOAD_USER_OLD.java:12539)
at local_project.a1_load_user_old_0_1.A1_LOAD_USER_OLD.tSalesforceConnection_1Process(A1_LOAD_USER_OLD.java:747)
at local_project.a1_load_user_old_0_1.A1_LOAD_USER_OLD.tSetProxy_2Process(A1_LOAD_USER_OLD.java:584)
at local_project.a1_load_user_old_0_1.A1_LOAD_USER_OLD.tSetProxy_1Process(A1_LOAD_USER_OLD.java:455)
at local_project.a1_load_user_old_0_1.A1_LOAD_USER_OLD.runJobInTOS(A1_LOAD_USER_OLD.java:15246)
at local_project.a1_load_user_old_0_1.A1_LOAD_USER_OLD.main(A1_LOAD_USER_OLD.java:15103)
Caused by: disconnected
]
at com.sforce.async.BulkConnection.createOrUpdateJob(BulkConnection.java:121)
at com.sforce.async.BulkConnection.createJob(BulkConnection.java:96)
at org.talend.components.salesforce.runtime.SalesforceBulkRuntime.createJob(SalesforceBulkRuntime.java:454)
at org.talend.components.salesforce.runtime.SalesforceBulkRuntime.createJob(SalesforceBulkRuntime.java:157)
at org.talend.components.salesforce.runtime.SalesforceBulkRuntime.executeBulk(SalesforceBulkRuntime.java:111)
at org.talend.components.salesforce.runtime.SalesforceBulkExecReader.start(SalesforceBulkExecReader.java:61)
... 6 more
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.plainConnect0(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.getOutputStream0(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.connectRaw(JdkHttpTransport.java:136)
at com.sforce.ws.transport.JdkHttpTransport.connectLocal(JdkHttpTransport.java:100)
at com.sforce.ws.transport.JdkHttpTransport.connect(JdkHttpTransport.java:70)
at com.sforce.async.BulkConnection.createOrUpdateJob(BulkConnection.java:102)
... 11 more
Job A1_LOAD_USER_OLD ended at 16:02 29/09/2016.


Four Stars

Re: tSalesforceBulkExec Error - "Failed to create job"

Hi,
Can someone please suggest and help with this?
Thanks and Regards,
Shiv Soni