arcpy.da.InsertCursor locking SDE data base

JeremyLuymes — Thu, 24 Oct 2013 20:06:09 GMT

Hi,

I'm having an issue with using the new da cursors in Arc 10.1. I have a basic script that uses selected features ("watpoints") and copies them to an abandoned layer (watabdev)

arcpy.MakeFeatureLayer_management(point,"watpoints")
with arcpy.da.InsertCursor(watabdev,("SUBTYPE","SHAPE@XY")) as cur:              
    with arcpy.da.SearchCursor("watpoints",["SHAPE@XY"]) as cursor:              
        for row in cursor:
            cur.insertRow((1,row[0]))
del cur, row, cursor

I used with cursors and tried deleting the cursors afterwords. But after I run the tool, arcmap gives me an error that the abandoned layer is in a closed state and I cannot access it.

Any suggestions?

Thanks.

Re: arcpy.ad.InsertCursor locking SDE data base

RichardFairhurst — Sun, 12 Dec 2021 04:51:05 GMT

Hi,

I'm having an issue with using the new da cursors in Arc 10.1. I have a basic script that uses selected features ("watpoints") and copies them to an abandoned layer (watabdev)
arcpy.MakeFeatureLayer_management(point,"watpoints")
with arcpy.da.InsertCursor(watabdev,("SUBTYPE","SHAPE@XY")) as cur:              
    with arcpy.da.SearchCursor("watpoints",["SHAPE@XY"]) as cursor:              
        for row in cursor:
            cur.insertRow((1,row[0]))
del cur, row, cursor
I used with cursors and tried deleting the cursors afterwords. But after I run the tool, arcmap gives me an error that the abandoned layer is in a closed state and I cannot access it.

Any suggestions?

Thanks.

According to the help:

"The advantage of using a With statement is that it will guarantee close and release of database locks and reset iteration regardless of whether the cursor completed successfully or an exception occurred."

That would imply the del statements are not needed. Have you tried the script without them?

topic Re: arcpy.ad.InsertCursor locking SDE data base in Python Questions

arcpy.da.InsertCursor locking SDE data base

Re: arcpy.ad.InsertCursor locking SDE data base