[GIS] Compress – ERROR 000837: The workspace is not the correct workspace type

arcmaparcpy

Getting an error with a very simple compress script.

This script works perfectly fine within arcmap, but I want to make this into a scheduled recurring script.

import arcpy
from arcpy import env

env.workspace = r"\\UNC PATH \dbconnection.sde"
arcpy.Compress_management(r"\\UNC PATH \dbconnection.sde")

Super simple. I've tried importing arceditor in order to set the product for ArcGIS Desktop standard, to no avail. I've also attempted to run:

arcpy.ClearWorkspaceCache_management()

before setting env.workspace, but still doesn't work. I have also tried different variations of the UNC path, such as specifying parent folder in workspace and then only the .sde in the compress, etc…

All errors come out as the one in the title: ERROR 000837: The workspace is not the correct workspace type.

Best Answer

Hate to answer my own question. But I found the culprit of the problem.

I had a co-worker copy over their python27 directory, which is the one specifically created by ArcDesktop during installation (I realized I had forgot mine had gotten uninstalled, and then reinstalled by a standard python27 install).

According to ESRI's help, you should just have to point your python installation to include site-packages from the ARCGISDesktop/arcpy, bin, and scripting directories. This doesn't seem entirely true. I noticed a difference in the python27/DLLs folder, where there were 3 files (all starting with nc*) that were arcpy related. I copied those from his directory to mine, and it now works perfectly.

Not sure what these files do, as I haven't taken the time to go through them. I'm also not sure why this would throw a workspace error, when it should throw something more specific to a file missing error.

Related Solutions

[GIS] Creating empty feature class in file geodatabase based on schema of ArcSDE feature class

Just use the CreateFeatureClass tool, passing the original feature class as the template argument. Grab the shape type from the Describe object of the input feature class.

Unlike the other answer, this won't copy a bunch of unnecessary records only to delete them right away.

import arcpy
arcpy.env.workspace= 'MyGDB.gdb'
fcs = arcpy.ListFeatureClasses()
output = "OutGDB.gdb"
for fc in fcs:
    geom = arcpy.Describe(fc).shapeType
    arcpy.CreateFeatureclass_management(output, fc, geom, fc, spatial_reference=fc)

UPDATE:

If you need to preserve domains/subtypes, then run Select_analysis using a generic where clause that will capture none of the records, like OBJECTID < 0:

import os, arcpy
arcpy.env.workspace= 'MyGDB.gdb'
fcs = arcpy.ListFeatureClasses()
output = "OutGDB.gdb"
wc = 'OBJECTID < 0'
for fc in fcs:
    fc_out = os.path.join(output, fc)
    arcpy.Select_analysis(fc, fc_out, wc)

This is far more efficient than copying all the records and then deleting them. I've yet to find an approach that will preserve editor tracking.

ArcObjects – Running ArcPy Script from ArcObjects in ArcGIS Desktop

There may be several options. If you package your script into a toolbox you could reference your toolbox (and tool) via ArcObjects as such:

 IGeoProcessor2 gp = new GeoProcessorClass();
 gp.AddToolbox(@"C:\YourPath\YourToolbox.tbx");
 parameters.Add(@"C:\YourPath\ParamsIfYouHaveThem.gdb\ParamFC");
 gp.Execute("NameOfYourToolInsideReferencedToolbox", parameters, null);

Or you could try this route:

System.Diagnostics.Process proc = new System.Diagnostics.Process();
proc.StartInfo.FileName = @"C:\path\toYour\script.py";
proc.StartInfo.UseShellExecute = true;
proc.Start()

which is mentioned here: http://forums.esri.com/Thread.asp?c=93&f=993&t=276632

Best Answer

Related Solutions

[GIS] Creating empty feature class in file geodatabase based on schema of ArcSDE feature class

ArcObjects – Running ArcPy Script from ArcObjects in ArcGIS Desktop

Related Question