CreateVersion tool doesn't like my workspace

dan.narsavage_IDWR

I've written a Python script that pulls a bunch of feature classes out of SDE into a file GDB on my C: drive, performs a bunch of analysis, then creates a new version on SDE (a child of default), puts the analysis results in the database, reconciles, posts, etc...

This line:

arcpy.CreateVersion_management(DefaultSdeGDB, "sde.DEFAULT", VersionName, "PROTECTED")

used to work fine, but something must have changed somewhere because suddenly the CreateVersion tool fails with the following messages:

arcpy.CreateVersion_management(DefaultSdeGDB, "sde.DEFAULT", VersionName, "PROTECTED")
File "C:\Program Files (x86)\ArcGIS\Desktop10.0\arcpy\arcpy\management.py", line 9192, in CreateVersion
    raise e
arcgisscripting.ExecuteError: Failed to execute. Parameters are not valid.
ERROR 000837: The workspace is not the correct workspace type.
WARNING 000379: The value may not be valid because of empty domain or does not exist in the domain
Failed to execute (CreateVersion).

The "DefaultSdeGDB" variable is a reference to a connection file in ArcCatalog's "Database Connections" folder, and it works when creating references to feature classes earlier in the script.  And it used to work in this function as well.

This happens regardless of whether I'm pointing at our production database or testing database (but they're on the same machine and they're both still running 9.3 while 10 is on my desktop--but that didn't create a problem earlier).  If I delete all the earlier code from the script and run it again (starting with "CreateVersion..."), it works fine.  With that in mind, I've tried setting the "DefaultSdeGDB" variable to 'None,' waiting five seconds, resetting the variable, and retrying the version creation; but that doesn't work either.

Any other ideas?  Thanks in advance.

Dan

BruceCotton

Hi,

I've finally found a fix to the ERROR 000837 in this context.  I was getting this error when reconciling and posting a number of versions in a loop.  It would work the first time but on the second loop, I get the 000837.

I found that I needed to basically reconnect to SDE on each loop (it appears to disconnect after each Rec and Post), so I use the arcpy.ClearWorkspaceCache_management() to clear the connection and reconnect using a simple function.

# Set up database connection as a repeatable process to prevent connection problems during looping
def connectWorkspace (cw):
    arcpy.env.workspace = originalWksp
    theWS = arcpy.env.workspace
    return theWS

# Set original workspace variable
originalWksp = arcpy.GetParameterAsText(0)

# Then just before each occurance of the "Reconcile and Post" line of code
# Clear connection and reconnect to avoid "ERROR 000837: The workspace is not the correct type"

    arcpy.ClearWorkspaceCache_management ()
    theWS = connectWorkspace (originalWksp)

Cheers,
Bruce

PS Note that the 3 lines of function code need to be indented, but just don't disply that way on this web page.