Fix for [Contact] Error - Error Occurred Updating Item: [FIELD_INTEGRITY_EXCEPTION]

Issue

In Riva Cloud or in Riva On-Premise, the following sync error may occur:

Cause

State and Country pick lists have been enabled in Salesforce, but the support for those pick lists has not been enabled in Riva.

Solution

Solution for Riva Cloud

• Contact the Riva Success Team.

Solution for Riva On-Premise

To support state and country pick lists:

1. Determine which Riva On-Premise version is installed. If it is not at least 2.4.39.24713, upgrade Riva to the latest public release, unless a Riva staff member advises you to do otherwise.

2. Apply the following advanced custom option to the Salesforce connection:
   
   Sync.Crm.Contact.StateCountryPickList.Supported = true

3. Reopen the Salesforce connection.

4. Navigate to the Object Definition page. Near the top, select Refresh.

5. Save the CRM connection.

   Note: After you apply this option, users must create or update their syncable email contacts with the exact State and Country values that are specified in the Salesforce contact pick lists. If an invalid value is entered, a sync error occurs when trying to create or update the contact in Salesforce.