Unable to Edit Any Account in Remedyforce. Receive the error below:
Error: Invalid Data. Review all error messages below to correct your data.
Apex trigger BMCServiceDesk.AccountTrigger caused an unexpected exception, contact your administrator: BMCServiceDesk.AccountTrigger: execution of BeforeUpdate 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): (BMCServiceDesk)
Open a case with Salesforce and request an index be put on the User object Account ID field.
So far the issue has only occurred when there are a large number of Account and or a large number of Contacts, i.e. exceeding 50000.
See the following cases for reference:
Support · Case 13899603
Support · Case 13979324
NOTE: If the Salesforce reqeusts the "Bind Veriables" explain there are none as the query comes from a Trigger and NOT and Apex Class.