State Code Not Available

Error

The StateCode field contains a value that isn’t an available State. Your administrator can add it for you.

Research

1. Pick a group of records that is failing with this error to use as an example for your research using the Activity Stream Error/Warning Report from your Reports dashboard.
2. Drill into the groups/matches for the filter and load the group of records from your failed example so that you can view the address fields from all records involved in the merge.
3. If your master record is missing the State Code from the address (it is blank), but the non-master record has a state listed, this could be reason for the error. For example: if the state code is pulling in from a non-master and country code is something other than where the state code exists (State code TX does not belong with an address in Ireland).

Here is how you can get mixed-matched states/countries in your address block: 

1. Cloudingo always attempts to give you the most complete record possible. 
2. Salesforce has separate fields for each address field (street, city, state, zip, country, etc.) are all fields independent of one another, but serve as part of a group.
3. When a value is missing on the master, Cloudingo attempts to pull in the value from another record if one exists (for any field - not just an address field).

Solution

1. Set up group rules to group the address fields together so that street, city, state, zip, country are all kept together from one record based on whatever logic is used to determine which address survives during the merge.
2. Set up field level rules. 
   1. Determine if you always want to retain the master address values (even if incomplete) or if you want to always take the newest, most complete address, oldest, etc. 
3. Alternatively, investigate if these records should even be merged or kept separate if the address is different. 
   1. If you choose to keep the records separate (due to the different addresses), you would want to add city, country, or state (or some other address value) to your matching criteria so that these records are no longer being identified as a match.

Still experiencing issues?

Contact our support team.