tSalesforceBulkExec Client input error, failed to create a job

[Anonymous]

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(AbstractDelegateHttpsURLConne...)
    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.jav...)
    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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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:

[Anonymous]

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

"

[Anonymous]

Hello,

What's Salesforce API version are you using?

Best regards

Sabrina

[Anonymous]

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. 

[Anonymous]

Hello,

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

Best regards

Sabrina