Skip to main content
CRUSH19_Logo_HelpCenter@2x.png
Learn to master tax compliance trends at CRUSH19 - Save $400 when you register by February 28!
Avalara Help Center

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

  1. Last updated
  2. Save as PDF

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: