Question:
How to Troubleshoot Salesforce Dataloading Issues, in the Event the CSV Insert/Update/Upsert/Delete Operation Fails?
The error may look like the following:
Got an unexpected error while processing BULK-API. Contact support with error ID: xxxxxxxxxx-xxxxxxx (xxxxxxxxx)
Answer:
SFDC may throw an exception without indicating the real error of the csv file.
Two ways are recommended to locate the real error:
- Use Batch size 1 to load each row of the CSV. It is heavily recommended to use the latest version of SFDC Dataloader using the standard options. It is not recommended to use Batch Size 1 / Bulk API options for several dataloads, as the SFDC Daily API limit may be hit quickly.
- Another option is to split the CSV file, and load the split records. Excel and other 3rd Party tools (Salesforce Inspector, Workbench) may be used in conjuction to carry out the data manipulating and dataloading process.
Related Documentation:
CRM Help Documentation: N/A
Workbench:
Knowledge Base: