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
-
-