Error Message - Too Many SOQL Queries: 101 on Process Builder
After sending a campaign have you have received an error by email relating to "Too many SOQL queries: 101"?
If so then this article will explain how to combat this error and help you understand why it has ocurred.
What does this error message mean?
When a query is written in Salesforce it is counted under SOQL. This specific error occurs when flows executed by Process Builder that create, update, or delete Salesforce records, cause conflicts. In this case your code is issuing more than 100 SOQL queries, causing the error to occur.
In the case of CommuniGator, this would be that your campaign results, clicks, opens etc are not being synced in to Salesforce.
How do I resolve this error?
1. From 'Setup' enter 'Critical' into the 'Quick Find' box.
2. Select 'Critical Updates'.
3. For Enable Flow and Process Queries to execute in batches, click 'Activate'.