tSalesforceBulkExec Exception

Six Stars

tSalesforceBulkExec Exception

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

Highlighted
Moderator

Re: tSalesforceBulkExec Exception

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

 

  1. Check on the network side if there is any problem.
  2. Check on the Salesforce trust site if there is any performance problem in SF instance.
  3. Check the API limits on the salesforce.
Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Highlighted
Sixteen Stars
Sixteen Stars

Re: tSalesforceBulkExec Exception

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


TRF
Highlighted
Six Stars

Re: tSalesforceBulkExec Exception

Yes. We have set a proxy using tSetProxy.
Highlighted
Six Stars

Re: tSalesforceBulkExec Exception

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

Re: tSalesforceBulkExec Exception

@KrupalGharat ,

 

  1. Check on the network side if there is any problem. need to check at nework side
  2. Check on the Salesforce trust site if there is any performance problem in SF instance. SF side
  3. Check the API limits on the salesforce. SF side
Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Highlighted
Sixteen Stars
Sixteen Stars

Re: tSalesforceBulkExec Exception

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

TRF
Highlighted
Six Stars

Re: tSalesforceBulkExec Exception

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

Highlighted
Sixteen Stars
Sixteen Stars

Re: tSalesforceBulkExec Exception

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.

TRF
Highlighted
Six Stars

Re: tSalesforceBulkExec Exception

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 

 

Highlighted
Sixteen Stars
Sixteen Stars

Re: tSalesforceBulkExec Exception

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.


TRF

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog