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
Andy Stevens 9Andy Stevens 9 

Error with work flow that isn't causing an error!

Hi all,

I am hoping someone out there can help resolve or at least point me in the right direction of how to solve a flow application error.

Our organisation has a number of workflows and processes to convert leads into supporters and then mark specific fields within the supporter object.  However, since I added some new roles to the objects field we have been getting the following error message.

Error element myRule_1_A1 (FlowRecordUpdate).
The flow tried to update these records: null. This error occurred: LIMIT_EXCEEDED: System.LimitException: npsp:Too many SOQL queries: 101. You can look up ExceptionCode values in the SOAP API Developer Guide.

Flow Details
Flow API Name: Tick_Volunteer
Type: Record Change Process
Version: 16
Status: Active
Org: Age UK Essex (removed for security)

Flow Interview Details
Interview Label: Tick_Volunteer-16_InterviewLabel
Current User: Sue Ambrose (removed for security)
Start time: 19/11/2019 15:24
Duration: 0 seconds

How the Interview Started
Sue Ambrose (removed for security) started the flow interview.
Some of this flow's variables were set when the interview started.
myVariable_old = Contact (removed for security)
myVariable_current = Contact (removed for security)

DECISION: myDecision
Outcome executed: myRule_1
Outcome conditions:
1. {!myVariable_current.Active_befriender__c} (false) Equals true
2. {!myVariable_current.Admin_assistant_home_help__c} (false) Equals true
3. {!myVariable_current.Admin_assistant_Information_Advice__c} (false) Equals true
4. {!myVariable_current.Admin_assistant_Clinic_TNCS__c} (false) Equals true
5. {!myVariable_current.Essay_Poetry__c} (false) Equals true
6. {!myVariable_current.Fundraising_volunteer__c} (false) Equals true
7. {!myVariable_current.Home_befriender__c} (true) Equals true
8. {!myVariable_current.Home_telephone_befriender__c} (false) Equals true
9. {!myVariable_current.HOPE_Volunteer__c} (false) Equals true
10. {!myVariable_current.IT_Mentor__c} (false) Equals true
11. {!myVariable_current.Smart_Life_Volunteer__c} (false) Equals true
12. {!myVariable_current.Telephone_Befriender__c} (false) Equals true
13. {!myVariable_current.Trustees_Directors__c} (false) Equals true
14. {!myVariable_current.Voice_Network_Volunteer__c} (false) Equals true
15. {!myVariable_current.Charity_Mascot__c} (false) Equals true
16. {!myVariable_current.CHP_Telephone_Befriender__c} (false) Equals true
17. {!myVariable_current.Media_Volunteer__c} (false) Equals true
18. {!myVariable_current.Pub_lunch_club__c} (false) Equals true
19. {!myVariable_current.Admin_assistant_Management_services__c} (false) Equals true
20. {!myVariable_current.Corporate_Telephone_Befriender__c} (false) Equals true
21. {!myVariable_current.Active_befriender__c} (false) Equals true
22. {!myVariable_current.I_A_Volunteer__c} (false) Equals true
23. {!myVariable_current.HH_Cust_Care_volunteer__c} (false) Equals true
24. {!myVariable_current.Reception_Volunteer__c} (false) Equals true
25. {!myVariable_current.Admin_assistant_Home_Visits_TNCS__c} (false) Equals true
Logic: One condition must be true (OR)

UPDATE RECORDS: myRule_1_A1
Find all Contact records where:
Id Equals {!myVariable_current.Id} (removed for security)
Update the records’ field values.
Macro_volunteer__c = true
Volunteer__c = true
Result
Failed to update records that meet the filter criteria.

Error Occurred: The flow tried to update these records: null. This error occurred: LIMIT_EXCEEDED: System.LimitException: npsp:Too many SOQL queries: 101. You can look up ExceptionCode values in the SOAP API Developer Guide.

The most frustrating thing about this error, is that although it states records haven't been updated they have.  Also it suggests governor limits have been exceeded (which I assumed process builder avoided by bulkifying) so I am a little confused as to why we are getting this error and what it is actually stopping from working?  Can anyone help?