Some city and state combination of United states does not fit into City [Varchar(20)] of tciAddress table.
Here are few Examples

City State
Hot Springs National Park AR
Yellowstone National Park WY
Petrified Forest Natl Pk AZ
Kings Canyon National Pk CA
Joint Base Lewis McChord WA
Aberdeen Proving Ground MD
South Abington Township PA
Port Jefferson Station NY
Rancho Santa Margarita CA
Big Bend National Park TX
Township of Washington NJ
University of Richmond VA
Washington Court House OH
Yosemite National Park CA
Palos Verdes Peninsula CA
Shelter Island Heights NY

Comments

  • Additionally, these should be increased to at least 90 to allow for some international destinations.

  • And make same changes to City field (Param2City) in the tccTran table