ERROR

Too few parameters. Expected 2

Last Published: April 25, 2020

Error Message

Using a Microsoft Access database table as the address table when geocoding results in the following error:

"There was an error trying to process this table.
General function failure [table name]
Too few parameters. Expected 2."

Cause

There is a field in the table defined as a memo field.

Solution or Workaround



Using Microsoft Access, either convert the memo field to a text field, or remove the memo field from the table.

Note:
The text field only holds 255 characters, any characters beyond 255 will be lost. If the the memo field contains more than 255 characters, create a lookup table to hold the information in the memo field that can be joined to the geocoding result.

Fields of type XML can be used to store strings longer than 255 characters.

Article ID:000006211

Software:
  • ArcMap 8 x
  • ArcMap 9 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic