Field Integrity Exception Issue: Country | Community
Skip to main content
Owen_Millard1
Owen_Millard1
Level 2
October 5, 2019
Question

Field Integrity Exception Issue: Country

  • October 5, 2019
  • 2 replies
  • 4441 views

During an SFDC sync, some records within my instance fail to sync, 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.: Country

I've seen some other posts on the community, and I've contacted Marketo support, but I'm unable to successfully troubleshoot this. The records in question have a blank country value, and our SFDC admin is able to confirm that there doesn't seem to be any restriction that would prevent records/leads from being created in SFDC if no country value is present (I can create one, manually, as an SFDC user, and I can create one without a Country value via the Data Loader desktop client also).

Has anyone encountered this before?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

SanfordWhiteman
SanfordWhiteman
Level 10
October 5, 2019

Are you certain that it's blank and not containing invisible whitespace?

Also ensure (have your SFDC admin ensure) that there is not, for example, a workflow rule which attempts to "fix up" a blank value that's created via certain methods, and the fixed-up value is broken.

The error is certainly within Salesforce in any case. Marketo never imagines FIELD_INTEGRITY_EXCEPTIONs out of whole cloth!

    Chris_Willis1
    Adobe Champion
    Chris_Willis1Adobe Champion
    Adobe Champion
    October 7, 2019

    I would agree with Sanford's statement.  The issue is related to your Salesforce system requiring a certain data value to create a record and the sync is providing an unrecognized value or a blank field.  Please talk to your Salesforce administrator to understand their requirements.

    A solution that you should consider is to standardize your lead imports around ISO country/state values in Marketo, and if another format is required by SFDC, to translate them via a webhook that conducts a "Vlookup" from the ISO to the Salesforce-acceptable value.  Sanford has a solution that can help you in this regard, which we have found to be very helpful.  

    Chris Willis - Fractional GTM Operations Consultant
      Terms & ConditionsAccessibility statement

      Loading footer...