topic Re: tSalesforceBulkExec Client input error, failed to create a job in Talend Studio

tSalesforceBulkExec Client input error, failed to create a job

Anonymous — Sat, 16 Nov 2024 10:26:16 GMT

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

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

Anonymous — Wed, 24 Aug 2016 08:30:34 GMT

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

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

Anonymous — Wed, 24 Aug 2016 11:26:02 GMT

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

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

Anonymous — Thu, 25 Aug 2016 11:27:24 GMT

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

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

Anonymous — Thu, 25 Aug 2016 14:33:21 GMT

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

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

Anonymous — Wed, 01 Feb 2017 17:46:07 GMT

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:

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

Anonymous — Thu, 26 Jul 2018 15:05:22 GMT

Hi @uganesh,

Was the issue resolved for you? If yes, please let me know the answer as I am facing the similar issue.

@xdshi, I am using Talend 7.0.1 DI and the error is coming really unexpected. The first time, I noticed while the 2nd process was going on and now I am facing issue with the first process of the Job. Below is the error message.

Starting job Neighborhood_AccountsDataloadDemo at 19:03 26/07/2018.

[statistics] connecting to socket on port 3711

[statistics] connected

Exception in component tSalesforceOutputBulkExec_1_tSalesforceBulkExec (Neighborhood_AccountsDataloadDemo)

java.io.IOException: [AsyncApiException exceptionCode='ClientInputError'

exceptionMessage='Server error returned in unknown format'

]

at org.talend.components.salesforce.runtime.SalesforceBulkExecReader.start(SalesforceBulkExecReader.java:75)

at org.talend.codegen.flowvariables.runtime.FlowVariablesReader.start(FlowVariablesReader.java:73)

at local_project.neighborhood_accountsdataloaddemo_0_1.Neighborhood_AccountsDataloadDemo.tFileInputDelimited_1Process(Neighborhood_AccountsDataloadDemo.java:5890)

at local_project.neighborhood_accountsdataloaddemo_0_1.Neighborhood_AccountsDataloadDemo.tSalesforceConnection_1Process(Neighborhood_AccountsDataloadDemo.java:753)

at local_project.neighborhood_accountsdataloaddemo_0_1.Neighborhood_AccountsDataloadDemo.runJobInTOS(Neighborhood_AccountsDataloadDemo.java:13765)

at local_project.neighborhood_accountsdataloaddemo_0_1.Neighborhood_AccountsDataloadDemo.main(Neighborhood_AccountsDataloadDemo.java:13614)

Caused by: [AsyncApiException exceptionCode='ClientInputError'

exceptionMessage='Server error returned in unknown format'

]

at com.sforce.async.BulkConnection.parseAndThrowException(BulkConnection.java:190)

at com.sforce.async.BulkConnection.doHttpGet(BulkConnection.java:747)

at com.sforce.async.BulkConnection.getBatchInfoList(BulkConnection.java:529)

at com.sforce.async.BulkConnection.getBatchInfoList(BulkConnection.java:523)

at org.talend.components.salesforce.runtime.SalesforceBulkRuntime.getBatchInfoList(SalesforceBulkRuntime.java:620)

at org.talend.components.salesforce.runtime.SalesforceBulkRuntime.awaitCompletion(SalesforceBulkRuntime.java:427)

at org.talend.components.salesforce.runtime.SalesforceBulkRuntime.executeBulk(SalesforceBulkRuntime.java:215)

at org.talend.components.salesforce.runtime.SalesforceBulkExecReader.start(SalesforceBulkExecReader.java:60)

... 5 more

[statistics] disconnected

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

Anonymous — Fri, 27 Jul 2018 08:39:41 GMT

Hello,

What's Salesforce API version are you using?

Best regards

Sabrina

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

Anonymous — Tue, 31 Jul 2018 19:25:57 GMT

Hi @xdshi,

I am using Salesforce API version 42.

Also, I suspect the issue might be due to the RAM memory. I have an OLD PC with 4GB RAM. Please let me know if this impact the process.

Thanks.

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

Anonymous — Wed, 01 Aug 2018 03:46:49 GMT

Hello,

What's your largest batch size? Does it works when you swap to tSalesforceOutput component?

Best regards

Sabrina