VinceFINET
commented
4 days ago Thank you for this tcket. I can reproduce it when doing the following in an org that has a lot of apex classes:
SELECT count(Id) FROM apexclass
gives me 3501 --> ok
SELECT Id FROM apexclass limit 2000 offset 0
gives me 2000 records --> good!
SELECT Id FROM apexclass limit 2000 offset 2000
gives me 1501 records --> good!
2000 + 1501 = 3501 --> logical and good!
BUT
if i do (and it does not make any sense i know)
SELECT Id FROM apexclass limit 2000 offset 4000
gives me the same error as you.
Now I need to understand why the app is trying to gather more records than it should in your org.
as a start, could you @JainySilva perform the query SELECT count(Id) FROM apexclass and put the result here please?
JainySilva
What: When accessing the Apex tab is shown the bellow errors and the Apex classes analyses isn't executed.
Steps to Reproduce: App Launcher -> choose app "Org Check" -> tab "Home" -> access internal tab "Apex".
Errors:
TAB apex-classes NUMBER_OUTSIDE_VALID_RANGE: Maximum SOQL offset allowed for apiName ApexClass is 2000
NUMBER_OUTSIDE_VALID_RANGE: Maximum SOQL offset allowed for apiName ApexClass is 2000 at r.getError (https://sandboxurl--orgcheck.sandbox.vf.force.com/resource/1727095983000/orgcheck__OrgCheck_SR/js/jsforce.js:1:72641) at eval (https://sandboxurl--orgcheck.sandbox.vf.force.com/resource/1727095983000/orgcheck__OrgCheck_SR/js/jsforce.js:1:71009) at eval (https://sandboxurl--orgcheck.sandbox.vf.force.com/resource/1727095983000/orgcheck__OrgCheck_SR/js/jsforce.js:1:229493) at eval (https://sandboxurl--orgcheck.sandbox.vf.force.com/resource/1727095983000/orgcheck__OrgCheck_SR/js/jsforce.js:1:229521) at o (https://sandboxurl--orgcheck.sandbox.vf.force.com/resource/1727095983000/orgcheck__OrgCheck_SR/js/jsforce.js:1:104504) at MutationObserver. (https://static.lightning.force.com/bra4s.sfdc-xwy4ub/auraFW/javascript/eGx3MHlRT1lEMUpQaWVxbGRUM1h0Z2hZX25NdHFVdGpDN3BnWlROY1ZGT3cyNTAuOC40LTYuNC41/aura_prod.js:92:91749)
at e. (https://static.lightning.force.com/bra4s.sfdc-xwy4ub/auraFW/javascript/eGx3MHlRT1lEMUpQaWVxbGRUM1h0Z2hZX25NdHFVdGpDN3BnWlROY1ZGT3cyNTAuOC40LTYuNC41/aura_prod.js:46:4694)
RECIPE apex-classes Error in dataset!
DATASET apex-classes NUMBER_OUTSIDE_VALID_RANGE: Maximum SOQL offset allowed for apiName ApexClass is 2000
NUMBER_OUTSIDE_VALID_RANGE: Maximum SOQL offset allowed for apiName ApexClass is 2000 at r.getError (https://sandboxurl--orgcheck.sandbox.vf.force.com/resource/1727095983000/orgcheck__OrgCheck_SR/js/jsforce.js:1:72641) at eval (https://sandboxurl--orgcheck.sandbox.vf.force.com/resource/1727095983000/orgcheck__OrgCheck_SR/js/jsforce.js:1:71009) at eval (https://sandboxurl--orgcheck.sandbox.vf.force.com/resource/1727095983000/orgcheck__OrgCheck_SR/js/jsforce.js:1:229493) at eval (https://sandboxurl--orgcheck.sandbox.vf.force.com/resource/1727095983000/orgcheck__OrgCheck_SR/js/jsforce.js:1:229521) at o (https://sandboxurl
--orgcheck.sandbox.vf.force.com/resource/1727095983000/orgcheck__OrgCheck_SR/js/jsforce.js:1:104504)
at MutationObserver. (https://static.lightning.force.com/bra4s.sfdc-xwy4ub/auraFW/javascript/eGx3MHlRT1lEMUpQaWVxbGRUM1h0Z2hZX25NdHFVdGpDN3BnWlROY1ZGT3cyNTAuOC40LTYuNC41/aura_prod.js:92:91749)
at e. (https://static.lightning.force.com/bra4s.sfdc-xwy4ub/auraFW/javascript/eGx3MHlRT1lEMUpQaWVxbGRUM1h0Z2hZX25NdHFVdGpDN3BnWlROY1ZGT3cyNTAuOC40LTYuNC41/aura_prod.js:46:4694)