topic RuntimeError: cannot open workspace in Python Questions

RuntimeError: cannot open workspace

ErnestoCarreras3 — Sat, 11 Dec 2021 17:38:11 GMT

Purpose: Edit a versioned feature class within a Feature dataset in order to calculate a field

I have a field called Date to store the date of the inspection (data type: date)

I have another field called Time_Diff (data type: Long). This field is the one that will be used to calculate the time difference between system date and the date recorded in the Date field.

The script keeps failing due to the following runtime error: RuntimeError: cannot open workspace

Any assistance will be greatly appreciated.

# Import arcpy module
import arcpy


# Local variables:
Input_MapChangeRequest = "Database Connections\\GISHW.sde\\gishw.PU.HW_FieldCollection\\gishw.PU.MapChangeRequest"
MapChangeRequest_Layer = "MapChangeRequest_Layer"
MapChangeRequest_layer2 = MapChangeRequest_Layer
MapChangeRequest_Layer__3_ = MapChangeRequest_layer2

# Process: Make Feature Layer
arcpy.MakeFeatureLayer_management(Input_MapChangeRequest, MapChangeRequest_Layer, "", "", "OBJECTID OBJECTID VISIBLE NONE;UTILITY UTILITY VISIBLE NONE;ISSUE ISSUE VISIBLE NONE;ASSET ASSET VISIBLE NONE;CRITICAL CRITICAL VISIBLE NONE;NOTES NOTES VISIBLE NONE;STATUS STATUS VISIBLE NONE;REPORTER REPORTER VISIBLE NONE;DATE DATE VISIBLE NONE;SHAPE SHAPE VISIBLE NONE;created_user created_user VISIBLE NONE;created_date created_date VISIBLE NONE;last_edited_user last_edited_user VISIBLE NONE;last_edited_date last_edited_date VISIBLE NONE;GlobalID GlobalID VISIBLE NONE;Time_Diff Time_Diff VISIBLE NONE")

# Process: Change Version
arcpy.ChangeVersion_management(MapChangeRequest_Layer, "TRANSACTIONAL", "ARCGIS_SERVER.PU_web_editing", "")

# Start an edit session. Must provide the workspace.
edit = arcpy.da.Editor(MapChangeRequest_Layer)

# Edit session is started without an undo/redo stack for versioned data
edit.startEditing(True)

# Start an edit operation
edit.startOperation()

# Process: Calculate Field
arcpy.CalculateField_management(MapChangeRequest_layer2, "Time_Diff", "(datetime.datetime.now() - arcpy.time.ParseDateTimeString( !DATE! )).days", "PYTHON_9.3", "")

# Stop the edit operation.
edit.stopOperation()

# Stop the edit session and save the changes
edit.stopEditing(True)

Re: RuntimeError: cannot open workspace

DanPatterson_Retired — Mon, 04 Apr 2016 17:51:54 GMT

are you missing something in your path? the location of the workspace needs to be explicit in the script from my reading of the help file

Editor—Help | ArcGIS for Desktop

maybe this env—Help | ArcGIS for Desktop needs to be added

Re: RuntimeError: cannot open workspace

ErnestoCarreras3 — Mon, 04 Apr 2016 19:26:44 GMT

I just added the following below Import arcpy and got the same error:

arcpy.env.workspace = "Database Connections\\GISHW.sde\\gishw.PU.HW_FieldCollection"

Re: RuntimeError: cannot open workspace

DanPatterson_Retired — Mon, 04 Apr 2016 19:37:06 GMT

I work locally, I suspect pure python and arcpy knows nothing about your connection

Create Database Connection—Help | ArcGIS for Desktop

so if it has worked in the past, I have no clue... and will defer to those that have to work on networks

Re: RuntimeError: cannot open workspace

ErnestoCarreras3 — Mon, 04 Apr 2016 19:45:14 GMT

Anyways, thanks for you input.

Re: RuntimeError: cannot open workspace

ErnestoCarreras3 — Sat, 11 Dec 2021 17:38:13 GMT

I have modified the script so that it point to the SDE connection locally for the workspace but still I get the same runtime error... any help will he really appreciated . The SDE connection used in the script points to the version where I need to update the data.

# Import arcpy module
import arcpy

conn = r"U:\GIS\GISHW.sde"
arcpy.env.workspace = conn

# Local variables:
Input_MapChangeRequest = r"U:\GIS\GISHW.sde\gishw.PU.HW_FieldCollection\gishw.PU.MapChangeRequest"
MapChangeRequest_Layer = "MapChangeRequest_Layer"

# Start an edit session. Must provide the workspace.
edit = arcpy.da.Editor(MapChangeRequest_Layer)

# Edit session is started without an undo/redo stack for versioned data
edit.startEditing(True)

# Start an edit operation
edit.startOperation()

# Process: Calculate Field
arcpy.CalculateField_management(MapChangeRequest_Layer, "Time_Diff", "(datetime.datetime.now() - arcpy.time.ParseDateTimeString( !DATE! )).days", "PYTHON_9.3", "")

# Stop the edit operation.
edit.stopOperation()

# Stop the edit session and save the changes
edit.stopEditing(True)

Jake Skinner I noticed you commented on a similar question and thought you may be able to assist me with this issue.

Thanks in advance

Re: RuntimeError: cannot open workspace

FreddieGibson — Wed, 06 Apr 2016 13:11:37 GMT

What happens if you supply the workspace instead of the name of the layer from the workspace?

edit = arcpy.da.Editor(conn) or edit = arcpy.da.Editor(arcpy.env.workspace)

Re: RuntimeError: cannot open workspace

ErnestoCarreras3 — Wed, 06 Apr 2016 13:28:28 GMT

It returns the following error even though I have enabled the editing within the script...

arcgisscripting.ExecuteError: ERROR 999999: Error executing function.

Objects in this class cannot be updated outside an edit session [gishw.PU.MapChangeRequest]

Failed to execute (CalculateField).

Re: RuntimeError: cannot open workspace

FreddieGibson — Wed, 06 Apr 2016 14:18:52 GMT

Is the table you're needing to edit registered as versioned?

Re: RuntimeError: cannot open workspace

ErnestoCarreras3 — Wed, 06 Apr 2016 14:21:44 GMT

Yes

Well, it appears it was not. I assumed it got unversioned after adding a new feature class to the Feature Dataset. Is that correct?

Now, the script works as expected.

Thanks a lot!

Re: RuntimeError: cannot open workspace

NeilAyres — Wed, 06 Apr 2016 14:40:14 GMT

Just as a further point here...

It is unwise to have attribute field names which are the same as keywords.

Here we have a field called DATE which is a date type.

You never know when you will get strange things happening with fields like that.

Rather call it ChangeDate or something.