System.QueryException: List has no rows for assignment to SObject -- on Entitlements for an existing trigger

Question

We have an old Salesforce org from which we are migrating entitlements and data to a new org. There is also a trigger for adding the entitlement by default to the case. It had 90% code coverage. But when I try to replicate it in our current sandbox to move it to production, it gives the above error.

Here are the trigger and the test class. Any help would be greatly appreciated.

 List <Entitlement> entlsAnglo = [Select e.Id
                                     From Entitlement e
                                     Where e.Name = 'Anglo - Platinum'];

  if(entlsAnglo.isEmpty()== false){
    for (Entitlement curAngloEnt : entlsAnglo){

        if (c.EntitlementId == curAngloEnt.id){

             BusinessHours AngloBusinessHours = [select Id from BusinessHours where Name = 'Brisbane Business Hours' limit 1];

             c.BusinessHoursId = AngloBusinessHours.id;

        }        
     }

  }

Test Class:

static testMethod void testtrigger2(){

  Account acc=New Account(Name='Test');
  insert acc;

    Entitlement entl = [select id from Entitlement  Where Name = 'Anglo - Platinum'limit 1];


  Contact oContact = new Contact(FirstName='Test',LastName='test2',Email='[email protected]',Accountid=acc.id,Phone='1111111111',MobilePhone='11111111111');
  insert oContact;   

  DateTime DT=DateTime.Now();

  RecordType RT=[Select id from RecordType where Name='Software Support Case' and SObjectType='Case' limit 1];

  Case c=new Case(RecordTypeID=RT.ID, Subject='test', Description='Test',Reported_At__c=DT,Responded_At__c=DT,Priority='Medium',
  ContactID=oContact .id, Status='Assigned',Origin='Web',Product_Family__c='Operations',Case_Type__c='Workshop repair/RMA',
  SlaStartDate=DT,Accountid=acc.id
  );

  insert c;


  }

Answer 1

Here are the steps to solve the issues.

1. In the test class, make @seeAllData = false, so that it will not look for existing org's data.

2. Since, this query select Id from BusinessHours where Name = 'Brisbane Business Hours' limit 1 looks for BusinessHour's name, so it must exist before running this testclass.

Otherwise, create logic as follows in the main class.

if(Test.isRunningTest()){
   String BusinessHourId = [SELECT Id FROM BusinessHours WHERE IsDefault = true];
}
else
{
   String BusinessHourId = [select Id from BusinessHours where Name = 'Brisbane Business Hours' limit 1];

}

3. You need to create Entitlement record, rather than retrieving from existing org. Because of this the error is occurring.

4. Create set of test records using @testSetup methods so that it can be used in other test methods in the same class.

5. Your test class should have necessary System.assert() statements to unit scenarios and outcome.

Refer Testing Best Practices