Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Hitting SOQL Too Many Query Rows with AVERAGE #589

Closed
PhilTerz opened this issue May 9, 2024 · 2 comments · Fixed by #592
Closed

Hitting SOQL Too Many Query Rows with AVERAGE #589

PhilTerz opened this issue May 9, 2024 · 2 comments · Fixed by #592

Comments

@PhilTerz
Copy link

PhilTerz commented May 9, 2024

Over a large dataset, AVERAGE is requerying in each batch chunk handler. I can see each handler's log does a query that fails after returning 50,001 rows.
@jamessimone
Copy link
Owner

Thanks for submitting this! I should be able to start working on this today or tomorrow.

@jamessimone
Copy link
Owner

@PhilTerz apologies, I've had less time to get the fix for this out there than I had hoped for. I have things working for AVERAGE but I expect to have more time in the next day or two to sew up a few other operations that suffer from a similar issue. You can expect this fix to be released in the next few days!

jamessimone added a commit that referenced this issue May 17, 2024
@jamessimone
Fixes #589 with proper stateful tracking for batches, with the potent…
bfdd6a0 
…ial to roll this out to SUM/COUNT operations in the future as well
@jamessimone jamessimone mentioned this issue May 17, 2024
Merged
jamessimone added a commit that referenced this issue May 17, 2024
@jamessimone
v1.6.26 - Rollup Grouping support, FIRST/LAST/MOST/AVERAGE bugfixes (#…
8fa1867 
…592)

* Tidies up #587
* Creates RollupGrouping__mdt custom metadata type to allow multiple rollup operations to roll up to the same field
* Fixes #589 with proper stateful tracking for batches, with the potential to roll this out to SUM/COUNT operations in the future as well
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

v1.6.26 - Rollup Grouping support, FIRST/LAST/MOST/AVERAGE bugfixes jamessimone/apex-rollup
2 participants
@PhilTerz @jamessimone