You need to sign in to do that
Don't have an account?
Melissa 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.
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.
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.