Six Stars

tSalesforceBulkExec Client input error, failed to create a job

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
9 REPLIES
Moderator

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

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

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

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
Moderator

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

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

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

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

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

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:
Five Stars

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

Hi @jayakumarn123,

 

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

"

Moderator

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

Hello,

What's Salesforce API version are you using?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

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

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. 

Moderator

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

Hello,

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

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.