Error 9
{"status":"Error","retVal":null,"errorLog":{"recordId":null,"errorType":null,"description":"CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY-SVMXSB.SB_SVMX_Event_Trigger1: execution of AfterUpdate\n\ncaused by: System.QueryException: Non-selective query against large object type (more than 200000 rows). Consider an indexed filter or contact salesforce.com about custom indexing.\nEven if a field is indexed a filter might still not be selective when:\n1. The filter value includes null (for instance binding with a list that contains null)\n2. 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)\n\n(SVMXSB)\n"}}
This error occurs if Appointment records are updated in Service Board at a time when there are more than 200,000 Outbound Queue records.
To resolve Error 9:
• In Workbench, run the following Apex query:
delete [SELECT Id FROM SVMXC_SM_SB_Queue_Outboundc WHERE SVMXCSM_Status_c = 'Completed' limit 10000];
 |
You cannot delete more than 10,000 records with a single query. To delete more than 10,000 records, run the query multiple times.
|
For more information: