Hello,

I'm beginner with apex and SOQL and I recently have problem with "Too many query rows: 50001" exception.
I thought this exception occurs when the SOQL query returns more than 50000 rows.
I have a class with 4 query but 2 of then cause the problem. The first query counts the number of products sold and group it by owner for each type of product: number of owner = 10, number of product = 10; total query = 10, total rows = 100
The second query counts the number of products sold and group it by month for each owner (center.name): number of month = 12, number of owner = 10; total query = 10, total rows = 120

NOTE: Total of number products sold is more than 50000. See bellow my requests:

//Get sales per stove type at each center
    	for (String stoveType : STOVE_TYPES) {
	    	AggregateResult[] centerNbSales = [SELECT owner.userRole.name salesCenterName, count(id) nbSales FROM Sale__c 
				WHERE Stove__r.Type__c LIKE :stoveType AND CALENDAR_YEAR(Date_of_Sale_real__c) =: System.today().Year() 
				GROUP BY owner.userRole.name];
			
			//Initialize the map with center name and sales = 0
			tmpCenterNbSalesMap = new Map<String, Integer>();
			for(String cName : centerName) tmpCenterNbSalesMap.put(cName, 0);
				
			for (AggregateResult ag : centerNbSales) tmpCenterNbSalesMap.put((String)ag.get('salesCenterName'), (Integer)ag.get('nbSales'));
			
			//Put the number sold stoves for each center for the current stove type
			salesStoveTypeMap.put(stoveType, tmpCenterNbSalesMap);
    	}

//Get the number of direct sales per month
AggregateResult[] tmpDateOfSalesList = [SELECT CALENDAR_MONTH(Date_of_Sale_Real__c) month, count(ID) nbSales FROM Sale__c
                                          WHERE CALENDAR_YEAR(Date_of_Sale_Real__c) = :year
                                          AND Stove__r.Selling_Center_3__c = :center.Name
                                          GROUP BY CALENDAR_MONTH(Date_of_Sale_Real__c)];

Please clarify me if I misunderstand the meaning of the "Too many query rows: 50001" exception and any help would be welcome.
(the class contains 700 lines but I can post it if necessary)

Thanks in advance.