Six Stars

tSalesforceBulkExec Client input error, failed to create a job

Hello,
i'm using TSalesforceBulkExec component and getting this error. Although I have good proxy settings and did everything similar to talend tutorial. Have no idea  what could be wrong. Thank you for any help
Exception in component tSalesforceBulkExec_1
java.io.IOException:
    at org.talend.components.salesforce.runtime.SalesforceBulkExecReader.start(SalesforceBulkExecReader.java:76)
    at training2.postingtosalesforce_0_1.PostingtoSalesForce.tSalesforceBulkExec_1Process(PostingtoSalesForce.java:2426)
    at training2.postingtosalesforce_0_1.PostingtoSalesForce.tFileInputDelimited_1Process(PostingtoSalesForce.java:1430)
    at training2.postingtosalesforce_0_1.PostingtoSalesForce.runJobInTOS(PostingtoSalesForce.java:5809)
    at training2.postingtosalesforce_0_1.PostingtoSalesForce.main(PostingtoSalesForce.java:5646)
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(DualStackPlainSocketImpl.java:79)
    at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
    at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
    at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
    at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
    at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
    at java.net.Socket.connect(Socket.java:589)
    at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
    at sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
    at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
    at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
    at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
    at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
    at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
    at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
    at sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1148)
    at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
    at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
    at sun.net.www.protocol.http.HttpURLConnection.getOutputStream0(HttpURLConnection.java:1283)
    at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(HttpURLConnection.java:1258)
    at sun.net.www.protocol.https.HttpsURLConnectionImpl.getOutputStream(HttpsURLConnectionImpl.java:250)
    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
5 REPLIES
Moderator

Re: tSalesforceBulkExec Client input error, failed to create a job

Hi,
Does your job work well when use the tSalesforceOutputComponent? Does this issue only repro on bulk components(tSalesforceOutputBulkExec alone or tSalesforceOutputBulk with tSalesforceBulkExec)?
Could you please indicate on which build version you got this issue?
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.
Six Stars

Re: tSalesforceBulkExec Client input error, failed to create a job

Hello, Sabrina,
Yes, the same error happens in both cases - using only SalesforceOutputBulkExec and when using tSalesforceOutput Bulk and tSalesforceBulkExec.
Simple tSalesforceOutput and tSalesforceInput works okay
My Talend version is 6.2.1
Thank you,
Gabriele
Moderator

Re: tSalesforceBulkExec Client input error, failed to create a job

Hi,
Please check the schema of both input component and tSalesforceOutputBulkExec to make sure the column names are the same with salesforce and check that is there any field on the output schema that you forgot to map.
Component setting screenshots will be preferred.
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.
Six Stars

Re: tSalesforceBulkExec Client input error, failed to create a job

This the configuration it is really simple, I don't know what could be wrong:
One Star

Re: tSalesforceBulkExec Client input error, failed to create a job

We are getting the same issue with tht tSalesforceBulkExec with the tsaleforceConnection with the Bulk connection enabled. The bulk exec component is called after the successful connection from the tsaleforceconnection. But getting the below error. any input would be greatly appreciated 
tSalesforceBulkExec_1java.io.IOException: