ERROR 000042: Failed to create the address locator. An invalid SQL statement was used. Anyone know why I get this error?

1903
8
10-10-2016 01:13 PM
HannesZiegler2
Occasional Contributor II

I am attempting to build an address locator out of the street centerline dataset from Palm Beach County: Information Systems Services Data Catalog 

However, when I attempt to create an address locator from the data using the following options, I get an error message stating:

ERROR 000042: Failed to create the address locator.
An invalid SQL statement was used.

Has anyone encountered this problem or have an idea what the source of this error could be?

I appreciate the help!

0 Kudos
8 Replies
AllisonGoldberg2
New Contributor II

Hannes,

Were you ever able to solve this issue? I have gotten the same error with PBC data.

Allison

0 Kudos
MichaelVolz
Esteemed Contributor

Can you try exporting your data into a file gdb and then see if you can build the address locator?

Was version of ArcGIS Desktop are you working in?

0 Kudos
AllisonGoldberg2
New Contributor II

It is in a file gdb and I have tried it on 10.2.2. and 10.5.1. 

0 Kudos
MichaelVolz
Esteemed Contributor

Are your To and From fields defined as numbers or text?

HannesZiegler2
Occasional Contributor II

I was never able to resolve the issue, I ended up using the google geocoding service.

GPS Visualizer's Easy Batch Geocoder: Convert addresses to coordinates 

0 Kudos
AllisonGoldberg2
New Contributor II

As numbers

0 Kudos
MichaelVolz
Esteemed Contributor

STREET_NAM is defined as double.  I believe that needs to be a text field.

AllisonGoldberg2
New Contributor II

That worked, thank you Michael!