topic Re: automate sde database license: python arcpy's EnableEnterpriseGeodatabase_management returns 000837 error i.e., "...not correct workspace type" no matter how I spedify. Does this command really work? in ArcGIS Enterprise Questions

automate sde database license: python arcpy's EnableEnterpriseGeodatabase_management returns 000837 error i.e., "...not correct workspace type" no matter how I spedify. Does this command really work?

howardfoster — Thu, 05 Mar 2015 00:53:12 GMT

Hi all,

I manage a number of SDE databases and would like to update the yearly re-licensing with a python script. The script model:

import arcpy

arcpy.EnableEnterpriseGeodatabase("C:\myconnections\database1.sde", "C:\authfiles\keycodes")

when the correct path + file references are substituted, always returns the error:

arcgisscripting.ExecuteError: Failed to execute. Parameters are not valid.

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

Failed to execute (EnableEnterpriseGeodatabase).

I've tried the various arcpy.ClearWorkspaceCache_management() and arcpy.env commands as suggested by other posts, but no go.

Thankee, -Howard Foster

Re: automate sde database license: python arcpy's EnableEnterpriseGeodatabase_management returns 000837 error i.e., "...not correct workspace type" no matter how I spedify. Does this command really work?

ModyBuchbinder — Thu, 05 Mar 2015 06:12:10 GMT

Make sure your connection is to SDE user.

This is the user that can update metadata tables.

Habe Fun

Re: automate sde database license: python arcpy's EnableEnterpriseGeodatabase_management returns 000837 error i.e., "...not correct workspace type" no matter how I spedify. Does this command really work?

KishorGhatage — Thu, 05 Mar 2015 12:15:11 GMT

Could you please try this:

import arcpy

arcpy.EnableEnterpriseGeodatabase(r"C:\myconnections\database1.sde", r"C:\authfiles\keycodes")

Options for Authorizing an Enterprise Geodatabase | Support Services Blog

hope this is helpful

Re: automate sde database license: python arcpy's EnableEnterpriseGeodatabase_management returns 000837 error i.e., "...not correct workspace type" no matter how I spedify. Does this command really work?

George_Thompson — Thu, 05 Mar 2015 13:42:00 GMT

Hi Howard,

From what I read in your original post, you want to update the licenses in your enterprise geodatabases?

If so, the Enable tool will not do this. This tool is designed to add the SDE repository tables to an existing database (SQL Server, Oracle, PostgreSQL, etc...)

Enable Enterprise Geodatabase GP Tool

"The Enable Enterprise Geodatabase tool creates geodatabase system tables, stored procedures, functions, and types in an existing enterprise database, thereby enabling geodatabase functionality in the database."

Here is a Blog that talks about updating the enterprise database license

In a nut shell, you must use SDE command line to update the license before it expires.

Please let me know if this is not what you are looking for.

-George

Geodatabase Managing Data

Re: automate sde database license: python arcpy's EnableEnterpriseGeodatabase_management returns 000837 error i.e., "...not correct workspace type" no matter how I spedify. Does this command really work?

TinaMorgan1 — Thu, 05 Mar 2015 14:09:12 GMT

To add to George's comment, here is the workflow to authorize 10.3 SDE where the SDE Command line tools are no longer used...

Options for Authorizing an Enterprise Geodatabase | Support Services Blog