System.Query Exception: List has no rows for assignment to s-object?

Hi,

The exception is because of you are not getting any record in your SOQL query which meet the where criteria so it's give error. When attempting to fetch a single record from the database it is easy to run into the above exception. To avoid such exception use try-catch box like below :

MyObject__c obj;

try{

obj = [SELECT id FROM MyObject__c WHERE name=:previouslyDefinedVar];

} catch(System.QueryException e){

// Perform logic here

}

Hope this helps!

Hello Prachi,

Well, this type of error shown when your SOQL didn't return any results. You can wrap it in a try/catch statement to handle this gracefully.

For more information, kindly share your code.

Thanks.