SFDC Sync: State Picklist Error | Community
Skip to main content
A
Anonymous
May 9, 2014
Question

SFDC Sync: State Picklist Error

  • May 9, 2014
  • 6 replies
  • 5560 views
We have some leads with non-standardised state fields that are attempting a sync from Marketo to SFDC using the Sync Lead to SFDC action. When this happens, we get the following error before syncing fails:

"Failed: FIELD_INTEGRITY_EXCEPTION: There's a problem with this state, even though it may appear correct. Please select a state from the list of valid states.: State/Province"

I'm thinking for a quick solution we could just disable the State picklists in SFDC, so they are just a string. My worry is that Marketo will still try to sync to a picklist type and therefore fail. Has anybody done this and can advise? Or any suggestions on a better way to tackle the issue?

Any discussion is welcomed! :)
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

6 replies

T
tracitaylor
New Participant
September 25, 2020

I'm having this same problem, and it's actually deleting all US leads/contacts from Salesforce when syncing over from Marketo. I've updated the "Normalize" campaigns multiple times and have gone back and forth between 2-digit state code and full state name. But nothing seems to work.

Tom_Keefe3
Tom_Keefe3
New Participant
July 23, 2018

Hi Everyone

I've used the SFDC Country/State picklists in the past and never had an issue. However now I am encountering that even when I fix the Country/State values in Marketo then try to sync to SFDC (initial syn, they have never been in SFDC) I still get the same error. Has anyone else encountered this? basically the only thing I can do is delete and recreate the record then it sync correctly.

Marcel_Hobizal
Marcel_Hobizal
New Participant
July 30, 2020

I know this is an old post, but did anyone ever find a solution to this issue?  We just started having this same issue. 

A
Anonymous
May 12, 2014
Thanks Kenny - I'll keep the APEX trigger option in mind in the future. After taking into consideration the nature of both of your comments, it looks like the better option would be to manipulate the data before it goes into SFDC rather than disabling state picklists.

I think I'll either create a daily maintenance batch campaign which corrects this in Marketo, or even place it in the SFDC sync trigger campaign itself.
Delinda_Tinkey1
Delinda_Tinkey1
New Participant
March 17, 2017

Have you successfully implemented State and Country picklists with Marketo? I'm seeing conflicting results in the community. Thanks!

Delinda_Tinkey1
Delinda_Tinkey1
New Participant
March 17, 2017

That is...the SFDC standardized Stand and Country pick lists.

Kenny_Elkington
Kenny_Elkington
New Participant
May 9, 2014
Hey Adam,

If you can't easily normalize the data in Marketo, you might want to look into building an APEX trigger for Upserts on Leads/Contacts to change this before validation is applied.
A
Anonymous
May 9, 2014
Josh: That would normally be a good place to start, certainly! I should have mentioned in my OP that these leads in particular are based in the UK, and so the State fields typically contain counties such as "North Yorkshire" (so it's actually useful/correct data). 

How do you normally manage this sync for leads from countries with no official states? Is it better to create a custom field for "County" and set the State fields to blank in this case?

Cheers!
Josh_Hill13
Josh_Hill13
New Participant
May 9, 2014
Should you try to fix the State on the Marketo side first?
    Terms & ConditionsAccessibility statement

    Loading footer...