topic Re: tSalesforceBulkExec Exception in Talend Studio

tSalesforceBulkExec Exception

KrupalGharat — Sat, 16 Nov 2024 04:09:28 GMT

Tried using tSalesforceBulkExec along with tSalesforceOutputBulk in place of tSalesforceOutput component

But when I run the job from TAC, I am getting the following error:

Java Exception|tSalesforceBulkExec|java.io.IOException:[AsyncApiException exceptionCode='ClientInputError'
exceptionMessage='Failed to create job '

Talend version: 6.2.1

Salesforce version: v34

Re: tSalesforceBulkExec Exception

manodwhb — Fri, 08 Nov 2019 07:55:24 GMT

@KrupalGharat , you need to check the below point for this error to reslove.

Check on the network side if there is any problem.
Check on the Salesforce trust site if there is any performance problem in SF instance.
Check the API limits on the salesforce.

Re: tSalesforceBulkExec Exception

TRF — Fri, 08 Nov 2019 08:00:58 GMT

@KrupalGharat verify if you have a proxy in the environment the jobs are running

Re: tSalesforceBulkExec Exception

KrupalGharat — Fri, 08 Nov 2019 08:04:09 GMT

Yes. We have set a proxy using tSetProxy.

Re: tSalesforceBulkExec Exception

KrupalGharat — Fri, 08 Nov 2019 08:05:20 GMT

Do you have any idea on where should the problem must be ! Is it talend job or some setting in salesforce must be done ?

Re: tSalesforceBulkExec Exception

manodwhb — Fri, 08 Nov 2019 08:06:26 GMT

@KrupalGharat ,

Check on the network side if there is any problem. need to check at nework side
Check on the Salesforce trust site if there is any performance problem in SF instance. SF side
Check the API limits on the salesforce. SF side

Re: tSalesforceBulkExec Exception

TRF — Fri, 08 Nov 2019 08:10:45 GMT

Use tSetProxy in your job to configure the proxy.
Usually a context variable should be set to true or false to indicate if you have a proxy or not and help you to decide if you must execute the tSetProxy or not

Re: tSalesforceBulkExec Exception

KrupalGharat — Wed, 13 Nov 2019 06:27:03 GMT

@TRF

The issue is not yet solved.

tSetProxy component is already used in the job.

Talend version: 6.2.1

Salesforce version: v47

Also, the above salesforce version is not compatible with the current talend version.

Thanks in advance.

Re: tSalesforceBulkExec Exception

TRF — Wed, 13 Nov 2019 07:35:04 GMT

For Talend 6.4 you limited to Salesforce API 39.0
If need to go with a most recent API version, you need to upgrade your Studio.
Refer to Salesforce documentation to know the required API version depending on the objects you have to use.

Re: tSalesforceBulkExec Exception

KrupalGharat — Wed, 13 Nov 2019 08:38:53 GMT

What if the salesforce API used is v47

But in salesforce endpoint context parameter I have value "https://test.salesforce.com/services/Soap/u/34.0"

So is it okay if we have 34 in URL to connect to salesforce with version 47 ?

@TRF

Re: tSalesforceBulkExec Exception

TRF — Wed, 13 Nov 2019 08:44:57 GMT

AS soon as your URL is "https://test.salesforce.com/services/Soap/u/34.0" you're using Salesforce API version 34.0 even if more recent versions are available on Salesforce side.