Skip to main content
Nina_Valtcheva5
Nina_Valtcheva5
Level 4
April 17, 2015
Question

FIELD_INTEGRITY_EXCEPTION: There's a problem with this country, even though it may appear correct.

  • April 17, 2015
  • 1 reply
  • 1595 views
Is there a way to get a list of all of the records that have this error?

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

Trying to clean up the database and I randomly see this error on some of our records that have US instead of United States (for example). How can I see all of the leads with this country error and what is the best way to standardize it? I am new to Marketo so any detailed advice is greatly appreciated!
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Rachit_Puri2
Rachit_Puri2
Level 5
April 17, 2015
Hi Nina

There is not a direct way to achieve this. If you know which smart campaign is pushing leads to Salesforce, you can simply do the following:
- Go to Campaign Results and add a filter for Salesforce.com
- Download all the results to an excel and use a filter for getting leads with Field Integrity Exception.
- Build a smartlist in MKTO where email address includes all the leads that were captured in the excel. 

How to fix this?
- Build a campaign in MKTO to normalize city, state and country values. The field exception error usually comes when the Country field is a drop-down and the value that you are passing from MKTO doesn't match any of the drop down values. The difference here could be as small as an extra space. 
Once you build and run these campaigns, most of these errors should be gone. 

If you have a large database, you may want to use one of our pre-built contact washing machines. Drop a line at rachitp@grazitti.com for more details.
Terms & ConditionsAccessibility statement

Loading footer...