Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Error in tSalesforceOutputBulkExec component

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!!

 

0683p000009M3P7.png

Labels (4)
3 Replies
manodwhb
Champion II
Champion II

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

Anonymous
Not applicable
Author

yes...and all fields are exist

vatsal_ras
Contributor
Contributor

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.