RECORD QUERY: FindUserForReassignment
Find one User record where:
Topic_Profile_Number__c Equals
{!VARSourceFB} (962723)
Topic_Profile_Number__c Is null false
Result
Successfully found record. {!VARUserId} = 0054100000450cDAAQ
RECORD UPDATE: Update_Lead
Find all Lead records where:
Source_Facebook_Profile__c Equals {!VARSourceFB}
(962723)
Source_Facebook_Profile__c Is null false
SourceSocialPostId__c Equals
{!SocialPostId}
(0ST1K000002ONUfWAO)
Update the records’ field values.
OwnerId =
{!VARUserId}
(0054100000450cDAAQ)
Result
Failed to update records that meet the filter criteria.
________________________________________
Error Occurred: This error occurred when the flow tried to update records: An unexpected error occurred. Please include this ErrorId if you contact support: 1592962804-36506 (-548403183). You can look up ExceptionCode values in the SOAP API Developer Guide.
________________________________________
________________________________________
Salesforce Error ID: 1592962804-36507 (-1393403324)
When I have the Debug logs on I get this error too.
I've tried rearranging my flow and everything but it always works in my developer and full sandbox but fails once it gets to production. Any ideas?_Non-selective query against large object type (more than 200000 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)_
Thanks! I'm playing with making the field on lead an external id.
