topic Re: ERROR 000042: Failed to create the address locator. An invalid SQL statement was used. Anyone know why I get this error? in Addressing Questions https://community.esri.com/t5/addressing-questions/error-000042-failed-to-create-the-address-locator/m-p/820851#M245 <HTML><HEAD></HEAD><BODY><P>It is in a file gdb and I have tried it on 10.2.2. and 10.5.1.&nbsp;</P></BODY></HTML> Fri, 03 Nov 2017 17:10:18 GMT AllisonGoldberg2 2017-11-03T17:10:18Z ERROR 000042: Failed to create the address locator. An invalid SQL statement was used. Anyone know why I get this error? https://community.esri.com/t5/addressing-questions/error-000042-failed-to-create-the-address-locator/m-p/820848#M242 <HTML><HEAD></HEAD><BODY><P>I am attempting to build an address locator out of the street centerline dataset from Palm Beach County:&nbsp;<A class="link-titled" href="http://discover.pbcgov.org/iss/cwgis/Pages/Data-Catalog.aspx" title="http://discover.pbcgov.org/iss/cwgis/Pages/Data-Catalog.aspx">Information Systems Services Data Catalog</A>&nbsp;</P><P></P><P>However, when I attempt to create an address locator from the data using the following options, I get an&nbsp;error message stating:</P><P></P><P>ERROR 000042: Failed to create the address locator.<BR />An invalid SQL statement was used.</P><P></P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/242816_pastedImage_2.png" /></P><P></P><P>Has anyone encountered this problem or have an idea what the source of this error could be?</P><P></P><P>I appreciate the help!</P></BODY></HTML> Mon, 10 Oct 2016 20:13:46 GMT https://community.esri.com/t5/addressing-questions/error-000042-failed-to-create-the-address-locator/m-p/820848#M242 HannesZiegler2 2016-10-10T20:13:46Z Re: ERROR 000042: Failed to create the address locator. An invalid SQL statement was used. Anyone know why I get this error? https://community.esri.com/t5/addressing-questions/error-000042-failed-to-create-the-address-locator/m-p/820849#M243 <HTML><HEAD></HEAD><BODY><P>Hannes,</P><P></P><P>Were you ever able to solve this issue? I have gotten the same error with PBC data.</P><P></P><P>Allison</P></BODY></HTML> Fri, 03 Nov 2017 16:27:15 GMT https://community.esri.com/t5/addressing-questions/error-000042-failed-to-create-the-address-locator/m-p/820849#M243 AllisonGoldberg2 2017-11-03T16:27:15Z Re: ERROR 000042: Failed to create the address locator. An invalid SQL statement was used. Anyone know why I get this error? https://community.esri.com/t5/addressing-questions/error-000042-failed-to-create-the-address-locator/m-p/820850#M244 <HTML><HEAD></HEAD><BODY><P>Can you try exporting your data into a file gdb and then see if you can build the address locator?</P><P></P><P>Was version of ArcGIS Desktop are you working in?</P></BODY></HTML> Fri, 03 Nov 2017 16:43:57 GMT https://community.esri.com/t5/addressing-questions/error-000042-failed-to-create-the-address-locator/m-p/820850#M244 MichaelVolz 2017-11-03T16:43:57Z Re: ERROR 000042: Failed to create the address locator. An invalid SQL statement was used. Anyone know why I get this error? https://community.esri.com/t5/addressing-questions/error-000042-failed-to-create-the-address-locator/m-p/820851#M245 <HTML><HEAD></HEAD><BODY><P>It is in a file gdb and I have tried it on 10.2.2. and 10.5.1.&nbsp;</P></BODY></HTML> Fri, 03 Nov 2017 17:10:18 GMT https://community.esri.com/t5/addressing-questions/error-000042-failed-to-create-the-address-locator/m-p/820851#M245 AllisonGoldberg2 2017-11-03T17:10:18Z Re: ERROR 000042: Failed to create the address locator. An invalid SQL statement was used. Anyone know why I get this error? https://community.esri.com/t5/addressing-questions/error-000042-failed-to-create-the-address-locator/m-p/820852#M246 <HTML><HEAD></HEAD><BODY><P>Are your To and From fields defined as numbers or text?</P></BODY></HTML> Fri, 03 Nov 2017 17:48:34 GMT https://community.esri.com/t5/addressing-questions/error-000042-failed-to-create-the-address-locator/m-p/820852#M246 MichaelVolz 2017-11-03T17:48:34Z Re: ERROR 000042: Failed to create the address locator. An invalid SQL statement was used. Anyone know why I get this error? https://community.esri.com/t5/addressing-questions/error-000042-failed-to-create-the-address-locator/m-p/820853#M247 <HTML><HEAD></HEAD><BODY><P>As numbers</P></BODY></HTML> Fri, 03 Nov 2017 17:59:21 GMT https://community.esri.com/t5/addressing-questions/error-000042-failed-to-create-the-address-locator/m-p/820853#M247 AllisonGoldberg2 2017-11-03T17:59:21Z Re: ERROR 000042: Failed to create the address locator. An invalid SQL statement was used. Anyone know why I get this error? https://community.esri.com/t5/addressing-questions/error-000042-failed-to-create-the-address-locator/m-p/820854#M248 <HTML><HEAD></HEAD><BODY><P>STREET_NAM is defined as double. &nbsp;I believe that needs to be a text field.</P></BODY></HTML> Fri, 03 Nov 2017 19:28:30 GMT https://community.esri.com/t5/addressing-questions/error-000042-failed-to-create-the-address-locator/m-p/820854#M248 MichaelVolz 2017-11-03T19:28:30Z Re: ERROR 000042: Failed to create the address locator. An invalid SQL statement was used. Anyone know why I get this error? https://community.esri.com/t5/addressing-questions/error-000042-failed-to-create-the-address-locator/m-p/820855#M249 <HTML><HEAD></HEAD><BODY><P>That worked, thank you Michael!</P></BODY></HTML> Fri, 03 Nov 2017 19:36:58 GMT https://community.esri.com/t5/addressing-questions/error-000042-failed-to-create-the-address-locator/m-p/820855#M249 AllisonGoldberg2 2017-11-03T19:36:58Z Re: ERROR 000042: Failed to create the address locator. An invalid SQL statement was used. Anyone know why I get this error? https://community.esri.com/t5/addressing-questions/error-000042-failed-to-create-the-address-locator/m-p/820856#M250 <HTML><HEAD></HEAD><BODY><P>I was never able to resolve the issue, I ended up using the google geocoding service.</P><P></P><P><A class="link-titled" href="http://www.gpsvisualizer.com/geocoder/" title="http://www.gpsvisualizer.com/geocoder/">GPS Visualizer's Easy Batch Geocoder: Convert addresses to coordinates</A>&nbsp;</P></BODY></HTML> Wed, 08 Nov 2017 12:52:57 GMT https://community.esri.com/t5/addressing-questions/error-000042-failed-to-create-the-address-locator/m-p/820856#M250 HannesZiegler2 2017-11-08T12:52:57Z