Getting a "Value does not exist or does not match filter criteria" when updating a TEXT field in sandbox. Why?
Of the 5099 records I have to update I tested in a partial sandbox, 492 created the error "Value does not exist or does not match filter criteria."
What is causing this?
The records do allow for parent records, but the error message is not consistent to only the child records. There are instances where the parent name field update/did not, and the child name updated/did not.
There are no validation rules on the field.
Have you seen this https://success.salesforce.com/answers?id=90630000000gpYjAAI? This error is caused by a lookup filter, and it even can be a filter on the related object, not the object you are updating.
Again, I expected this have something to do with the parent/child record relationship happening in the same object, but the error is inconsistent in its application in those instances.
My guess would be because they don't expect you to cancel your subscription due to something like this. And even if you do cancel, they probably wouldn't care that much. #Einstein
Sorry, I can't help myself sometimes... ^_^