Failed to create a Batch, Client Input Error, Talend installed on Windows OS

MDwadasi — Sat, 16 Nov 2024 00:18:11 GMT

Hi Can anyone help me on this,

I have job running on daily bases. and uploads the records, that job has a batch size of 5, If I decrease the batch size to 1 ,

The following Error

I want to decrease the batch size to 1 due to my system requirements on uploading data.

Starting job QuatationInsertFromSpcrtProduction at 11:50 07/04/2021.

Null value will be used for context parameter Salesforce_Production1_proxy_port: For input string: ""

Null value will be used for context parameter Salesforce_Production1_oauth_callbackPort: For input string: ""

Null value will be used for context parameter Salesforce_Production1_oauth2JwtFlow_expirationTime: For input string: ""

[statistics] connecting to socket on port 3714

[statistics] connected

Exception in component tSalesforceOutputBulkExec_1_tSalesforceBulkExec (QuatationInsertFromSpcrtProduction)

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

exceptionMessage='Failed to create batch'

]

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

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

at dksh_new.quatationinsertfromspcrtproduction_0_1.QuatationInsertFromSpcrtProduction.tDBInput_1Process(QuatationInsertFromSpcrtProduction.java:5430)

at dksh_new.quatationinsertfromspcrtproduction_0_1.QuatationInsertFromSpcrtProduction.runJobInTOS(QuatationInsertFromSpcrtProduction.java:7807)

at dksh_new.quatationinsertfromspcrtproduction_0_1.QuatationInsertFromSpcrtProduction.main(QuatationInsertFromSpcrtProduction.java:7271)

Caused by: [AsyncApiException exceptionCode='ClientInputError'

exceptionMessage='Failed to create batch'

]

at com.sforce.async.BulkConnection.createBatchFromStreamImpl(BulkConnection.java:246)

at com.sforce.async.BulkConnection.createBatchFromStream(BulkConnection.java:216)

at org.talend.components.salesforce.runtime.SalesforceBulkRuntime.createBatchFromStream(SalesforceBulkRuntime.java:611)

at org.talend.components.salesforce.runtime.SalesforceBulkRuntime.createBatch(SalesforceBulkRuntime.java:378)

at org.talend.components.salesforce.runtime.SalesforceBulkRuntime.createBatchesFromCSVFile(SalesforceBulkRuntime.java:331)

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

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

... 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.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:143)

at com.sforce.ws.transport.JdkHttpTransport.connectLocal(JdkHttpTransport.java:103)

at com.sforce.ws.transport.JdkHttpTransport.connect(JdkHttpTransport.java:79)

at com.sforce.async.BulkConnection.createBatchFromStreamImpl(BulkConnection.java:233)

... 10 more

[statistics] disconnected

Job QuatationInsertFromSpcrtProduction ended at 12:11 07/04/2021. [Exit code = 1]

Thanks in advance.

Anyone's help is much appreciated, struggling with this issue from long time..

Re: Failed to create a Batch, Client Input Error, Talend installed on Windows OS

gjeremy1617088143 — Wed, 07 Apr 2021 07:27:57 GMT

HI, maybe The BulkConnection leaves open connections.

Send me Love and Kudos

Re: Failed to create a Batch, Client Input Error, Talend installed on Windows OS

MDwadasi — Wed, 07 Apr 2021 14:08:50 GMT

Thank you for your response ,

Can you Plz elaborate on this.

These are my settings.

I tired placing same values in both Rows to commit and Timeout in ms ..

Re: Failed to create a Batch, Client Input Error, Talend installed on Windows OS

MDwadasi — Wed, 07 Apr 2021 14:09:49 GMT

topic Re: Failed to create a Batch, Client Input Error, Talend installed on Windows OS in Talend Studio

Failed to create a Batch, Client Input Error, Talend installed on Windows OS

Re: Failed to create a Batch, Client Input Error, Talend installed on Windows OS

Re: Failed to create a Batch, Client Input Error, Talend installed on Windows OS

Re: Failed to create a Batch, Client Input Error, Talend installed on Windows OS