nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

run RebuildAddressLocator from python (arcgis pro) but get Error 000005: Could not open the address locator

geopamplona

I try to run RebuildAddressLocator from python and I get the same error ‘Error 000005: Could not open the address locator’.

I have tried to create the locator from arcgis pro 2.9.5, I generate the loc and loz files, and I try to rebuild the locator, everything works correctly using arcgis pro; but if I close arcgis pro and open it again I can't rebuild the locator and I get Error 000005: Could not open the address locator

The locator source is a feature layer hosted in an enterprise sqlserver database with no locks, as it is a layer that is not published as a service, and with versioning.

I work under a version arcgis pro 2.9.5 and always logged against portal 10.9.1.

I have installed the license manager on the machine I run from but I haven't changed anything.

The idea would be to go ahead and launch this from python as you do to schedule it weekly but I can't get out of this simple point.

Thank you!

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

DanPatterson

You indicate you are using python, so presumably your script may be at issue. In any event have you examined all the possible reasons that this error may be shown and their solutions as listed in the help files.

000005: Could not open the address locator.—ArcGIS Pro | Documentation

geopamplona

The script is simply trying to rebuild the locator.

The problem is that both in the script and in ArcGIS Pro I get the same error, it fails to access the data source.

arcpy.geocoding.RebuildAddressLocator(r"C:\test\locator.loc")

DanPatterson

The only other reference, which mentions python scripts, appears here

FAQ: Best Practices for Deploying Address Locators on a Network Location to Avoid Locking (esri.com)

MikeVolz

Is the locator itself being used in a geocode service? If so, you need to stop the geocode service.

You said "The locator source is a feature layer hosted in an enterprise sqlserver database." Does this mean this is a standard enterprise feature class or is this a service?

Was your connection to the enterprise SQL Server database done using a location sde connection on the C-drive or was it a mapped network drive location to the sde connection?

MarkGambordella

Did you ever find the reason why and if so what is the workaround. having same issue, will not rebuild in Arc Pro or script. We switched from an Oracle to SQL server and built the NEW locators exactly the same, then the issue began.

MarkGambordella

Did you ever find the reason why and if so what is the workaround. having same issue, will not rebuild in Arc Pro or script (Error 000005) . We switched from an Oracle to SQL server and built the NEW locators exactly the same, then the issue began. they path directly to the NEW SQL SDE database. I am signed in with my Microsoft authenticator (all restrictions). I am able to build them but not rebuild. I can use them in AGO and PRO. The composite is published to the REST server as a geolocator in AGO which in turn is used in everyone's PRO for the organization.

mthompson_WellesleyMA

I am also unable to rebuild any address locator I create. I created a brand new locator pointing at a point layer in our SQL Enterprise GDB which built successfully and works great. I try to rebuild it, and I get "Error 999999 Something unexpected caused the tool to fail" and "Error 000005 Could not open the address locator". None of the steps in this article help. https://pro.arcgis.com/en/pro-app/3.4/tool-reference/tool-errors-and-warnings/001001-010000/tool-errors-and-warnings-00001-00025-000005.htm

MikeVolz

What version of ArcGIS Pro are you building the address locator in?

mthompson_WellesleyMA

We are using 3.5.6

MikeVolz

mthompson:

I just converted from an Oracle gdb to a SQL Server gdb at ArcGIS Pro 3.4.x and I am able to rebuild the address locator that I had just created in this environment. Do you have the ability to access a machine with ArcGIS Pro 3.4.x and see if you can build a new locator and then rebuild the locator in that environment as maybe there is a bug with rebuilding SQL Server address locators in ArcGIS Pro 3.5.x?

mthompson_WellesleyMA

Sorry for the delay, we do not have any 3.4 machines, but I got around it by just making a model where I extract our addresses to a file GDB before feeding them into the locator rebuild. I think this will work fine for us since we would need to run the rebuild anyway each time, having the extra step in the model only takes a few seconds.

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.