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

[MDwadasi]

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

[gjeremy1617088143]

HI, maybe The BulkConnection leaves open connections.

Send me Love and Kudos

[MDwadasi]

Hi

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