I've inherited a series of Visualforce pages and up until yesterday they were working but now all of a sudden I'm getting the following error:
Too many query rows: 50001
An unexpected error has occurred. Your development organization has been notified.
I've used the Developer Console and it's pin pointed the FATAL_ERROR in the Execution Log to the following method:
global class mForceSupportCustCaseRptGeneratorCtrl {
String customerID;
String reportMonth;
String reportYear;
public PageReference generateReport() {
PageReference reportPage = Page.mForceSupportCustCaseReport;
reportPage.setRedirect(true);
reportPage .getParameters().put('m', reportMonth);
reportPage .getParameters().put('y', reportYear);
reportPage .getParameters().put('acc', customerID);
return reportPage ;
}
public List<SelectOption> getListcustomeroptions() {
List<AggregateResult> customerlist = [Select Account.Name accname, Accountid , count(createddate) FROM Case group by Account.Name, Accountid order by Account.Name limit 25000];
List<SelectOption> options = new List<SelectOption>();
Map<string,string> accountmap = new Map<string,string>();
for (AggregateResult ar : customerlist ) {
if (ar.get('expr0')!=null && ar.get('accname')!= null)
accountmap.put(string.valueof(ar.get('Accountid')),string.valueof(ar.get('accname')));
}
for(String accid: accountmap.keyset()) {
options.add(new SelectOption(accid, accountmap.get(accid)));
}
return QuickSort.sortOptionList(options);
}
public String getCustomerID() {
return customerID;
}
public void setCustomerID(String customerID) {
this.customerID = customerID;
}
public List<SelectOption> getlistmonthoptions() {
List<SelectOption> options = new List<SelectOption>();
options.add(new SelectOption('1', 'January'));
options.add(new SelectOption('2', 'February'));
options.add(new SelectOption('3','March'));
options.add(new SelectOption('4','April'));
options.add(new SelectOption('5','May'));
options.add(new SelectOption('6','June'));
options.add(new SelectOption('7','July'));
options.add(new SelectOption('8','August'));
options.add(new SelectOption('9','September'));
options.add(new SelectOption('10','October'));
options.add(new SelectOption('11','November'));
options.add(new SelectOption('12','December'));
return options;
}
public String getReportMonth() {
return reportMonth;
}
public void setReportMonth(String reportMonth) {
this.reportMonth= reportMonth;
}
public List<SelectOption> getlistyearoptions() {
//List<AggregateResult> minmaxdates = [Select MIN(createddate) mindate, MAX(createddate) maxdate FROM Case limit 25000];
//Integer minyear = datetime.valueof(minmaxdates.get(0).get('mindate')).year();
//Integer maxyear = datetime.valueof(minmaxdates.get(0).get('maxdate')).year();
List<SelectOption> options = new List<SelectOption>();
for (Integer i = datetime.now().year() ; i>= 2009 ;i--) {
options.add(new SelectOption(string.valueof(i),string.valueof(i)));
}
return options;
}
public String getReportYear() {
return reportMonth;
}
public void setReportYear (String reportYear) {
this.reportYear= reportYear;
}
}
Looking at the Execution Log within the Developer Console I can see the (one and only) SOQL statement in the method being executed:
List<AggregateResult> customerlist = [Select Account.Name accname, Accountid , count(createddate) FROM Case group by Account.Name, Accountid order by Account.Name limit 25000];
This obviously has the "limit" keyword on it so should be limiting the resultset, plus in the Developer Console I can see SOQL_EXECUTE_END [18] Rows:105
So I'm more than a little confused as to why it thinks the limit has been exceeded and any help would be much appreciated.
I've inherited a series of Visualforce pages and up until yesterday they were working but now all of a sudden I'm getting the following error:
Too many query rows: 50001
An unexpected error has occurred. Your development organization has been notified.
I've used the Developer Console and it's pin pointed the FATAL_ERROR in the Execution Log to the following method:
global class mForceSupportCustCaseRptGeneratorCtrl {
String customerID;
String reportMonth;
String reportYear;
public PageReference generateReport() {
PageReference reportPage = Page.mForceSupportCustCaseReport;
reportPage.setRedirect(true);
reportPage .getParameters().put('m', reportMonth);
reportPage .getParameters().put('y', reportYear);
reportPage .getParameters().put('acc', customerID);
return reportPage ;
}
public List<SelectOption> getListcustomeroptions() {
List<AggregateResult> customerlist = [Select Account.Name accname, Accountid , count(createddate) FROM Case group by Account.Name, Accountid order by Account.Name limit 25000];
List<SelectOption> options = new List<SelectOption>();
Map<string,string> accountmap = new Map<string,string>();
for (AggregateResult ar : customerlist ) {
if (ar.get('expr0')!=null && ar.get('accname')!= null)
accountmap.put(string.valueof(ar.get('Accountid')),string.valueof(ar.get('accname')));
}
for(String accid: accountmap.keyset()) {
options.add(new SelectOption(accid, accountmap.get(accid)));
}
return QuickSort.sortOptionList(options);
}
public String getCustomerID() {
return customerID;
}
public void setCustomerID(String customerID) {
this.customerID = customerID;
}
public List<SelectOption> getlistmonthoptions() {
List<SelectOption> options = new List<SelectOption>();
options.add(new SelectOption('1', 'January'));
options.add(new SelectOption('2', 'February'));
options.add(new SelectOption('3','March'));
options.add(new SelectOption('4','April'));
options.add(new SelectOption('5','May'));
options.add(new SelectOption('6','June'));
options.add(new SelectOption('7','July'));
options.add(new SelectOption('8','August'));
options.add(new SelectOption('9','September'));
options.add(new SelectOption('10','October'));
options.add(new SelectOption('11','November'));
options.add(new SelectOption('12','December'));
return options;
}
public String getReportMonth() {
return reportMonth;
}
public void setReportMonth(String reportMonth) {
this.reportMonth= reportMonth;
}
public List<SelectOption> getlistyearoptions() {
//List<AggregateResult> minmaxdates = [Select MIN(createddate) mindate, MAX(createddate) maxdate FROM Case limit 25000];
//Integer minyear = datetime.valueof(minmaxdates.get(0).get('mindate')).year();
//Integer maxyear = datetime.valueof(minmaxdates.get(0).get('maxdate')).year();
List<SelectOption> options = new List<SelectOption>();
for (Integer i = datetime.now().year() ; i>= 2009 ;i--) {
options.add(new SelectOption(string.valueof(i),string.valueof(i)));
}
return options;
}
public String getReportYear() {
return reportMonth;
}
public void setReportYear (String reportYear) {
this.reportYear= reportYear;
}
}
Looking at the Execution Log within the Developer Console I can see the (one and only) SOQL statement in the method being executed:
List<AggregateResult> customerlist = [Select Account.Name accname, Accountid , count(createddate) FROM Case group by Account.Name, Accountid order by Account.Name limit 25000];
This obviously has the "limit" keyword on it so should be limiting the resultset, plus in the Developer Console I can see SOQL_EXECUTE_END [18] Rows:105
So I'm more than a little confused as to why it thinks the limit has been exceeded and any help would be much appreciated.
