Field Integrity Exception

What Does This Error Mean?

The FIELD_INTEGRITY_EXCEPTION error occurs in Salesforce when Revenue.io attempts to update a Salesforce field with data that doesn't match the expected format or type. This error indicates that the system is trying to maintain data integrity by preventing invalid data from being written to your Salesforce fields.

Common Causes

As a Salesforce Administrator, you may encounter this error for several reasons:

  • Salesforce Limitations: Attempting to log an Activity to a Lead record (WhoID) and relate it to an Account, Opportunity, or Campaign (WhatID). Salesforce will not allow this.
  • ID Mismatch: Attempting to populate a field with an ID of the wrong object type (e.g., inserting an Opportunity ID into a field that expects an Account ID)
  • Date/Time Format Issues: Sending date or time values in a format that doesn't match Salesforce's expected format

Troubleshooting Steps

When you encounter a FIELD_INTEGRITY_EXCEPTION error, follow these steps to diagnose and resolve the issue:

1. Identify the Specific Field or Object Causing the Error

The error message should indicate which field or Object is causing the problem. For example, the most common error to receive is "Error updating record: TaskRelation can't be created for a Task that already has a lead."

2. Confirm Task Relation is Allowed

As indicated earlier, Salesforce will not allow an Activity/Task in Salesforce to be associated with both a Lead (WhoID) and an Account, Opportunity, or Campaign (WhatID). Validate that users are associating tasks to allowed record types.

3. Check Field Configuration in Salesforce

In your Salesforce instance:

  1. Navigate to Setup
  2. Go to Object Manager
  3. Select the relevant object
  4. Click on Fields & Relationships
  5. Find the field mentioned in the error
  6. Review the field's data type, format requirements, and any validation rules

Need Additional Help?

If you continue to experience FIELD_INTEGRITY_EXCEPTION errors after trying these troubleshooting steps:

  • Contact Revenue.io Support with the specific error message and field information
  • Provide examples of the data being sent that's causing the error

Our support team can help identify any configuration issues or recommend adjustments

Was this article helpful?

/