+ Start a Discussion
Brad ClawsonAdminBrad ClawsonAdmin 

Live agent transcripts not attaching to case

We are experiencing an issue where transcripts are not being saved to our salesforce org.  The chat functionality is working, but when the chat ends, the transcript is not appearing in the case related list.  This was working before 2/29, but just stopped working on all chat cases.  We do have a trigger on the chat transcript object and on the same day the chat transcripts stop being created we were getting a Apex error email 

Subject: Developer script exception from xxxxxx : LiveChatTranscriptTrigger : LiveChatTranscriptTrigger: execution of AfterInsert 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.LiveChatTranscriptTrigger: line 20, column 1

 
Mohith Kumar ShrivastavaMohith Kumar Shrivastava
@Brad Can you post your trigger code .We can look at some queries and tell you how to get over this error .Thanks
Brad ClawsonAdminBrad ClawsonAdmin
Thank you for your reply.  I was able to determine the deficiency in the code and resolve the issue.  No more assistance needed.