Hi,

We suddenly run in a problem. Code below functioned perfectly for more than 2 years. Now it errors with following message:

Any ideas?

Error: Invalid Data. Review all error messages below to correct your data. Apex trigger beforeInsert_QuoteLineItem caused an unexpected exception, contact your administrator: beforeInsert_QuoteLineItem: execution of BeforeInsert caused by: System.QueryException: Non-selective query against large object type (more than 100000 rows). Consider an indexed filter or contact salesforce.com about custom indexing. Even if a field is indexed a filter might still not be selective when: 1. The filter value includes null (for instance binding with a list that contains null) 2. Data skew exists whereby the number of matching rows is very large (for instance, filtering for a particular foreign key value that occurs many times): Trigger.beforeInsert_QuoteLineItem: line 21, column 1

trigger beforeInsert_QuoteLineItem on QuoteLineItem (before insert) {  Map<String, QuoteLineItem> qli_to_insert = new Map<String, QuoteLineItem>();    Quote related_quote = [SELECT Id, Opportunity_Quote_nummer__c FROM Quote WHERE Id=:Trigger.new[0].QuoteId];  Integer quote_version = Integer.valueOf(related_quote.Opportunity_Quote_nummer__c);    //Get the oppty line items to insert where servicedate is created by a quote line item  for(QuoteLineItem quote_li:Trigger.new)  {    if(quote_li.ServiceDate != null)    {      if(quote_li.ServiceDate.Year() != (2000 + quote_version))      {        qli_to_insert.put(quote_li.sync_key__c, quote_li);      }    }  }    if(qli_to_insert.size()>0)  {    OpportunityLineItem[] related_oli = [SELECT Id, sync_key__c, of_Months__c, of_Users__c, Discount_valuta_line__c,                        Expected_delivery_date__c, Price_Unit1__c, Recurring__c, Total_Cost_of_Sales_Copy__c,                           Total_Gross_Margin_Copie__c, Description FROM OpportunityLineItem WHERE sync_key__c IN :qli_to_insert.keySet()];    if(related_oli.size()>0)    {      for(OpportunityLineItem oli:related_oli)      {        QuoteLineItem curr_qli = qli_to_insert.get(oli.sync_key__c);        curr_qli.of_Months__c = oli.of_Months__c;         curr_qli.of_Users__c = oli.of_Users__c;         curr_qli.Discount_Amount__c = oli.Discount_valuta_line__c;         curr_qli.Expected_delivery_date__c = oli.Expected_delivery_date__c;         curr_qli.Price_Unit1__c = oli.Price_Unit1__c;         curr_qli.Recurring__c = oli.Recurring__c;         curr_qli.Total_Cost_of_Sales_Copy__c = oli.Total_Cost_of_Sales_Copy__c;        curr_qli.Total_Gross_Margin_Copy__c = oli.Total_Gross_Margin_Copie__c;         curr_qli.Description = oli.Description;      }    }  }