topic Re: ERROR 000047: Could not open locator workspace in Data Management Questions

ERROR 000047: Could not open locator workspace

Anonymous User — Fri, 15 Apr 2011 01:25:49 GMT

Running ArcGIS 10 (Build ) on 64bit Windows 7. When trying to create a new locator (any) within a specific folder or a file geodatabase within that folder, I recieve the following error message: ERROR 000047: Could not open locator workspace. I noticed an archived forum post addressing the same issue from back in 2009 with no responses (http://forums.esri.com/Thread.asp?c=93&f=1113&t=284837). The Help text is not very helpful in finding a solution. Has anyone else run into this and have any ideas on what the problem is or a work around?

Thanks,
James

Re: ERROR 000047: Could not open locator workspace

JoeBorgione — Fri, 15 Apr 2011 12:58:19 GMT

This isn't much help, but here's a link to an even earlier thread: http://forums.esri.com/Thread.asp?c=158&f=2284&t=265675

Perhaps you need to log a bug with support?

Re: ERROR 000047: Could not open locator workspace

Anonymous User — Tue, 19 Apr 2011 00:04:44 GMT

Thanks Joe. Seems this has been an issue for quite some time.

Re: ERROR 000047: Could not open locator workspace

BradNiemand — Mon, 25 Apr 2011 19:33:18 GMT

My first thought would be that you don't have access to the location that you are trying to create the locator in.

Brad

Re: ERROR 000047: Could not open locator workspace

Anonymous User — Tue, 03 May 2011 00:43:16 GMT

Simple, and that seems logical, but one of the first things I checked was permissions.

Re: ERROR 000047: Could not open locator workspace

BradNiemand — Tue, 03 May 2011 15:19:11 GMT

How large is your reference data? Do you have any of the service packs installed (sp1 or sp2)? Can you provide me with your reference data so that I can try it on my side?

Brad

Re: ERROR 000047: Could not open locator workspace

AnneShort — Thu, 05 May 2011 12:39:11 GMT

I got the same error message when trying to run 'Create Address Locator' today. No one is connected to my SDE database, and I can clearly connect through ArcCatalog to the reference featureclass. Please let me know if you hear anything.

-Annie

Re: ERROR 000047: Could not open locator workspace

BradNiemand — Thu, 05 May 2011 14:30:32 GMT

I got the same error message when trying to run 'Create Address Locator' today. No one is connected to my SDE database, and I can clearly connect through ArcCatalog to the reference featureclass. Please let me know if you hear anything.

-Annie

What version of ArcGIS are you using? What database are you using? What version of SDE are you using? What are your database permissions and what type of connection are you using (direct connection or SDE connnection)?

Brad

Re: ERROR 000047: Could not open locator workspace

AnneShort — Thu, 05 May 2011 17:16:19 GMT

What version of ArcGIS are you using? What database are you using? What version of SDE are you using? What are your database permissions and what type of connection are you using (direct connection or SDE connnection)?

Brad

ArcGIS 10 SP2, Enterprise SDE (SDE securities), ArcSDE 10 SP1, direct connection, connected as SDE user

Re: ERROR 000047: Could not open locator workspace

BradNiemand — Thu, 05 May 2011 18:43:05 GMT

It could be a known issue with long connection names. Is the direct connect string really long?

Brad

Re: ERROR 000047: Could not open locator workspace

AnneShort — Thu, 05 May 2011 18:51:50 GMT

It could be a known issue with long connection names. Is the direct connect string really long?

Brad

Yes it is! I'll rename it and see if I get better results thanks.
-Annie

Re: ERROR 000047: Could not open locator workspace

AnneShort — Fri, 06 May 2011 13:53:27 GMT

Unfortunately renaming my connection string didn't work.

Two things I've noticed - anytime you add a reference featureclass it is automatically set to the default Role of Alternate Name Table rather than the Primary table. The output address locator name it defaults to is also really long.

Brad, do you have any other things I could try, or do I need to contact tect support?

Re: ERROR 000047: Could not open locator workspace

BradNiemand — Fri, 06 May 2011 15:58:52 GMT

When you add a reference featureclass to the create locator tool it uses some logic to try and determine what reference data it thinks that you are adding. I your case you probably don't have a lot of the recognized names for the fields and therefore it thinks that it is a Alternate Name table. Do you switch it back to Primary Table? With regards to the output address locator, it will either use the last place that you tried to store a locator or the same place where the reference data exists. It also appends part of the tool name to the name of the reference data so, yes it can be quite long.

Have you tried to copy your data into a FileGDB and see if you can create a locator in the FileGDB? Maybe even try to store the locator in a Folder instead of in SDE?

Brad

Re: ERROR 000047: Could not open locator workspace

AnneShort — Fri, 06 May 2011 17:24:22 GMT

It worked from a FGDB saving into a FGDB. Is also worked from the SDE database saving to a file folder. Any thoughts as to why I can't save it within the SDE. It's not like I can assign SDE privledges to the database itself, I have to do that to each feature dataset.

Re: ERROR 000047: Could not open locator workspace

BradNiemand — Fri, 06 May 2011 17:26:27 GMT

Once you created it in a FileGDB can you copy it into SDE? I think it still may be related to the long name issue I mentioned before.

Are you trying to store the locator within a feature dataset?

Brad

Re: ERROR 000047: Could not open locator workspace

TroyNagle — Thu, 12 May 2011 14:08:26 GMT

If your reference data is in a dataset then ArcCatalog will try to create the locator in that dataset which will give you the error you mentioned.

Re: ERROR 000047: Could not open locator workspace

SeanMoran — Mon, 04 Jul 2011 13:22:40 GMT

If your reference data is in a dataset then ArcCatalog will try to create the locator in that dataset which will give you the error you mentioned.

I experienced similar trouble in ArcGIS 10. I believe the problem stems from creating an address locator based on a reference dataset that is located in a feature dataset. A workaround is to store your original reference dataset (or a copy) in the geodatabase, but not in a feature dataset. You can then create the address locator.

I believe this is a bug that ESRI should acknowledge and address. I should be able to create an address locator based on a centerline file that is stored in a feature dataset.

Re: ERROR 000047: Could not open locator workspace

BradNiemand — Wed, 06 Jul 2011 16:00:56 GMT

I can't reproduce this issue on 10.0 SP2. I have a street centerline featureClass that is stored in a featureDataset and the locator builds with no issue. The one issue that I see most often is that, by default, the output location for the locator is within the featureDataset and that is when creation fails. If this is not what you are seeing, I would suggest logging a call with support.

Brad

Re: ERROR 000047: Could not open locator workspace

JessiePechmann — Tue, 08 Nov 2011 18:29:40 GMT

Got it to work!
I got this same error while building a locator from a feature dataset. I had to change the default to something I typed in for the output file. Worked then.

Re: ERROR 000047: Could not open locator workspace

MichelleBoivin — Fri, 30 Dec 2011 17:23:13 GMT

I agree that this is unacceptable. Today I am having the exact same error trying to create an address locator as well. My centerline file is also in a network dataset in SDE (I have sysadmin rights to the server and SDE). I attempted everything mentioned within the threads; storing it outside of the dataset (which is where I want it anyway), renaming it to keep it short, etc. Nothing worked until I imported the feature class outside of the dataset so it was a stand alone feature class. There should not be any reason as to why a user needs to maintain an extremely important dataset in two places due to a bug.

For the record, I am on AGD 10.0, SP3, Windows XP, using direct connect.