• Oliver Rix
  • NEWBIE
  • 5 Points
  • Member since 2014

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies
Hi 

I am attempting to write a Test Class for a trigger I wrote.  However, I keep getting the following errors, "TriggerTest2.validateUpdateBedspaceWithNewNomTen(), Details: System.QueryException: List has no rows for assignment to SObject Class.TriggerTest2.validateUpdateBedspaceWithNewNomTen: line 6, column 1" and  "System.QueryException: List has no rows for assignment to SObject
Stack Trace: Class.TriggerTest2.validateUpdateBedspaceWithNewNomTen: line 6, column 1".  Can anyone help me to figure out where I've gone wrong?

@isTest
Private class TriggerTest2 {
   
    static testMethod void validateUpdateBedspaceWithNewNomTen() {
     
      String rtBed = [SELECT Id FROM RecordType WHERE DeveloperName = 'Bedspace' AND SobjectType = 'Bedspace__c' LIMIT 1].Id;
      Bedspace__c ref = new Bedspace__c(Scheme__c = 'a052000000Hcpg2', RecordTypeId = rtBed); 
    insert ref;
     
      ref = [SELECT Id, Current_nomination_tenancy__c FROM Bedspace__c WHERE Id =:ref.Id];
     
      String rtNom = [SELECT Id FROM RecordType WHERE DeveloperName = 'Nomination_Tenancy' AND SobjectType = 'Nomination_Tenancy__c' LIMIT 1].Id;
      Nomination_Tenancy__c ra = new Nomination_Tenancy__c(Bedspace__c = ref.Id, Client__c = 'a052000000Hcpg2', RecordTypeId = rtNom); 
    insert ra;
   
    ref = [SELECT Id, Current_nomination_tenancy__c FROM Bedspace__c WHERE Id =:ref.Id];
   
    System.assertEquals(ref.Current_nomination_tenancy__c, ra.Id);
    } 

}

Many Thanks,

Mike