Help with simple update case trigger

Question

I'm declarative developer trying to make this work: I am trying to update the case owner to a queuename based on status. Here is my code and the error I'm getting below. Any help would be appreciated!

    trigger CRME_Case_ReOpen_OOO on Case (before update) {            
        for(case c :trigger.new){       

          if(c.OwnerOOO__c == TRUE &&  c.Status == 'Working' ) 

                c.OwnerID =  [select Id from User where Name = :c.QueueNameRef__c].Id;              
                }                                    
   }

Error:Apex trigger CRME_Case_ReOpen_OOO caused an unexpected exception, contact your administrator: CRME_Case_ReOpen_OOO: execution of BeforeUpdate caused by: System.QueryException: List has no rows for assignment to SObject: Trigger.CRME_Case_ReOpen_OOO: line 14, column 1

Answer 1

In case you can't find a workflow solution...

This is a more defensive version of the trigger that also avoids the query inside a loop problem (that can cause the 100 SOQL queries governor limit to be exceeded). But as the comments mention, if there are inconsistent data values they also need fixing.

trigger CRME_Case_ReOpen_OOO on Case (before update) {  
    Set<String> names = new Set<String>();          
    for (Case c : Trigger.new) {       
        if (c.OwnerOOO__c && c.Status == 'Working' && c.QueueNameRef__c != null) {
            names.add(c.QueueNameRef__c);
        }
    }
    if (names.size() > 0) {
        Map<String, Id> m = new Map<String, Id>();
        for (User u : [
                select Id, Name
                from User
                where Name in :names
                order by Name
                ]) {
            m.put(u.Name, u.Id);
        }
        for (Case c : Trigger.new) {       
            if (c.OwnerOOO__c && c.Status == 'Working' && c.QueueNameRef__c != null) {
                Id id = m.get(c.QueueNameRef__c);
                if (id != null) {
                    c.OwnerID = id;
                }
            }
        }
    }
}