SFDC Sync - Failed: FIELD_INTEGRITY_EXCEPTION

A document by KCS Integration on behalf of bac89b007c194479a7573c01f235e47b3ecc2bbb on Mar 6, 2018Last modified by Roxann McGlumphy on Mar 7, 2018
Version 2Show Document
  • View in full screen mode

Issue Description
A lead fails to sync to Salesforce with the following error:

 

Failed: FIELD_INTEGRITY_EXCEPTION: There's a problem with this country, even though it may appear correct. Please select a country/territory from the list of valid countries.

 

This error may also occur for state as well as country fields.

 

 

Issue Resolution

Country/State pick-list is enabled on your SFDC instance. As a consequence, SFDC will reject any record with country/state value does not belong to the list and therefore, you will have to make sure that countries are set correctly everywhere in Marketo, and especially:

 

    • in forms
    • in data management campaigns
    • in imports

 

 

For example, if you try to feed "New York", it will not be accepted. It will only accept "NY". The error messages you're seeing are coming from Salesforce because the State fields have been standardized to only accept certain pick-list values. In order to get these records to sync with Salesforce you'll need to update them to have valid values. Contact your SFDC Admin to get the list of accepted values for that field and update the record in Marketo with the appropriate value that is accepted by SFDC.

 

If you feel like pick list is not necessary on SFDC, you could just disable the state or country pick lists in SFDC by following the below document https://help.salesforce.com/articleView?id=admin_state_country_picklist_enable.htm&type=5

 

 


Who This Solution Applies To
Customers who use SFDC as their CRM

Attachments

    Outcomes