When I run following query in dataloader/workbench, I receive the below error.

SELECT Count(Id) FROM Account
where recordtype.name = 'Client'

EXCEEDED_ID_LIMIT: Aggregate query does not support queryMore(), use LIMIT to restrict the results to a single batch

How can I work around this issue?

  • 1
    This is an oft encountered and easily searchable error...That said, I believe you should be able to export a summary report to get the same data. – Adrian Larson Mar 16 '17 at 17:08
  • Thanks Adrain for quick reply, i searched and got something to apply is offset like SELECT Count(Id), SIC_Code__c FROM Account where recordtype.name = 'Client' Group By SIC_Code__c offet 10..but it is returning only 200 records, any idea why it is returning only 200 – David Mycka Mar 16 '17 at 17:13
  • 1
    dataloader default batch size is 200 – Santanu Boral Mar 16 '17 at 17:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.