topic Re: Salesforce error 'Failed to create batch' in Talend Studio

Salesforce error 'Failed to create batch'

mani1304 — Sat, 16 Nov 2024 02:47:38 GMT

Hi All,

I am running a job where it upserts data in one object using tSalesforceOutputbulkExec component but every time job is getting fail with the below error while running in prod server but while running in dev server with same credentials it runs fine, can someone suggest on it.

AsyncApiException exceptionCode='ClientInputError'
exceptionMessage='Failed to create batch'

Re: Salesforce error 'Failed to create batch'

TRF — Sat, 04 Apr 2020 13:45:33 GMT

Usually this error occurs when you try to access an field that doesn't existe or for which you don't have visibllity on. To know the field name, connect to salesforce, go to Setup > Jobs > Bulk Data Load Jobs then move the mouse pointer on the right side of the job list over the message 'Failed to create batch'. This will display the complete message with the field on error.

Re: Salesforce error 'Failed to create batch'

mani1304 — Sat, 04 Apr 2020 14:11:33 GMT

Thanks but nothing is coming as failed in Bulk Load jobs screen, That particular object coming in In progress and in the job Id, it's showing Status as Open, Completed batches 1729, Records processed 345,800, failed batches zero. Could you please suggest on it.

Re: Salesforce error 'Failed to create batch'

TRF — Sat, 04 Apr 2020 14:19:23 GMT

Difficult to say without hands on the environment. If I understand your last message, a part of the operation works fine (1729 completed batchs) before it fails. Right? If so, maybe the file associated to thé tSalesforceOutputBulkExec is corrupted. You should check that.

Re: Salesforce error 'Failed to create batch'

mani1304 — Sat, 04 Apr 2020 14:47:51 GMT

Thanks, the .csv file has 898588 records and doesn't seem corrupted, I am more investigating on it, if you get something please suggest.

Re: Salesforce error 'Failed to create batch'

TRF — Sat, 04 Apr 2020 15:21:28 GMT

Maybe you can share what is displayed on Bulk Data Load Jobs list

Re: Salesforce error 'Failed to create batch'

mani1304 — Mon, 06 Apr 2020 18:01:47 GMT

Thanks, but it seems like it's server's configuration error. As Idescribed earlier that it's running fine in dev server and creating issue in prod server. I will update on this.

Re: Salesforce error 'Failed to create batch'

mani1304 — Thu, 14 May 2020 08:23:49 GMT

It was a server issue, we fixed it and job ran fine.

Re: Salesforce error 'Failed to create batch'

vatsal_ras — Sat, 13 Jun 2020 11:33:29 GMT

What fix did you make ?

Re: Salesforce error 'Failed to create batch'

mani1304 — Mon, 22 Jun 2020 14:48:42 GMT

made the same configuration of dev and prod to allow to open many files via increasing /etc/security/limits.configurations for soft and hard limits

Re: Salesforce error 'Failed to create batch'

MDwadasi — Tue, 09 Mar 2021 09:20:35 GMT

Hi Everyone,

I am facing this issue, and unable to resolve the issue..

May I request anyone can explain how is it resolved?

Please help me with this... What is the server issue and how did you fix it?

Re: Salesforce error 'Failed to create batch'

mani1304 — Sun, 04 Apr 2021 17:57:54 GMT

mentioned above also.

made the same configuration of dev and prod to allow to open many files via increasing /etc/security/limits.configurations for soft and hard limits

Re: Salesforce error 'Failed to create batch'

MDwadasi — Tue, 06 Apr 2021 05:02:40 GMT

Thank Mani,

For your response.

But I am unable to figure it out, I am new to Talend,

and my Talend Application is on windows OS.

I am unable to find the path which you provided.

If you can explain me or share any Screen shot It would help me alot for better understanding.

Thanks in advance.

Re: Salesforce error 'Failed to create batch'

mani1304 — Tue, 06 Apr 2021 06:04:36 GMT

I can't comment on windows, mine is Linux. Please check with your server admin if they can help, you can tell them what I did on Linux.

Re: Salesforce error 'Failed to create batch'

dk12 — Mon, 16 Sep 2024 13:12:13 GMT

Hi, I am getting this error could you please explain what changes need to made in this file, or any screen shot if you can attach

I am using Linux

Thanks