topic Re: ERROR 000837: The workspace is not the correct workspace type in Geoprocessing Questions

ERROR 000837: The workspace is not the correct workspace type

GaryEhrhardt — Tue, 20 Nov 2012 21:14:35 GMT

I have a very simple python script that does a compress on one of our enterprise GDB's. The script used to successfully run every night but is now receiving the following error:
"ERROR 000837: The workspace is not the correct workspace type"

There have been 2 recent changes to our environment - one of which must be a contributing factor to this script now erroring out. The first is upgrading from ArcGIS 10.0 SP4 to ArcGIS 10.1 SP1. The other is that we are now running this script on a new server where the old server had 32 bit processing, and the new server is 64 bit.

Here is the script that worked on our old server:

import arcgisscripting
gp = arcgisscripting.create()
gp.toolbox = "management"
gp.compress("Database Connections\sde_loader@bierstadt.sde")

Running the same script on the new server (only change being the db connection) errored out.

I tried updating the python code as follows:

import arcpy
arcpy.ClearWorkspaceCache_management()
arcpy.Compress_management("Database Connections\saxon2_bierstadt_sde_loader.sde")

This also received the same error (000837)

Any ideas on what may be causing this error would be much appreciated.

Gary

Re: ERROR 000837: The workspace is not the correct workspace type

MathewCoyle — Tue, 20 Nov 2012 21:54:47 GMT

You should use the correct path syntax using a raw string, it shouldn't be a problem in this case but better safe than sorry.

arcpy.Compress_management(r"Database Connections\saxon2_bierstadt_sde_loader.sde")

Are you sure the database connection you are using is an administrator account? Is anyone currently locking any files in the DB?

Re: ERROR 000837: The workspace is not the correct workspace type

GaryEhrhardt — Tue, 27 Nov 2012 18:23:22 GMT

Matthew,

Thanks for your reply.

I tried using a raw string for my path name to no avail.
I am using an administrator account when running the script.
I am able to successfully use the compress tool (from toolbox), so I don't think that there is a db lock issue.
It's only when I try to compress from the python script that I encounter this maddening error.

Gary

Re: ERROR 000837: The workspace is not the correct workspace type

MathewCoyle — Tue, 27 Nov 2012 19:05:08 GMT

Have you set your workspace environment to sde?

Re: ERROR 000837: The workspace is not the correct workspace type

T__WayneWhitley — Tue, 27 Nov 2012 19:26:28 GMT

According to the documentation and examples, will it help to use the compress command in conjunction with ClearWorkspaceCache.
Ironically, setting your env workspace var may put a 'hold' on it...so (although this is a 10 example, below link), the workspace cache is cleared just before executing the compress...doesn't quite explain why this is behaving this way now though.

...interesting script example at bottom of page:
http://resources.arcgis.com/en/help/main/10.1/index.html#//00170000000m000000

...use of ClearWorkspaceCache before compress:
http://support.esri.com/en/knowledgebase/techarticles/detail/40657

Re: ERROR 000837: The workspace is not the correct workspace type

T__WayneWhitley — Tue, 27 Nov 2012 19:45:29 GMT

Try this:

dbConnect = r'Database Connections\< your sde filename >'
arcpy.env.workspace = ""
arcpy.ClearWorkspaceCache_management(dbConnect)
arcpy.Compress_management(dbConnect)

Re: ERROR 000837: The workspace is not the correct workspace type

GaryEhrhardt — Wed, 28 Nov 2012 16:57:48 GMT

It turns out that the problem was more of a Microsoft Windows security settings issue. Our new server has a Windows Server 2008 R2 operating system (old server - Windows Server 2003). There's some setting(s) or lack thereof that is preventing the recognition of the "Database Connections" part of the db connection path when accessing via a python script. Haven't resolved that yet but with the help of Umesh from ESRI tech support, I have a workaround that is described below:

Instead of specifying the db connection as "Database Connections\sde_loader@bierstadt.sde"

Obtain the path name on the C drive by right clicking the db connection in ArcCatalog and selecting properties. The path name is on the General tab.

In my case, the name is: C:\Users\ehrhardt\AppData\Roaming\ESRI\Desktop10.1\ArcCatalog\bierstadt_saxon2.sde

Inserted this name into the script, and the script finally worked!

Thank you to Matthew & Wayne for your suggestions and to Umesh for the workaround solution.

Re: ERROR 000837: The workspace is not the correct workspace type

T__WayneWhitley — Wed, 28 Nov 2012 17:58:08 GMT

Good to know - Server 2008 R2 is on my test machine, soon-to-be production server. So in case I have a similar problem I'll refer to this.
Also, if it helps, when running 'admin' type of scripts on the server, esp as scheduled tasks, I think it's better to store the connection file in a separate 'non-user-profile' location anyway and specify the UNC pathname. Could create the connection dynamically too.

Anyway, thanks for passing along the info.

Re: ERROR 000837: The workspace is not the correct workspace type

BillFarris — Tue, 06 Jan 2015 00:36:57 GMT

This didn't work for me with 10.2.2. It tells me error 000837 saying the workspace is not the correct workspace type. Any ideas?

Re: ERROR 000837: The workspace is not the correct workspace type

DeeptiVB — Mon, 18 Dec 2017 22:52:33 GMT

Giving the direct C drive link worked for me as well. Thanks for posting the reply, it helped.

Re: ERROR 000837: The workspace is not the correct workspace type

HarshalGharat — Mon, 20 Aug 2018 08:39:35 GMT

I am not sure if I might get any response on this thread as it looks to be quite an old thread. I am facing a very weird issue in setting the workspace. When I setup the workspace inside python window in ArcMap/ArcCatalog, it just works fine.

But the moment I do the same in a standalone script, the things do not work at all. I tried other options like creating connection file in scratch folder and then setting it as a workspace but still no luck.

This is driving me crazy and any help in this regard is really appreciated.

Re: ERROR 000837: The workspace is not the correct workspace type

Ed_Conrad — Fri, 27 Dec 2019 22:55:20 GMT

I interrupted my script while it was compressing the GDB during some testing. Subsequently, I received ERROR 000837 when I reran it. After running the arcpy.ClearWorkspaceCache_management() function, everything worked fine again.

Re: ERROR 000837: The workspace is not the correct workspace type

Chris_Kell — Sun, 01 Oct 2023 02:13:02 GMT

Harshal,

I'm experiencing the same, what was your solution?

Thanks