sfdc-SupportDevelopment / npsp

Automatically exported from code.google.com/p/npsp
0 stars 0 forks source link

Aggregate query does not support queryMore() #218

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1.  Batch rollups with multiple queryMore statements for the aggregate, see 
error text below:

Apex script unhandled exception by user/organization: 
xxxxxxxxxxxxxx/00D4000000092z3

Failed to process batch for class 'npo02.BATCH_OppRollup' for job id 
'707400000031Sp9'

caused by: System.UnexpectedException: Aggregate query does not support 
queryMore(), use LIMIT to restrict the results to a single batch

Class.npo02.OpportunityRollups.rollupContacts: line 512, column 4
Class.npo02.OpportunityRollups.rollupHouseholds: line 290, column 4
Class.npo02.BATCH_OppRollup.execute: line 23, column 4
External entry point

Original issue reported on code.google.com by kbro...@gmail.com on 11 Jan 2011 at 11:15

GoogleCodeExporter commented 9 years ago
Some syntax to try from jhersh:

for( aggregateresult[] arSet : database.query(soql) )

Original comment by kbro...@gmail.com on 11 Jan 2011 at 11:41

GoogleCodeExporter commented 9 years ago
A fix is ready to be deployed, pending release 2.0.9

Original comment by kbro...@gmail.com on 11 Feb 2011 at 10:39

GoogleCodeExporter commented 9 years ago

Original comment by kbro...@gmail.com on 13 Feb 2011 at 2:54

GoogleCodeExporter commented 9 years ago

Original comment by kbro...@gmail.com on 13 Feb 2011 at 2:57

GoogleCodeExporter commented 9 years ago

Original comment by kbro...@gmail.com on 22 Feb 2011 at 7:19