[SalesForce] How to resolve the LimitException

for(PricebookEntry pbe:[Select product2Id from PricebookEntry where PriceBook2Id = :pbId]){
            productIds.add(pbe.product2Id);
        }

I am getting the following exception.

System.LimitException: Too many query rows: 50001
An unexpected error has occurred. Your solution provider has been notified. (Database).

It should process the records in batch why am i getting the above error?

Best Answer

Even if you are executing in batch please note that the execute class still holds all the governor limits .Only the Object which is queried in Database.QueryLocator gets chunked while processing .The query in constructor or the start method or your scope is prevented from query limit .If you have 50000 pricebook entry for PriceBook then query will fail.

Related Solutions

[SalesForce] How does salesforce notify the solution provider in the error message “Your Solution Provider has been notified”

As manjit-singh said in comments:

While creating the packages, Salesforce asks you to SELECT a user for notify on error field. An email is sent to that email address. The details about the email format are given here: https://help.salesforce.com/apex/HTViewHelpDoc?id=code_handling_managed_errors.htm&language=en_US

[SalesForce] get a DisjunctionsNotSupportedException when doing a SOQL query on Custom Metadata

Custom Metadata supports a limited SOQL syntax, and "OR" statements are not supported. From the documentation:

Custom metadata types support the following SOQL query syntax.

SELECT fieldList [...]
FROM objectType
    [USING SCOPE filterScope]
[WHERE conditionExpression]
[ORDER BY field {ASC|DESC} [NULLS {FIRST|LAST}] ]

The fieldList can include only non-relationship fields.

FROM can include only one object.

You can’t use COUNT with custom metadata types.

You can use the following operators.

IN and NOT IN

=, >, >=, <, <=, and !=

LIKE, including wild cards

AND

You can use ORDER BY, ASC, and DESC with multiple fields.

Notice that "OR" is not supported. Apparently that's called a "Disjunction"

Best Answer

Related Solutions

[SalesForce] How does salesforce notify the solution provider in the error message “Your Solution Provider has been notified”

[SalesForce] get a DisjunctionsNotSupportedException when doing a SOQL query on Custom Metadata

Related Topic