E2120 Field Integrity Exception

This Salesforce error occurs when a field value does not meet the integrity constraints set by Salesforce.

E2120 - ECE_SForceDataError: We got an error back from SalesForce when trying to update or insert data in SalesForce: Error returned from SFDC on upsert: [fields: Quote__c , message: Quote: id value of incorrect type: 0014J00000yrgTMQAY , statusCode: FIELD_INTEGRITY_EXCEPTION].

Common causes: 

  • Trying to insert a value that violates a field's picklist constraints.
  • Assigning an incorrect record type ID that is not valid for the object.
  • Using a wrong reference ID in a lookup field (e.g., setting an Account ID that doesn't exist).

Make sure you are importing the correct records to the correct objects. A quick check you can do is by reviewing the first few characters of the Id e.g. 001, 003. For standard objects, the prefixes will always be the same e.g. 001 is an Account record and 003 is a Contact record. There is also a list of the most common Standard Object Salesforce Prefixes.

In this case, the object type is incorrect because the object prefix is 001 and that belongs to accounts instead of the actual quote.