Rebuilding a locator with an alternate name table fails

267
1
04-17-2013 08:35 AM
SandraLuken
Occasional Contributor
ArcGIS Desktop 10.0 SP5
Reference Data in SDE 10.0 SP3 (Oracle11g)
Locator stored in a file geodatabase v10

Locator settings
Style: General - Single Field
Data Sources: both are stored in the same SDE geodatabase
[INDENT][/INDENT]Primary table: point feature class
[INDENT][/INDENT]Alternate name table: table

The problem is encountered when there is any attempt to rebuild this locator. Error messages such as ERROR 000005: Could not open the address locator, are received. After the rebuild process is run, the locator becomes corrupt and cannot be repaired and it must be recreated. This sounds similar to NIM089058, EXCEPT, the data source has not moved, changed names, permissions or schema. In fact I have never been able to rebuild this locator through ArcGIS Desktop or Model Builder, and for a brief period of time thought that this could be rebuilt via Python, but that too is failing. I am now no longer able to rebuild a locator with this type of configuration.

This is a huge problem for us, as using Python to recreate the locator is not an option because of the locator settings (such as spelling sensitivity) that can only be updated manually after the locator is built.

Thank you for your help,
Sandra
Tags (2)
0 Kudos
1 Reply
JoeBorgione
MVP Emeritus
A couple of questions and subsequent suggestions for you Sandra:

Is the locator published?  If so you should shut the service down and then try to rebuild.

Is the locator and or data located on a SAN?  If so, check your permissions there.  They (permissions) have a tendency to get goofy with SANs.

Hope this helps-
That should just about do it....
0 Kudos