AnsweredAssumed Answered

Editing data in Non Versioned SDE using python with a updatecursor

Question asked by JenniferSherry on Jan 12, 2017
Latest reply on Jan 12, 2017 by rastrauch

I have a python script that calculates  x coordinates , y coordinates for a point geometry that sits within a feature dataset of an SDE (SQL Express). The script worked fine on a file geodatabase however when it runs on the SDE feature class, it stalls at the updateCursor function.

 

"ERROR: 999999: Error executing function....Objects in the class cannot be updated outside an edit session [FSB.DBO.Structures]"  

 

The script breaks on updCursor.updateRow(row):

 

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

edit.startEditing(False, True)
edit.startOperation()

updCursor = arcpy.UpdateCursor(projectedFC,"", spatialRef)
for row in updCursor:
    pnt = row.Shape.getPart(0)
    row.POINT_X = pnt.X
    row.POINT_Y = pnt.Y
    updCursor.updateRow(row)

del updCursor, row

edit.stopOperation()
edit.stopEditing(True)

 

 

 

 

If anyone has any information, ideas or input on editing data in non versioned SDE with a updatecursor using python it would be greatly appreciated. 

Outcomes