ERROR 000301: The workspace is of the wrong type

LarryAdgate — Thu, 06 Jul 2017 20:15:59 GMT

This script is far from perfect, but I'm getting a very strange error message and I was hopeful someone could help me solve the issue. Thank You for your time:

import arcpy
import sys
import os
import time, datetime
#import pyodbc
import traceback

# \\\\Constant Vars\\\\
# Database Connection
editDB ="Database Connections/EdnaRoad_Admin.sde"
# Current Day
Day = time.strftime("%m-%d-%Y", time.localtime())
# Current Time
Time = time.strftime("%I:%M:%S %p", time.localtime())

# \\\\pyodbc.connect vars\\\\
#sqlsvrname = 'gisavglis'
#sqldbname = 'Arden'
loggingTableName = "dbo.PYTHON_SCRIPT_LOGGING"

# Set workspace
workspace = editDB

# Set the workspace environment
arcpy.env.workspace = workspace
arcpy.env.overwriteOutput = True

def log_messages(scriptName,Status, ErrorCode):
    runDate = datetime.datetime.fromtimestamp(time.time()).strftime('%Y-%m-%d %H:%M:%S')
    egdb_conn = arcpy.ArcSDESQLExecute(workspace)
    sql = "INSERT INTO {4} (ScriptName,RunDate,Status,ErrorCode) VALUES ('{0}','{1}','{2}','{3}')".format(scriptName, runDate, Status, ErrorCode, loggingTableName)
    try:
        egdb_conn.startTransaction()
        print("Attempt to execute SQL Statement: {0}".format(sql))
        egdb_return = egdb_conn.execute(sql)
        egdb_conn.commitTransaction()
    except Exception as err:
        print(err)
        egdb_return = False

try:
# Start Time
print 'Process Started at ' + str(Day) + " " + str(Time)

    # block new connections to the working and prod database.
    print "Blocking Connections..."
    arcpy.AcceptConnections(editDB, False)

    # disconnect all users from the working and prod database.
    print "Disconnecting Users..."
    arcpy.DisconnectUser(editDB, "ALL")

# Get a list of all versions besides QAQC and DEFAULT to pass into the ReconcileVersions tool.
ver1List = [ver1.name for ver1 in arcpy.da.ListVersions(editDB) if ver1.name != 'DBO.Quality Control' and ver1.name != 'dbo.DEFAULT']

    # Execute the ReconcileVersions tool with QAQC Target Version then delete all versions besides QAQC
    print "Reconcile/post versions to Quality Control...."
    arcpy.ReconcileVersions_management(editDB, "ALL_VERSIONS", "DBO.Quality Control", ver1List, "LOCK_ACQUIRED", "NO_ABORT", "BY_OBJECT", "FAVOR_EDIT_VERSION", "POST", "")

# Extract QAQC version from the list of versions to pass to ReconcileVersions tool.
ver2List = [ver2.name for ver2 in arcpy.da.ListVersions(editDB) if ver2.name == 'DBO.Quality Control']

    # Execute the ReconcileVersions tool with DEFAULT Target Version and delete QAQC version
    print "Reconcile/post Quality Control to DEFAULT..."
    arcpy.ReconcileVersions_management(editDB, "ALL_VERSIONS", "dbo.DEFAULT", ver2List, "LOCK_ACQUIRED", "NO_ABORT", "BY_OBJECT", "FAVOR_EDIT_VERSION", "POST", "")

    print("==============================")
    print ("Unregister Tables Started")
    print("==============================")
#                                                   **** wildcards for tables I don't want to include ****
    for tbs in [tb for tb in arcpy.ListTables() if '_log' not in tb and 'GenerateId' not in tb and 'PYTHON_SCRIPT' not in tb]:
        print tbs
        arcpy.UnregisterAsVersioned_management(tbs,"NO_KEEP_EDIT","COMPRESS_DEFAULT")

# If you want to include all tables in the database use this instead:
#    for tbs in arcpy.ListTables():
#       print tbs
#       arcpy.UnregisterAsVersioned_management(tbs,"NO_KEEP_EDIT","COMPRESS_DEFAULT")

    print("==============================")
    print ("Unregister Feature Classes is started")
    print("==============================")

    datasets = arcpy.ListDatasets("*", "Feature")
    for dataset in datasets:
        fcList = arcpy.ListFeatureClasses("*","",dataset)
        for fc in fcList:
            print fc
            arcpy.UnregisterAsVersioned_management(fc,"NO_KEEP_EDIT","COMPRESS_DEFAULT")

    # Run the compress tool.
    print "Compressing database..."
    arcpy.Compress_management(editDB)

# \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ script initiation, Rec/Post process error handling \\\\\\\\\\\\\\\\\\\\\\\\\\\\\

except:
    print 'An error occured'
    failMsg = '\nSCRIPT FAILURE IN SCRIPT INITIATION OR RECONCILE-POST PROCESS, \n'
    failMsg += 'Most recent GP messages below.\n'
    failMsg += arcpy.GetMessages() +'\n'
    failMsg += '\nTraceback messages below.\n'
    failMsg += traceback.format_exc().splitlines()[-1]
    print failMsg
    #write error log info
    print 'Logging error to database....'
# THIS SECTION FOR LOGGING ERRORS TO A DB TABLE
    log_messages('ReconcilePost_AssetIDs_QAQC','Failure', failMsg)
    sys.exit()

# ////////////////////////////////////// REGISTER AS VERSIONED AND RE-CREATE VERSIONS /////////////////////////////////

try:
    print("==============================")
    print ("register tables is started")
    print("==============================")
    #                                                   **** wildcards for tables I don't want to version ****
    for tbs in [tb for tb in arcpy.ListTables() if '_log' not in tb and 'GenerateId' not in tb and 'PYTHON_SCRIPT' not in tb]:
        print tbs
        arcpy.RegisterAsVersioned_management(tbs, "NO_EDITS_TO_BASE")

# If you want to include all tables in the database use this:
#    for tbs in arcpy.ListTables():
#       print tbs
#       arcpy.RegisterAsVersioned_management(tbs, "NO_EDITS_TO_BASE")

    print("==============================")
    print ("register Feature Class is started")
    print("==============================")

    datasets = arcpy.ListDatasets("*", "Feature")
    for dataset in datasets:
        fcList = arcpy.ListFeatureClasses("*","",dataset)
        for fc in fcList:
            print fc
            arcpy.RegisterAsVersioned_management(fc, "NO_EDITS_TO_BASE")

    # create versions
    #print "Creating Versions..."
    #arcpy.CreateVersion_management(editDB, 'dbo.DEFAULT', 'QAQC', 'PRIVATE')
    #arcpy.CreateVersion_management(editDB, 'DBO.QAQC', 'MICHAEL', 'PUBLIC')
    #arcpy.CreateVersion_management(editDB, 'DBO.QAQC', 'KAREN', 'PUBLIC')
    #arcpy.CreateVersion_management(editDB, 'DBO.QAQC', 'COLLECTOR', 'PUBLIC')

# /////////////////////////////////// ANALYZE DATASETS AND CALC STATISTICS /////////////////////////////////////

# NOTE: Rebuild indexes can accept a Python list of datasets.

    # Get a list of all the datasets the user has access to.
    # First, get all the stand alone tables, feature classes and rasters.
    dataList = arcpy.ListTables() + arcpy.ListFeatureClasses() + arcpy.ListRasters()

    # Next, for feature datasets get all of the datasets and featureclasses
    # from the list and add them to the master list.
    for dataset in arcpy.ListDatasets("*", "Feature"):
        arcpy.env.workspace = os.path.join(workspace, dataset)
        dataList += arcpy.ListFeatureClasses() + arcpy.ListDatasets()

# reset the workspace
arcpy.env.workspace = workspace

# Concatenate all datasets into a list
datasetList = [ds for ds in dataList]

    print "rebuilding indexes"
    # Execute rebuild indexes
    # Note: to use the "SYSTEM" option the workspace user must be an administrator.
    arcpy.RebuildIndexes_management(workspace, "SYSTEM", datasetList, "ALL")
    print('Rebuild Complete')

    print "analyzing datasets"
    arcpy.AnalyzeDatasets_management(workspace, "SYSTEM", datasetList, "ANALYZE_BASE", "ANALYZE_DELTA", "ANALYZE_ARCHIVE")
    print "analysis complete"

    #Allow the database to begin accepting connections again
    print "Set databases to allow connections..."
    arcpy.AcceptConnections(editDB, True)

# \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ If Script Successful, log into database \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\

print 'Data has been synched succesfully and logged in the tracking database'

#     conn = pyodbc.connect('Trusted_Connection=yes', driver='{SQL Server}', server="ggogisapp1.scwater.com", database= "Database Connections/Arden.Admin.sde, ALL")
#     cursor = conn.cursor()
#     # You will need to create a table in sql to log to and add fields that you want to log into and pass them as params to this cursor
#     cursor.execute("""INSERT INTO [dbo].[PYTHON_SCRIPT_TRACKER] (ScriptName,RunDate,Status,ErrorCode) VALUES ('ReconcilePost_AssetIDs_QAQC',GetDate(),'Success','All Steps Completed Without Error'); """)
#     conn.commit()
#     del cursor
#     conn.close()
#     print 'Script is finished'

# /////////////////////////////////Register as Versioned Error handling area////////////////////////////////////////////

except:
    print 'An error occured'
    failMsg = '\nSCRIPT FAILURE IN VERSIONING PROCESS\n'
    failMsg += 'Most recent GP messages below.\n'
    failMsg += arcpy.GetMessages() +'\n'
    failMsg += '\nTraceback messages below.\n'
    failMsg += traceback.format_exc().splitlines()[-1]
    print failMsg
    #write error log info
    print 'Logging error to database....'
    # THIS SECTION FOR LOGGING ERRORS TO A DB TABLE
    log_messages('ReconcilePost_AssetIDs_QAQC','Failure', failMsg)
    conn = pyodbc.connect('Trusted_Connection=yes', driver='{SQL Server}', server=sqlsvrname, database=sqldbname)
    cursor = conn.cursor()
    #You will need to create a table in sql to log to and add fields that you want to log into and pass them as params to this cursor
    cursor.execute("""INSERT INTO [dbo].[PYTHON_SCRIPT_TRACKER] (ScriptName,RunDate,Status,ErrorCode) VALUES ('ReconcilePost_AssetIDs_QAQC',GetDate(),'Failure',(?)); """,failMsg)
    conn.commit()
    conn.close()
    sys.exit()

print "Script has run its course and is now complete"

Re: ERROR 000301: The workspace is of the wrong type

DanPatterson_Retired — Thu, 06 Jul 2017 20:25:07 GMT

Larry you might want to format your code it is tough to follow

Re: ERROR 000301: The workspace is of the wrong type

Lake_Worth_BeachAdmin — Wed, 19 Jul 2017 12:41:07 GMT

same error I am getting and my workspace is set up just like yours. weird it works on one script but one a new one it doesnt

Re: ERROR 000301: The workspace is of the wrong type

LarryAdgate — Wed, 19 Jul 2017 15:11:43 GMT

Thanks Joe for your response, yes it is a very strange Error and frustrating-Any solutions?

Re: ERROR 000301: The workspace is of the wrong type

JoshuaBixby — Wed, 19 Jul 2017 16:58:55 GMT

What part of the code is generating the error? When debugging, I find it most effective to remove try:except statements so you can see exactly where the code is failing and the stack information.

Re: ERROR 000301: The workspace is of the wrong type

Lake_Worth_BeachAdmin — Wed, 19 Jul 2017 17:04:17 GMT

for me its the arcpy.ReconcileVersions_management command. there error is

ExecuteError: ERROR 000301: The workspace is of the wrong type
Failed to execute (ReconcileVersions).

Re: ERROR 000301: The workspace is of the wrong type

Lake_Worth_BeachAdmin — Wed, 19 Jul 2017 17:34:30 GMT

0down vote accept

I found out what was causing my error.

The 2 versions I am working with (parent and child) were created by another user of the SDE(not admin).

This caused the version names to be formatted differently rather than the norm "sde.version_name". In this case part of the version name is formatted as follows "domain\username".version_name so since this is a string parameter you must enter it as: '"domain\username".version_name'

topic Re: ERROR 000301: The workspace is of the wrong type in Python Questions

ERROR 000301: The workspace is of the wrong type

Re: ERROR 000301: The workspace is of the wrong type

Re: ERROR 000301: The workspace is of the wrong type

Re: ERROR 000301: The workspace is of the wrong type

Re: ERROR 000301: The workspace is of the wrong type

Re: ERROR 000301: The workspace is of the wrong type

Re: ERROR 000301: The workspace is of the wrong type

Re: ERROR 000301: The workspace is of the wrong type