topic Re: can't edit row with arcpy.da.updatecursor in arcmap in Python Questions

can't edit row with arcpy.da.updatecursor in arcmap

BillRichards — Sat, 11 Dec 2021 18:59:47 GMT

I am at a loss! After hours of searching and testing, in Arcmap (10.3) I simpy can't get beyond this error:

RuntimeError: Objects in this class cannot be updated outside an edit session [ContactsAndFaults]

while attempting to open an UpdateCursor. The feature class is in a personal database and I am able to add a field, but not use the following:

uid = fc + "Somestring"
with arcpy.da.UpdateCursor("C:\\arcmaptest\\Paddock_Valley_Reservoir.mdb\\" + fc, ("OID@", uid)) as cursor:
     for row in cursor:
          row[1] = fc + "-" + anotherstring+ "-" + row[0]  # basically append the OBJECTID to the uid string
          cursor.updateRow(row)

Any suggestions?

Re: can't edit row with arcpy.da.updatecursor in arcmap

ModyBuchbinder — Mon, 14 Mar 2016 05:50:13 GMT

If your data is part of something like topology or network it cannot be update without edit session.

You can start edit in ArcMap and then try to run the script.

In general you should try to move from mdb to gdb.

Have fun

Re: can't edit row with arcpy.da.updatecursor in arcmap

NeilAyres — Sat, 11 Dec 2021 18:59:50 GMT

Or wrap your update cursor in something like this :

# open an editor session
edit = arcpy.da.Editor(os.path.dirname(outputDiff)) # dirname of the fc is the db name
edit.startEditing(False, False) # check these setting for your environment
edit.startOperation()
# do the update loop
# stop editing
edit.stopOperation()
edit.stopEditing(True)

Re: can't edit row with arcpy.da.updatecursor in arcmap

BenjaminMittler — Mon, 14 Mar 2016 13:52:09 GMT

I would recommend converting your personal geodatabase to a file geodatabase.

Re: can't edit row with arcpy.da.updatecursor in arcmap

BillRichards — Tue, 15 Mar 2016 16:20:26 GMT

Yes,

Opening the edit session was required as some of the feature classes (tables) in the personal database are participating in topologies. Thanks for the suggestion!