0

I'm trying to upload files to Salesforce using data loader and the file size is around 45MB every time I'm trying to upload the file I got error with maximum retries reached, any idea how to deploy large file using data loader.

Screenshot:
enter image description here

2
  • Dataloader can handle up to 5 million records and upload file size is 50 MB and I suspect it shouldn't be a problem with dataloader. Can you try using batch size limit to 1 (help.salesforce.com/…). Also if possible kindly add screenshot of the error message.
    – Vinay
    Apr 11, 2021 at 11:03
  • @Vinay I added screenshot. Apr 11, 2021 at 12:59

1 Answer 1

2

The Data Loader uses the SOAP API, which has an inherent limit of 50MB. SOAP is an XML-based protocol, so binary data has to be Base64 encoded, which turns three bytes into four, effectively reducing the maximum payload for binary data by 25%. The actual maximum ends up being around 37.5MB (less than 39,321,600, as the bytes in the protocol itself reduce this number further). This is called out in the documentation in various places:

The maximum file size you can upload via the SOAP API is 50 MB. When a document is uploaded or downloaded via the API, it is converted to base64 and stored in VersionData. This conversion increases the document size by approximately 37%. Account for the base64 conversion increase so that the file you plan to upload is less than 50 MB after conversion.

If you want to upload files larger than that, you need something that can support large binary data (as described in Insert or Update Blob Data). You would either need to modify the source code or find another ETL tool that supports large files. You'll want to do your own research on this subject. I'm not aware of any specific tools out there that can support this.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.