Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
@uganesh ,is that bulk file is created and does it has data?
yes...and all fields are exist
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.