You need to sign in to do that
Don't have an account?
sandy sfdc
Apex script unhandled trigger exception by user/organization
Hi All,
I got the below runtime error,please suggest on this.
Apex script unhandled trigger exception by user/organization: 00570000004Tasp/00D900000008xzp
Opportunitytrigger: execution of BeforeUpdate
caused by: System.QueryException: List has no rows for assignment to SObject
Trigger.Opportunitytrigger: line 3, column 1
My Trigger Code is like:
trigger OpportunityTrigger on Opportunity(before insert,before update,after insert , after update , before delete)
{
User validuser=[select Namespace.Active__c,Namespace.Pset__c,Namespace.code__c from User where Id=:UserInfo.getUserId()];
if(validuser.Namespace.Active__c==true && validuser.Namespace.Pset__c==true && validuser.Namespace.code__c!=null)
{
//code
}
I got the below runtime error,please suggest on this.
Apex script unhandled trigger exception by user/organization: 00570000004Tasp/00D900000008xzp
Opportunitytrigger: execution of BeforeUpdate
caused by: System.QueryException: List has no rows for assignment to SObject
Trigger.Opportunitytrigger: line 3, column 1
My Trigger Code is like:
trigger OpportunityTrigger on Opportunity(before insert,before update,after insert , after update , before delete)
{
User validuser=[select Namespace.Active__c,Namespace.Pset__c,Namespace.code__c from User where Id=:UserInfo.getUserId()];
if(validuser.Namespace.Active__c==true && validuser.Namespace.Pset__c==true && validuser.Namespace.code__c!=null)
{
//code
}
Mark as answer if you find correct.
Thanks!
All Answers
User validuser;
for(User usr : [select Namespace.Active__c,Namespace.Pset__c,Namespace.code__c from User where Id=:UserInfo.getUserId()]){
validuser = usr;
}
In my view below two possibilities are working properly.
Can u please suggest on this.
List<User> validuser=[select Namespace.Active__c,Namespace.Pset__c,Namespace.code__c from User where Id=:UserInfo.getUserId()];
if(validuser!=null && validuser.size()==1 && validuser[0].Namespace.Active__c==true && validuser[0].Namespace.Pset__c==true && validuser[0].Namespace.code__c!=null)
{
}
or
User validuser=null;
try{
User validuser=[select Namespace.Active__c,Namespace.Pset__c,Namespace.code__c from User where Id=:UserInfo.getUserId()];
}
catch(execption e){}
if(validuser.Namespace.Active__c==true && validuser.Namespace.Pset__c==true && validuser.Namespace.code__c!=null)
{
}
Mark as answer if you find correct.
Thanks!
By adding validuser!=null to if condition in 2nd solution it will be solved.