test class issue: List has no row

Getting error "List has no rows for assignment to SObject"

Line kept bold below...Please suggest.

apex class:
public class PopUpExtension{

public Milestone1_Project__c Project {get;set;}
public Milestone1_Project__c ProjectGetData {get;set;}
public List<Milestone1_Milestone__c> milestones {get;set;}
public List<Milestone1_Task__c> milestonesTasks {get;set;}
public boolean ErrorFound {get;set;}

public PopUpExtension(ApexPages.StandardController stdController){
   ErrorFound = false;
Project = new Milestone1_Project__c();
this.Project = (Milestone1_Project__c)stdCOntroller.getRecord();
milestones = new List<Milestone1_Milestone__c>();
milestonesTasks = new List<Milestone1_Task__c>();
}

public void UpdateEstimatedDates() {
try{
   ErrorFound = false;
   Date EstimatedStartDate;
   Map<id,Milestone1_Milestone__c> MilestonesMap = new Map<id,Milestone1_Milestone__c>();
       ProjectGetData = [select Start_Day__c,Project_Duration__c,Kickoff__c,Deadline__c from Milestone1_Project__c where Duration__c !=null and Start_Day__c !=null and id = :Project.id];
   system.debug('ProjectGetData:'+ProjectGetData);
   if(Project.Kickoff__c != null){
       ProjectGetData.Kickoff__c = Project.Kickoff__c;
           if(ProjectGetData.Start_Day__c != null && ProjectGetData.Project_Duration__c != null){
               EstimatedStartDate = Date.valueOf(Project.Kickoff__c).addDays((integer)ProjectGetData.Start_Day__c)-1;
               ProjectGetData.Deadline__c = EstimatedStartDate.addDays((integer)ProjectGetData.Project_Duration__c);
               system.debug('ProjectGetData1:'+ProjectGetData);
           }else{
               ApexPages.Message myMsg = new ApexPages.Message(ApexPages.Severity.ERROR,'Please provide project Start Day and Project Duration.');
           ApexPages.addMessage(myMsg);
           ErrorFound = true;
           }
           update ProjectGetData;
   }else{
       ApexPages.Message myMsg = new ApexPages.Message(ApexPages.Severity.ERROR,'Please provide project Estimated Start Date or close the window.');
       ApexPages.addMessage(myMsg);
       ErrorFound = true;
       return;
   }

   milestones = [Select id,m.Start_Day__c, m.Project__c, m.Kickoff__c, m.Estimated_End_Date__c, m.Milestone_Duration__c From Milestone1_Milestone__c m where Start_Day__c !=null and Duration__c !=null and m.Project__c = :Project.id];
   for(Milestone1_Milestone__c milestone : milestones){
       milestone.Kickoff__c = EstimatedStartDate.addDays((integer)milestone.Start_Day__c);
           milestone.Estimated_End_Date__c = Date.valueOf(milestone.Kickoff__c).addDays((integer)milestone.Milestone_Duration__c)-1;
       if(milestone.Estimated_End_Date__c > ProjectGetData.Deadline__c){
           ApexPages.Message myMsg = new ApexPages.Message(ApexPages.Severity.ERROR,'Milesone Estimated End date is greater than Project Estimated End Date');
       ApexPages.addMessage(myMsg);
       ErrorFound = true;
       }
       MilestonesMap.put(milestone.id,milestone);
   }
   update milestones;

   milestonesTasks = [Select m.Task_Duration__c,m.Project_Milestone__c, m.Start_Day__c, m.Start_Date__c, m.Estimated_End_Date__c From Milestone1_Task__c m where Start_Day__c !=null and Task_Duration__c !=null and m.Project_Milestone__c = :MilestonesMap.keyset()];
for(Milestone1_Task__c task : milestonesTasks){
   Milestone1_Milestone__c milestone = MilestonesMap.get(task.Project_Milestone__c);
   task.Start_Date__c = (date)milestone.Kickoff__c.addDays((integer)task.Start_Day__c);
           task.Estimated_End_Date__c = Date.valueOf(task.Start_Date__c).addDays((integer)task.Task_Duration__c)-1;

           if(task.Estimated_End_Date__c > ProjectGetData.Deadline__c){
           ApexPages.Message myMsg = new ApexPages.Message(ApexPages.Severity.ERROR,'Tasks Estimated End date is greater than Project Estimated End Date');
       ApexPages.addMessage(myMsg);
       ErrorFound = true;
       }
       if(task.Estimated_End_Date__c > milestone.Estimated_End_Date__c){
           ApexPages.Message myMsg = new ApexPages.Message(ApexPages.Severity.ERROR,'Tasks Estimated End date is greater than Milestone Estimated End Date');
       ApexPages.addMessage(myMsg);
       ErrorFound = true;
       }
}
update milestonesTasks;

}catch(exception e) {
ApexPages.Message myMsg = new ApexPages.Message(ApexPages.Severity.ERROR,'Error Occured while updating the Projects/Milestones/Tasks '+e.getMessage());
ApexPages.addMessage(myMsg);
ErrorFound = true;
}
}
}

test class:

@isTest
private class TestPopUpExtension {

static testMethod void functionalTest() {

Milestone1_Project__c Project = new Milestone1_Project__c();
Project.Name = 'Test1';
Project.Kickoff__c = date.today();
Project.Start_Day__c = 1;
Project.Project_Duration__c = 200;
insert Project;

Milestone1_Milestone__c Milestone = new Milestone1_Milestone__c();
Milestone.Name = 'Test1';
Milestone.Start_Day__c = 1;
Milestone.Milestone_Duration__c = 3;
    Milestone.Project__c = Project.id;
    insert Milestone;

    Milestone1_Task__c Tasks = new Milestone1_Task__c();
    Tasks.Start_Day__c = 1;
    Tasks.Task_Duration__c = 4;
    Tasks.Project_Milestone__c = Milestone.id;
    insert Tasks;

    PageReference pageRef = Page.popupwindow;
       Test.setCurrentPageReference(pageRef);

    ApexPages.StandardController sc = new ApexPages.standardController(Project);
    PopUpExtension popext = new PopUpExtension(sc);
    popext.UpdateEstimatedDates();

}

static testMethod void ErrorTest() {

Milestone1_Project__c Project = new Milestone1_Project__c();
Project.Name = 'Test1';
Project.Kickoff__c = date.today();
Project.Start_Day__c = 1;
Project.Project_Duration__c = 2;
insert Project;

Milestone1_Milestone__c Milestone = new Milestone1_Milestone__c();
Milestone.Name = 'Test1';
Milestone.Start_Day__c = 1;
Milestone.Milestone_Duration__c = 3;
    Milestone.Project__c = Project.id;
    insert Milestone;

    Milestone1_Task__c Tasks = new Milestone1_Task__c();
    Tasks.Start_Day__c = 1;
    Tasks.Task_Duration__c = 4;
    Tasks.Project_Milestone__c = Milestone.id;
    insert Tasks;

    PageReference pageRef = Page.popupwindow;
       Test.setCurrentPageReference(pageRef);

    ApexPages.StandardController sc = new ApexPages.standardController(Project);
    PopUpExtension popext = new PopUpExtension(sc);
    popext.UpdateEstimatedDates();

}
}

April 5, 2016
·
Answer
·
Like
0
·
Follow
2

Amit Chaudhary 8
Please pass the duration__c field value in Milestone1_Project__c and Milestone1_Milestone__c cutom object.
try below code.
@isTest private class TestPopUpExtension { static testMethod void functionalTest() { Milestone1_Project__c Project = new Milestone1_Project__c(); Project.Name = 'Test1'; Project.Duration__c =1; Project.Kickoff__c = date.today(); Project.Start_Day__c = 1; Project.Project_Duration__c = 200; insert Project; Milestone1_Milestone__c Milestone = new Milestone1_Milestone__c(); Milestone.Name = 'Test1'; Milestone.Duration__c =1; Milestone.Start_Day__c = 1; Milestone.Milestone_Duration__c = 3; Milestone.Project__c = Project.id; insert Milestone; Milestone1_Task__c Tasks = new Milestone1_Task__c(); Tasks.Start_Day__c = 1; Tasks.Task_Duration__c = 4; Tasks.Project_Milestone__c = Milestone.id; insert Tasks; PageReference pageRef = Page.popupwindow; Test.setCurrentPageReference(pageRef); ApexPages.StandardController sc = new ApexPages.standardController(Project); PopUpExtension popext = new PopUpExtension(sc); popext.UpdateEstimatedDates(); } static testMethod void ErrorTest() { Milestone1_Project__c Project = new Milestone1_Project__c(); Project.Name = 'Test1'; Project.Duration__c =1; Project.Kickoff__c = date.today(); Project.Start_Day__c = 1; Project.Project_Duration__c = 2; insert Project; Milestone1_Milestone__c Milestone = new Milestone1_Milestone__c(); Milestone.Name = 'Test1'; Milestone.Start_Day__c = 1; Milestone.Milestone_Duration__c = 3; Milestone.Duration__c =1; Milestone.Project__c = Project.id; insert Milestone; Milestone1_Task__c Tasks = new Milestone1_Task__c(); Tasks.Start_Day__c = 1; Tasks.Task_Duration__c = 4; Tasks.Project_Milestone__c = Milestone.id; insert Tasks; PageReference pageRef = Page.popupwindow; Test.setCurrentPageReference(pageRef); ApexPages.StandardController sc = new ApexPages.standardController(Project); PopUpExtension popext = new PopUpExtension(sc); popext.UpdateEstimatedDates(); } }
Please check below post for test classes.
1) http://amitsalesforce.blogspot.in/search/label/Test%20Class
2) http://amitsalesforce.blogspot.in/2015/06/best-practice-for-test-classes-sample.html

Please follow below salesforce Best Practice for Test Classes :-

1. Test class must start with @isTest annotation if class class version is more than 25
2. Test environment support @testVisible , @testSetUp as well
3. Unit test is to test particular piece of code working properly or not .
4. Unit test method takes no argument ,commit no data to database ,send no email ,flagged with testMethod keyword .
5. To deploy to production at-least 75% code coverage is required
6. System.debug statement are not counted as a part of apex code limit.
7. Test method and test classes are not counted as a part of code limit
9. We should not focus on the percentage of code coverage ,we should make sure that every use case should covered including positive, negative,bulk and single record .
Single Action -To verify that the the single record produces the correct an expected result .
Bulk action -Any apex record trigger ,class or extension must be invoked for 1-200 records .
Positive behavior : Test every expected behavior occurs through every expected permutation , i,e user filled out every correctly data and not go past the limit .
Negative Testcase :-Not to add future date , Not to specify negative amount.
Restricted User :-Test whether a user with restricted access used in your code .
10. Test class should be annotated with @isTest .
11 . @isTest annotation with test method is equivalent to testMethod keyword .
12. Test method should static and no void return type .
13. Test class and method default access is private ,no matter to add access specifier .
14. classes with @isTest annotation can't be a interface or enum .
15. Test method code can't be invoked by non test request .
16. Stating with salesforce API 28.0 test method can not reside inside non test classes .
17. @Testvisible annotation to make visible private methods inside test classes.
18. Test method can not be used to test web-service call out . Please use call out mock .
19. You can't send email from test method.
20.User, profile, organization, AsyncApexjob, Corntrigger, RecordType, ApexClass, ApexComponent ,ApexPage we can access without (seeAllData=true) .
21. SeeAllData=true will not work for API 23 version eailer .
22. Accessing static resource test records in test class e,g List<Account> accList=Test.loadData(Account,SobjectType,'ResourceName').
23. Create TestFactory class with @isTest annotation to exclude from organization code size limit .
24. @testSetup to create test records once in a method and use in every test method in the test class .
25. We can run unit test by using Salesforce Standard UI,Force.com IDE ,Console ,API.
26. Maximum number of test classes run per 24 hour of period is not grater of 500 or 10 multiplication of test classes of your organization.
27. As apex runs in system mode so the permission and record sharing are not taken into account . So we need to use system.runAs to enforce record sharing .
28. System.runAs will not enforce user permission or field level permission .
29. Every test to runAs count against the total number of DML issued in the process .

Please let us know if this post will help you

Thanks
Amit Chaudhary

April 5, 2016
·
Like
1
·
Dislike
0

Anand Kulkarni 8
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.

https://help.salesforce.com/HTViewSolution?id=000159853&language=en_US

April 5, 2016
·
Like
1
·
Dislike
0

You need to sign in to do that.

Need an account? Sign Up

Have an account? Sign In

Dismiss

Browse by Topic

Welcome to Support!

Show

sorted by

test class issue: List has no row

You need to sign in to do that.