554 System.DmlException: Insert (or Update) failed. ... FIELD_INTEGRITY_EXCEPTION

If you have a required lookup filter on the Account, Contact or Lead lookup fields on Case, an error will occur if a case is inserted or updated and the lookup filter criteria is not satisfied.

  • May 28, 2020
  • Knowledge

Permalink
https://kb.vicasso.com/?kb=000004403
Symptoms
An error similar to the following is sent to the Route Errors to Email Address:

The attached message was sent to the Email Service address <e2cp@zzzzzzzzzzzzzz.in.salesforce.com> but could not be processed because the following error occurred: 
 
554 System.DmlException: Insert failed. First exception on row 0; first error: FIELD_INTEGRITY_EXCEPTION, ......: [LookupField] 
 
(E2CP)
Solutions
We recommend using an Optional lookup filter. Note: If your organization has duplicate Accounts, Contacts or Leads, E2CP may be using a randomly selected duplicate that doesn’t satisfy the lookup filter criteria while another duplicate does.

Configuration of Lookup Filters is not supported as a part of product support.
Status
This is by design.
Additional Information
See Salesforce Help & Training for information on configuring Lookup Filters.
Title
554 System.DmlException: Insert (or Update) failed. ... FIELD_INTEGRITY_EXCEPTION
URL Name
554-System-DmlException-Insert-or-Update-failed-FIELD-INTEGRITY-EXCEPTION