Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'
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..
HI, maybe The BulkConnection leaves open connections.
Send me Love and Kudos
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 ..
