Getting apex error: 'RollupFullBatchRecalculator' for job id '7073C000034XqRD' : expecting a right parentheses, found 'AND'

jamessimone / apex-rollup

Fast, configurable, elastically scaling custom rollup solution. Apex Invocable action, one-liner Apex trigger/CMDT-driven logic, and scheduled Apex-ready.

MIT License

210 stars 30 forks source link

Getting apex error: 'RollupFullBatchRecalculator' for job id '7073C000034XqRD' : expecting a right parentheses, found 'AND' #492

Closed baobao917 closed 12 months ago

baobao917 commented 12 months ago

I have been receiving these error messages fairly consistently and not sure what is the cause. None of my rollups have an "AND" in the WHERE clause statement.

jamessimone commented 12 months ago

This should be cleared by following the advice in #491

baobao917 commented 12 months ago

Thanks! No longer receiving the error message. I wasn't aware that it made a difference that I structure my WHERE clause as:

AcctSeedAgec IN ('0-Current', '1-30 Days', '31-60 Days')

AcctSeedAgec='0-Current' OR AcctSeedAgec='1-30 Days' OR AcctSeedAgec='31-60 Days' (This is how it was written in DLRS so that's what I used)