When using Salesforce Data Loader to perform bulk Insert or Upsert operations, a Process Builder process triggered on the affected object may fail if the batch size is too large. This occurs because Process Builder has limitations in handling high-volume bulk operations simultaneously. When a batch is too large, Process Builder cannot complete its triggered actions for all records within the allowed time, resulting in a flow trigger failure error.
Data Loader error file message:
"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."
System Administrator flow error email example:
"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"
Reducing the batch size in Salesforce Data Loader allows Process Builder sufficient time to complete its triggered actions between record saves, preventing the flow trigger timeout error.
To reduce the batch size in Data Loader:
This causes Data Loader to process records one at a time, giving Process Builder the time it needs to complete its actions. The impact on overall processing time is minimal for most datasets.
Some environments may support a slightly larger batch size (such as 20) without errors. If the error persists with a batch size of 20, set the batch size to 1.
000387062

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.