BMC Helix Remedyforce : Unable to Edit Account in Remedyforce, Users Receive an Error Message

Manage Support IDs

Use checkboxes to 'Remove support IDs/Users' or 'Allow to create Cases'
Support IDs for BMC Customer Support Site Guest User
Profiles Which Include    Back to All Support IDs
 

Knowledge Article

BMC Helix Remedyforce : Unable to Edit Account in Remedyforce, Users Receive an Error Message
Unable to Edit Account in Remedyforce, Users Receive an Error Message.
BMC Helix Remedyforce Service Desk
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)
 
The query that checks Accounts is returning too many records
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 requests the "Bind Variables" explain there are none as the query comes from a Trigger and NOT and Apex Class.
BMC Helix Remedyforce Service Desk
BMC Helix Remedyforce Service Desk
Attachment(s):