+ Start a Discussion
Developer_shaanDeveloper_shaan 

exception while retrieving user records

Hi,

I have a query retrieving the userinfo from user in a trigger.

 

Here i am retrieving a custom field from  user object.

Below is the query: 

 

String userid= userinfo.getUserId();


User[] userType = [select u.custom__c from User u where u.Id=:userid limit 1];

 

the exception is:

Apex script unhandled trigger exception by user/organization: 00540000001RUm8/00D300000001EBY caused by: System.Exception: Too many SOQL queries: 21

 

can anyone whats wrong eith the query to avoid gov limits.

_Prasu__Prasu_

Exception is not for that particular query. Its due to governer limits.

Total number of SOQL queries allowed in one context run of trigger is 20.

And as that query on user is 21 its throwing exception.

Developer_shaanDeveloper_shaan

so how can we avoid this? because i am not able to pass the ids to set.

 

Let me know if any soln.

Shaan

dwwrightdwwright

Can you post your code? Difficult to optimize it if we can't see it =)