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
Melissa Parker 17Melissa Parker 17 

Error Occurred During Flow "Other_Trades_Update": geopointe:Too many SOQL queries: 201

hello,

I am receiving this error during a Process Builder. This particular Process has many updates that timestamps fields when each fields associated checkbox is checked. This is very lengthy, however, at the end of the report the results are: Failed to update records that meet the criteria. 

An error occurred at element myRule_1_A2 (FlowRecordUpdate).
geopointe:Too many SOQL queries: 201

Flow Details
Flow Name: Other_Trades_Update
Type: Workflow
Version: 4
Status: Active

Flow Interview Details
Interview Label: 
Current User: MadSky Admin (00561000000ZrJo)
Start time: 3/6/2016 12:17 PM
Duration: 0 seconds

How the Interview Started
MadSky Admin (00561000000ZrJo) started the flow interview.
Some of this flow's variables were set when the interview started.
myVariable_old = a0M61000001zAAFEA2
myVariable_current = a0M61000001zAAFEA2

ASSIGNMENT: myVariable_waitStartTimeAssignment
{!myVariable_waitStartTimeVariable} Equals {!Flow.CurrentDateTime}
Result
{!myVariable_waitStartTimeVariable} = "3/6/2016 12:17 PM"

DECISION: myDecision
Executed this outcome: myRule_1
Outcome conditions: and
1. {!formula_myRule_1} (true) Equals true
Logic: All conditions must be true (AND)

RECORD UPDATE: myRule_1_A1
Find all Assignments__c records where:
Siding_Started_Time__c Is null true
Siding_Status__c Equals Started
Id Equals {!myVariable_current.Id} (a0M61000001zAAFEA2)
Update the records’ field values.
Siding_Started_Time__c = {!formula_21_myRule_1_A1_Siding_Started_Time_c} (3/6/2016 12:17 PM)
Siding_Started__c = true
Result
All records that meet the filter criteria are ready to be updated when the next Screen or Wait element is executed or when the interview finishes.

RECORD UPDATE: myRule_1_A2
Find all Assignments__c records where:
Siding_Completed_Time__c Is null true
Siding_Status__c Equals Complete
Id Equals {!myVariable_current.Id} (a0M61000001zAAFEA2)
Update the records’ field values.
Siding_Completed_Time__c = {!formula_20_myRule_1_A2_Siding_Completed_Time_c} (3/6/2016 12:17 PM)
Siding_Completed__c = true
Result
Failed to update records that meet the filter criteria.

 
Naval Sharma4Naval Sharma4
Hi Melissa,

It seems your processes calling recursively after each field update and in order to prevent that don't forget to uncheck "Do you want to execute the actions only when specified changes are made to the record?" in advance option of Action node in your process builder.
Melissa Parker 17Melissa Parker 17
Interesting. Is the checkbox below is what you are referring to? If so, this is not checked.User-added image
Ken ReyesKen Reyes
For me @Naval Sharma4; this was the answer.  I had a lot of conditions but without the "execute actins only when specified..." ticked off I was getting this same flow error.  When ticked off for each decision; no more errors!  Thanks!