Edit Versioned Feature Class in python

Question

I have a versioned feature class in sde that is the source of a map service.  I can open the feature class in arc map, start an edit session, make edits and save those edits.  However, if I try to start an edit session in an arcpy script I get a schema lock.  I'm using the same user and sde connection file.  Shouldn't I be able to edit this feature class in arcpy?

BrendanDwyer · Answer

Jake,

Thanks for responding.  I ended up using the append tool instead.

The idea is that another department posts an excel file online and we want to update a feature class with the new data.  We want to completely replace the existing records with the new data.  So I am using the delete rows tool then the append tool instead of opening an edit session with a data access cursor.

jskinner · Answer

Hi Brendan,

Can you post the code you are using?  Here is an example of editing a versioned feature class:

import arcpy
import os

fc = 'Database Connections/VECTOR@SQLSERVER.sde/AddressPts'
workspace = os.path.dirname(fc)

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

# Edit session is started without an undo/redo stack for versioned data
#  (for second argument, use False for unversioned data)
edit.startEditing(False, True)

# Start an edit operation
edit.startOperation()

# Insert a row into the table.
with arcpy.da.InsertCursor(fc, ('SHAPE@', 'Address')) as icur:
    icur.insertRow([(601181.055124, 762555.994028), '120 Main St'])

# Stop the edit operation.
edit.stopOperation()

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