Governor limit SOQL 101 being suppressed. How?

Question

As far as I know, Governor limits can not be suppressed and will be shown to user on the UI. However I am facing below scenario where SOQL 101 limit is being logged into debug log and not being shown in the UI.

1. User converts the lead.
2. Account, Opportunity, Contact created.
3. User is successfully redirected to newly created account page.
4. All the references are correct. Like ConvertedAccountId, convertedOpptyId etc.

When I go to the Debug logs, There SOQL 101 (System.LimitException: Too many SOQL queries: 101) is being shown. If dig more in the debug logs then I found that this exception came while Opportunity Before Update trigger.

The question is, Since all this is happening in single context, then how this governor limit is not being reported to UI, and being shown only in Debug log.

has anybody felt it before ? or is this some known issue ? or I am missing something ?

Answer 1

It sounds to me like the code being executed and hitting this limit is occuring in an asychonous context. If it's in a method marked @future or in batch apex then the error would not be surfaced to the UI.

@future methods are reasonably common with lead conversion due to the way that record ownership is handled (see example use case here):

Documentation says :- " If you have a trigger set to fire when new records are created, the trigger temporarily assigns a system user as the owner of the created records. After the trigger finishes, the owner is set to the lead owner. "

Anything that you want to do in which you are involving the lead owner should be done in future class.

Answer 2

Few things keep in mind to avoid "System.LimitException: Too many SOQL queries: 101" are:

The first thing you can do is to limit you SOQL query using limit clause. For example,

select id, name from contact limit 100

We should use DML operations must be used out of the for loops and you need to use a list for the update or delete.

All the triggers fired will be counted in a single context or call. We need to ensure that total number of SOQL fired should be less than 100. In order to by pass this, you need to change your code in such a way that SOQL fired must be less than 100 or if you need to change the context then you can use @future annotation which will run the code asynchronously.

You need to make sure that the SOQL query you are using should not be inside the for loop.

There are certain best practices which you would have to follow to avoid this error (to avoid hitting governor limit).

1. http://wiki.developerforce.com/page/Best_Practice:_Avoid_SOQL_Queries_Inside_FOR_Loops

2. http://salesforcedeveloperblog.blogspot.com/2011/05/best-practices-of-triggers.html

3. http://www.salesforce.com/us/developer/docs/apexcode/Content/apex_triggers_bestpract.htm

4. http://wiki.developerforce.com/page/Apex_Code_Best_Practices

If you follow the above practices, the error will stop. Moreover there is no way wherein we in Salesforce can increase the governor limit or can stop it so best practices need to be followed.