Re: Objects in this class cannot be updated outside an edit session

Question

Hi All,

I have defined the workspace, started and stopped the edit session, but afterwards, I am getting the Runtime Error (Objects in this class cannot be updated outside an edit session). The layer "CGD. ROAD_LOCATIONS" is versioned.

……….Script (part)……………..

arcpy.env.workspace = r"\Pas215q4\User Connection\GS-0001.database.windows.net(1).sde"

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

if (edit.isEditing!='True'):

edit.startEditing(True, True)

edit.startOperation()

field = ['SECTION_ID']

found_values = defaultdict(set)

with arcpy.da.UpdateCursor("CGD.ROAD_LOCATIONS", field, "[OBJECTID] > 944861") as cursor:

for row in cursor:

for i, column in enumerate(field):

if row[i] in found_values[column]:

cursor.deleteRow()

break

else:

for column, value in zip(field, row):

found_values[column].add(value)

edit.stopOperation()

edit.stopEditing(True)

................................

When running this it breaks in (“for row in cursor”), and I am getting the following error message,

………..Error message…………

Traceback (most recent call last):

File "P:\Create_Assets.py", line 152, in <module>

main()

File " P:\Create_Assets.py", line 52, in main

for row in cursor:

RuntimeError: Objects in this class cannot be updated outside an edit session [CGD. ROAD_LOCATIONS]

No issue with the indentation, maybe I have missed the proper indent here as I am typing it manually. No issue with the script while running from the admin account, but other user accounts is experiencing the run-time issue.

Great to have your suggestions on how to solve this issue please.

Kind regards,

Shahriar

AriLukas2 · Answer

I realize this is an old post but was wondering if solution recommended by Katy worked. I am having a similar issue when trying to append data from a file geodatabase to an sde; getting an ERROR 160250: Objects in this class cannot be updated outside an edit session.

m_RemovedSigns = r"C:\...\SignStaging.gdb\RemovedSigns_Stage"

m_StreetSigns_sde = r"C:\...\COGAdmin@sdeCity.sde\sdeCity.COGADMIN.StreetSigns"

m_RemovedSigns_sde = r"C:\...\COGAdmin@sdeCity.sde\sdeCity.COGADMIN.AbandonedFeaturesGDOT\sdeCity.COGADMIN.RemovedSigns"

m_workspace = r"C:\...\COGAdmin@sdeCity.sde"
m_schemaType = "NO_TEST"

def append_features():
    global m_RemovedSigns
    global m_RemovedSigns_sde
    global m_workspace

# Begin editing
    edit = arcpy.da.Editor(m_workspace)
    edit.startEditing(False, True)
    edit.startOperation()

try:
        arcpy.Append_management(m_RemovedSigns, m_RemovedSigns_sde, 
        m_schemaType)
        print("Appended selected records to RemovedSigns.")
    except Exception as ex:
        print("ERROR appending features: " + str(ex))

edit.stopOperation()
    edit.stopEditing(True)

Any insight would be greatly appreciated.

KatyFlaherty · Answer

Hello Joshua,

I hit this same error code: ERROR 160250: Objects in this class cannot be updated outside an edit session

As opposed to using arcpy.da.Editor, I found

with arcpy.EnvManager(scratchWorkspace=r"workspace path",workspace=r"workspace path"):

run functions

solved the errors, I tried this without defining the admin login as well.

Scratch Workspace (Environment setting)—ArcGIS Pro | Documentation

I can elaborate, but see if this works

JoshuaBixby · Answer

If it works for admin users and not regular users whether using ArcPy or the GUI, it is permissions related.  The question is whether there is a workflow issue or defect.  Without knowing a bit more about the overall workflow, e.g., versioning steps before you get to the functional code part above, I can't offer much on that front.  I would suggest you have your DBA look at the database logs because there may be errors showing up there that could point you in the right direction.