Why am I getting "AVA_SFCORE: Too many query rows: 50001" in Salesforce?

Overview

In Salesforce, you are trying to calculate tax or finalize your invoice but are getting the error "AVA_SFCORE: Too many query rows: 50001".

Environment

Salesforce

Resolution

• This error can be caused by several different issues and does not include a specific error message describing the cause.
• Please upgrade to the newest version of the Avalara AvaTax for SalesForce package(s) to receive a specific error so that further troubleshooting can be completed.
  • By upgrading you will have access to the many other enhancements, please see Avalara AvaTax for Salesforce Release Notes for details
  • Once the upgrade is complete you will receive an error describing the cause of the issue, like a product name that is too long, trying to re-save a locked document, ar trying to use a bad address. Seeing the error message will enable you to fix the issue in the individual transaction, invoice, customer address, etc.

• Upgrade to version:

  • AvaTax For Salesforce SDK v13.67.0 or later (Access the SOAP download here)

  • AvaTax for SalesForce Opportunity Release v5.26.0.0 or later

    • Customize the SF Workflow Rule and Triggers in order to use the Automatic Tax Calculation feature