Editing data in Non Versioned SDE using python with a updatecursor

2209
4
01-12-2017 09:46 AM
JenniferMcCarthy
New Contributor

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. 

0 Kudos
4 Replies
RebeccaStrauch__GISP
MVP Esteemed Contributor

Jennifer, it would help if you look at https://community.esri.com/people/curtvprice/blog/2014/09/25/posting-code-blocks-in-the-new-geonet?s...‌   and repost your code.  Spacing/indenting is critical in python and debugging for other is hard when that would be the issue. 

0 Kudos
JenniferMcCarthy
New Contributor

Thank you Rebecca, the changes have been made!

0 Kudos
RebeccaStrauch__GISP
MVP Esteemed Contributor

I would look thru the samples Editor—Help | ArcGIS for Desktop    but with a quick look, I would suggest 1) full path to the feature class, and 2) you may need to use MakeFeatureLayer.

but if you are just trying to update coordinates values in the table (not moving the points themselves)  maybe look at

Add XY Coordinates—Help | ArcGIS for Desktop 

or Add Geometry Attributes—Help | ArcGIS for Desktop 

0 Kudos
CamMuller
Esri Contributor

Hi Jennifer McCarthy‌ the below should work on a Non-Versioned SDE Geodatabase:

# Start an edit session. Must provide the workspace.
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(True, False)

with arcpy.da.UpdateCursor("Your Parameters") as cursor:
    # Start an edit operation
    edit.startOperation()
    for row in cursor:

    # Your Code Here
# Stop the edit operation.
edit.stopOperation()

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