My Pro project contains an sde connection file called Knight.sde. I am programming in a Notebook. When I call arcpy.Describe on "Knight.sde" it shows me that it is indeed a Workspace and provides the full path to the file. However, the following code yields the following error:
with arcpy.da.Editor("Knight.sde") as eddie:
eddie.startEditing(True, True)
try:
eddie.startOperation()
try:
with arcpy.da.UpdateCursor("Feature Class") as u_cursor:
for row in u_cursor:
# some operation
eddie.stopOperation()
eddie.stopEditing(True)
except:
eddie.abortOperation()
if "row" in locals():
print(row)
raise
except:
eddie.stopEditing(False)
raise
AttributeError Traceback (most recent call last)
In [65]:
Line 2: eddie.startEditing(True, True)
AttributeError: 'Workspace Operation object' object has no attribute 'startEditing'
If I print eddie's type in another cell, it shows 'Workspace Operation object' instead of any kind of editor object. I am totally perplexed, as this pattern of programming has worked in the past. I have tried a number of different parameters to the arcpy.da.Editor constructor and they all yield 'cannot open workspace' errors so I know that "Knight.sde" is the right thing to pass as an argument. Why does my Editor constructor give me a weird Workspace Operation object instead? It's like asking someone for an apple and getting a pinecone instead.
I am using ArcGIS Pro 3.3.1, the latest version available at this time. I use an enterprise geodatabase on Microsoft SQL Server 2019 that is also the latest version of Esri's geodatabase format at this time, 11.3.0.52636. I'm using the default Python environment that comes with Pro.
