How can I resolve errors indicating "Unexpected end of file ...", received while using the Data Import Wizard?

Environment:

Data Import Wizard
All supported versions

Issue:

Error encountered while using Data Import Wizard

"Unexpected end of file while parsing Name has occurred. Line #, position #."

"Root element is missing."

Resolution:

If this error is encountered when using the Data Import Wizard, this means the DATA_IMPORT_BATCH_LIMIT configuration setting should be reduced. The default setting is 1000. Continue testing with lesser values for this configuration setting until the import can consistently complete without issue.  It is expected that the import will take more time as this limit is reduced.

The execution of Custom Process Model (CPM) scripts and rules are always a factor when these errors happen.  Avoiding these actions (when possible) during the import will avoid these errors and will also have the added benefit of faster import processing. 

These errors happen when the server runs out of its total allotted memory. When CPMs and rules are executed, all the data for records being updated during the import must be loaded in memory in case they are required for the execution. Please note that the number of interfaces, custom fields, languages, and other configuration attributes increase the amount of data that is associated with the records.  

By lowering the batch limit, there will be less records processed together, and the total memory being used will be decreased.  If you are lowering this configuration to avoid these errors, the setting that works for your site can fluctuate based on the type of record being imported and the individual records being updated.