How to: solve “Too many SOQL queries: 101” within AddressTools

AddressTools’ triggers handle the standardization, validation, and some elements of verification in a Salesforce organization where the solution is configured.

To guarantee that the solution does what it is designed to do, the functionality invoked by the trigger is designed to be recursive to guarantee it is the last operation in the transaction. This ensures that if there are any other processes executing that touch the address data during the transaction, AddressTools will reinvoke against the data in the record.

A side effect of this behaviour is that for some orgs, “Too many SOQL queries: 101” can occur during an insert or update operation, more commonly during mass operations or organization with lots of processes executing on the upsert operation.

To disable the looping behaviour, follow the steps below:

  • Go to App Launcher | AddressTools Administration.
  • Select the Settings sub-tab and scroll down to Trigger Settings.
  • Click the pencil next to the Run Trigger Only Once setting.
  • Tick the box to enable this setting.
  • Select Save.

If you are still experiencing issues and need assistance, contact

What is AddressTools?

We’re glad you asked! AddressTools is our 5* app for Salesforce which takes the worry out of bad address data by keeping all of your addresses validated, verified, corrected, and standardized. Like the sound of it? Try it for yourself on the AppExchange!

Leave a Reply