topic Error in tSalesforceOutputBulkExec component in Talend Studio

Error in tSalesforceOutputBulkExec component

Anonymous — Sat, 16 Nov 2024 06:20:32 GMT

Hi,
While inserting records into "Event" module of salesforce using component 'tSalesforceOutputBulkExec' Im getting the below error
'Exception in component tSalesforceOutputBulkExec_2_tSBE
[AsyncApiException exceptionCode='InvalidBatch'
exceptionMessage='Records not processed'
]

at com.sforce.async.BulkConnection.parseAndThrowException(BulkConnection.java:108)
at com.sforce.async.BulkConnection.doHttpGet(BulkConnection.java:472)
at com.sforce.async.BulkConnection.getBatchResultStream(BulkConnection.java:369)
at org.talend.salesforceBulk.SforceBulkConnection.getBatchResultStream(SforceBulkConnection.java:94)
at org.talend.salesforceBulk.SalesforceBulkAPI.getBatchLog(SalesforceBulkAPI.java:281)
at cgi_practice.test_salesforce_image_0_1.test_salesforce_image.tHashInput_2Process(test_salesforce_image.java:1743)
at cgi_practice.test_salesforce_image_0_1.test_salesforce_image.tFileList_1Process(test_salesforce_image.java:979)
at cgi_practice.test_salesforce_image_0_1.test_salesforce_image.runJobInTOS(test_salesforce_image.java:2077)
at cgi_practice.test_salesforce_image_0_1.test_salesforce_image.main(test_salesforce_image.java:1934)'
I have mapped the columns correctly to match with the API's column names. What will be the issue.?
Thank u so much for any replies!!

Re: Error in tSalesforceOutputBulkExec component

manodwhb — Thu, 14 Mar 2019 05:58:07 GMT

@uganesh ,is that bulk file is created and does it has data?

Re: Error in tSalesforceOutputBulkExec component

Anonymous — Thu, 14 Mar 2019 06:16:47 GMT

yes...and all fields are exist

Re: Error in tSalesforceOutputBulkExec component

vatsal_ras — Fri, 22 Mar 2019 10:27:15 GMT

Whenever Salesforce throws "Invalid Batch" , it means that there is an issue with one of the columns in header. You can go into Salesforce bulk monitor and go to the particular job. It will give the exact name of the column which is causing problems. Generally there can be following reasons :

1) Typo in field API name

2) You don't have access to edit that particular API

3) Number of header and fields not matching.