Salesforce Too Many SOQL Queries: 101 Error

How to fix it

Try these in order — the most common fix is first.

1. 1. Bulkify the Flow

   Copy steps
   1. Open the Flow in Setup > Flows
   2. Move any Get Records element out of the Loop
   3. Query once for the whole collection, then loop over it in memory
   4. Use a Decision to skip records that need no lookup
   Did this fix it? Yes No

2. 2. Bulkify Apex

   Copy steps
   1. Collect IDs into a Set before the loop
   2. Run one SOQL query with WHERE Id IN :ids
   3. Store results in a Map and read from it inside the loop
   Did this fix it? Yes No

3. 3. Check recursion and other automation

   Copy steps
   1. Use a static boolean in trigger handlers to run logic once per transaction
   2. Review other Flows, Process Builders and packages on the same object
   3. Use debug logs and Limits.getQueries() to see where queries are spent
   Did this fix it? Yes No

4. 4. Test with bulk volumes

   1. Test with 200 records, not one, because the error often appears only on data loads
   Did this fix it? Yes No

Symptoms

A Flow, trigger or data load fails with System.LimitException: Too many SOQL queries: 101.

Why it happens

• Get Records inside a Flow Loop
• SOQL inside an Apex for loop
• Several automations and managed packages in one transaction share the limit
• Trigger recursion

This guide also covers

• too many soql queries 101
• salesforce flow too many soql queries
• systemlimitexception too many soql

The same problem in other apps

All not loading, error messages & connection guides →

• HubSpot Import Errors (HubSpot)
• Pipedrive Import Errors and Skipped Rows (Pipedrive)

Other Salesforce errors

• How to Cancel Salesforce Subscription
• Salesforce REQUEST_LIMIT_EXCEEDED Error
• Salesforce STORAGE_LIMIT_EXCEEDED Error
• Salesforce UNABLE_TO_LOCK_ROW Error
• Salesforce Einstein Activity Capture Not Syncing
• Salesforce Emails Not Sending
• Salesforce Data Loader INVALID_LOGIN Error
• Salesforce MFA Locked Out: Lost Authenticator