You need to sign in to do that
Don't have an account?
![Gage Staruch 9 Gage Staruch 9](https://dfc-org-production.my.site.com/img/userprofile/default_profile_45_v2.png)
System.QueryException: List has no rows for assignment to SObject error
I'm not quite sure what I'm doing wrong. Any help is appreciated!
I keep getting this error: System.QueryException: List has no rows for assignment to SObject
My trigger:
trigger ActiveAccount on Account (before insert, before update, after insert) { for(account a: trigger.new) { if (a.Active_Orchestrate_Platform__c == True || a.cb1 == True || a.cb2 == True || a.cb3 == True || a.cb4 == True || a.cb5 == True) { a.cb6 = True; } } }
My test Class:
@isTest private class ActiveAccountTest{ static testmethod void validateActiveAccount() { // Create your test data Account acc = new Account(); acc.name= 'test'; insert acc; Opportunity oppObj = new Opportunity(Name = 'TestOpp',AccountID = acc.Id,Amount = 2000,CloseDate=Date.today(),StageName='A - Purchase / Close Won', MarketingGeneratedType__c = 'Sales'); insert oppObj; Product2 newProd = new Product2 (Name = 'Product ABC', ProductLine__c ='ABC Products'); insert newProd; ID lstpbe = [SELECT Product2.Id, Product2.Name FROM PriceBookEntry WHERE Pricebook2Id IN (SELECT Id FROM PriceBook2 WHERE Name = 'ABC Products')].id; PriceBookEntry pbEntry = new PriceBookEntry( UnitPrice = 1, Product2Id = lstpbe, IsActive = true); insert pbEntry ; OpportunityLineItem oppLine = new OpportunityLineItem(pricebookentryid=pbEntry.Id,TotalPrice=2000,Quantity = 1,OpportunityID = oppObj.Id); insert oppLine; Test.startTest(); Account acct4 = [Select cb6 from Account limit 1]; Test.stopTest(); } }
Greetings!
This error occurs whenever we try to access an empty list.So,can you please check if the below SOQL query is returning any records:
SELECT Product2.Id, Product2.Name FROM PriceBookEntry WHERE Pricebook2Id IN (SELECT Id FROM PriceBook2 WHERE Name = 'ABC Products'
Please follow the below document for more details on troubleshooting the issue.
https://help.salesforce.com/HTViewSolution?id=000159853
Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future.
Warm Regards,
Shirisha Pathuri
I should have probably specified, the list isnt empty. It actually returns 1 record, which is exactly the record ID that I need.
Can you please try by printing the value for lstpbe by adding the system.debug() statement in the class to confirm,if it has any value.
Also,I can see that you are trying to store the Id in one variable.So,can you please follow the below approach to proceed further.
https://developer.salesforce.com/forums/?id=906F00000008oGJIAY
Thanks&Regards,
Shirisha Pathuri
@Shirisha,
When I tired to print the value for lstpbe, I got this error:
System.QueryException: List has more than 1 row for assignment to SObject
1) ID lstpbe = [SELECT Product2.Id, Product2.Name FROM PriceBookEntry WHERE Pricebook2Id IN (SELECT Id FROM PriceBook2 WHERE Name = 'ABC Products') LIMIT 1].Id
2) ID lstpbe = [SELECT Product2.Id, Product2.Name FROM PriceBookEntry WHERE Pricebook2Id IN (SELECT Id FROM PriceBook2 WHERE Name = 'ABC Products')][0].Id
Hi @Agustin,
Thank you for your comment. It looks like I am still having this issue. Below is the updated code