Loading

Data Loader inserts or upserts cause Process Builder errors

Publiseringsdato: Oct 13, 2022
Beskrivelse

While Process Builder is being improved to better handle bulk processing, it can still generate errors when a large Data Loader Insert or Upsert triggers a Process.  The Error within the Data Loader error file will look similar to:
 

The record couldn’t be saved because it failed to trigger a flow. A flow trigger failed to execute the flow with version ID 301j00000001X2z.  Contact your administrator for help.


Your System Administrator will get a flow error email that starts like the below:


An error occurred at element myRule_1_A1 (FlowRecordUpdate).
UPDATE --- UPDATE FAILED --- ERRORS : (ALL_OR_NONE_OPERATION_ROLLED_BACK) Record rolled back because not all records were valid and the request was using AllOrNone header --- for SFDC record with ID : 001j0000002Xy1ZAAS
 

Løsning
In Data Loader, navigate to Settings | Settings and lower the 'Batch size' to 1. 

This will perform the update in smaller chunks, and allow Process Builder the time it needs to complete its actions.  This will cause only a minimal impact on update times for the Data Loader process.

Note: Some environments may support slightly larger 'Batch sizes' like 20 without errors but, if the error persists with 'Batch size' set to 20, then the batch should be set to 1.



See also
Configure Data Loader
Knowledge-artikkelnummer

000387062

 
Laster
Salesforce Help | Article