function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Ross JamesRoss James 

Find Nearby - Length of Address Line

I have over 3000 Contacts with an Address Line greater than the 30 character limit. This stops the Geocode with an error and it won't start again.

I then tried to change the Contact Mapping Address to Do Not Map, but the update fails as the Address Line is greater than 30 characters.

What am I to do? Other than edit the 3000 records (not going to happen).

Best Answer chosen by Admin (Salesforce Developers) 
Iman.ax920Iman.ax920

Ah... that explains it.

 

It's a Validation Rule created by your administrator that's the issue. 

 

Have your admin disable the rule - and all should be well. 

 

 

All Answers

Iman.ax920Iman.ax920

Hi Ross, 

 

I'm sorry you're having an issue. Can you post an example address for us to try out? 

Can you be more specific about the error message you're receiving?

 

Can you 
redfraggleredfraggle

Update failed. First exception on row 0 with id 0012000000R5PjEAAV; first error: FIELD_CUSTOM_VALIDATION_EXCEPTION, The length of the address line need to be 30 characters or less.: [Abbreviated_Delivery_Address_Line_1__pc]

An unexpected error has occurred. Your solution provider has been notified. (FN)

 

The contents of the field for the record is:

 

Suite 81, 289-295 Sussex Street

 

This is a PERSON ACCOUNT

 

I ran a report on the 750,000 Accounts and found that over 3000 have an address longer than 30 characters. When I tried to change the Mapping Address to DO NOT MAP - it fails, saying the field needs to be less than 30 characters.
Iman.ax920Iman.ax920

Ah... that explains it.

 

It's a Validation Rule created by your administrator that's the issue. 

 

Have your admin disable the rule - and all should be well. 

 

 

This was selected as the best answer
redfraggleredfraggle

Sorry, this is exactly the problem. Not sure why the field is 255 long with a Validation rule to limit it to 30 - but I guess that is just another weird thing for me to check out.

 

Thanks again.