function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Alex Waddell 17Alex Waddell 17 

Why am I running into SOQL Query Limits on a simple Process Flow

Hello,

I am running into a problem when trying to mass update records using Data Loader. Does anyone have any idea why a Process could be running into a SOQL Query Limit? I have made countless Processes similar to this before and have never ran into this issue

Below are photos of my process (which doesn't use a Flow) and the error that gets sent to my email.

User-added image
User-added image
User-added image
User-added image

Error element myRule_1_A1 (FlowRecordUpdate).
This error occurred when the flow tried to update records: Too many SOQL queries: 101. For details, see API Exceptions.

This report lists the elements that the flow interview executed. The report is a beta feature.
We welcome your feedback on IdeaExchange.

Flow Details
Flow Name: PERS_Install_Due_Date_Escalation
Type: Record Change Process
Version: 2
Status: Active

Flow Interview Details
Interview Label: PERS_Install_Due_Date_Escalation-2_InterviewLabel
Current User: Alex Waddell (0051N000005gBa1)
Start time: 4/30/2018 9:08 AM
Duration: 0 seconds

How the Interview Started
Alex Waddell (0051N000005gBa1) started the flow interview.
Some of this flow's variables were set when the interview started.
myVariable_old = a061N00000QwT6FQAV
myVariable_current = a061N00000QwT6FQAV

ASSIGNMENT: myVariable_waitStartTimeAssignment
{!myVariable_waitStartTimeVariable} Equals {!Flow.CurrentDateTime}
Result
{!myVariable_waitStartTimeVariable} = "4/30/2018 9:08 AM"

DECISION: myDecision
Executed this outcome: myRule_1
Outcome conditions: and
1. {!myVariable_current.Referral_Date__c} (May 20, 2011) Does not equal null
Logic: All conditions must be true (AND)

RECORD UPDATE: myRule_1_A1
Find all Service_Plans__c records where:
Id Equals {!myVariable_current.Id} (a061N00000QwT6FQAV)
Update the records’ field values.
Install_Due_Date__c = {!formula_2_myRule_1_A1_6049305404} (June 3, 2011)
Result
Failed to update records that meet the filter criteria.

Error Occurred: Too many SOQL queries: 101

 
Alain CabonAlain Cabon
Hi,

 "mass update records using Data Loader" : what is the "Batch size" used?

Batch size In a single insert, update, upsert, or delete operation, records moving to or from Salesforce are processed in increments of this size. The maximum is 200 records. We recommend a value between 50 and 100.
The maximum value is 10,000 if the Use Bulk API option is selected.

https://help.salesforce.com/articleView?id=configuring_the_data_loader.htm&type=5