topic Re: Trying to edit a layer in a versioned SDE GDB in a Python stand-alone script in Python Questions

Trying to edit a layer in a versioned SDE GDB in a Python stand-alone script

JaimeMcKeown — Wed, 17 Jul 2013 19:47:29 GMT

Hello everyone,

I am trying to do a simple edit using Calculate field on a layer in a versioned SDE GDB. I've gotten past a few errors, but now have ran into a new one that I can seem to get past. The error is "Objects in this class cannot be updated outside an edit session". I'm trying to use arcpy.da.Editor, but I seem to be missing something. Any ideas would be greatly appreciated!

fc = "Database Connections\\CCENTGIS_SCLFinal_PRSCL_test.sde\\prscl_test.SCLADMIN.GMSCL\\prscl_test.SCLADMIN.sclarc" workspace = "Database Connections\\CCENTGIS_SCLFinal_PRSCL_test.sde"  arcpy.MakeFeatureLayer_management(fc, "sclarc_layer")  edit = arcpy.da.Editor(workspace)  edit.startEditing() edit.startOperation()  with arcpy.da.Editor(workspace) as edit:     arcpy.CalculateField_management("sclarc_layer", "STRNAME", "!strname!.strip", "PYTHON_9.3", "")  edit.stopOperation() edit.stopEditing(True)

Re: Trying to edit a layer in a versioned SDE GDB in a Python stand-alone script

MathewCoyle — Wed, 17 Jul 2013 19:54:29 GMT

I believe you need to set your workspace to your feature dataset, not the general database.

Re: Trying to edit a layer in a versioned SDE GDB in a Python stand-alone script

JaimeMcKeown — Wed, 17 Jul 2013 20:31:56 GMT

When I set the workspace to the dataset I get "runtime error: cannot open workspace".

Re: Trying to edit a layer in a versioned SDE GDB in a Python stand-alone script

MathewCoyle — Wed, 17 Jul 2013 21:06:07 GMT

Are you connected with a version user that can make edits?

Re: Trying to edit a layer in a versioned SDE GDB in a Python stand-alone script

JaimeMcKeown — Thu, 18 Jul 2013 14:09:14 GMT

I'm trying to edit a test version of the database, and it turns out it wasn't setup properly. Now that's fixed and I can edit, but it still won't run properly.

This is my latest error:

Traceback (most recent call last):
File "C:\Python27\ArcGIS10.1\Lib\site-packages\pythonwin\pywin\framework\scriptutils.py", line 326, in RunScript
exec codeObject in __main__.__dict__
File "G:\prscl\appl\Python\Scl_qcarcs_test.py", line 20, in <module>
edit.stopOperation()
AttributeError: 'Workspace Operation object' object has no attribute 'stopOperation'

Re: Trying to edit a layer in a versioned SDE GDB in a Python stand-alone script

MathewCoyle — Thu, 18 Jul 2013 14:22:06 GMT

Ah yes you'll have to have those inside your with statement as afterwards your edit variable is closed automatically.

Re: Trying to edit a layer in a versioned SDE GDB in a Python stand-alone script

JaimeMcKeown — Thu, 18 Jul 2013 15:09:52 GMT

I moved edit.stopOperation() and edit.stopEditing() into the statement and I still get the same error. I'm beginning to think this isn't going to work...

Re: Trying to edit a layer in a versioned SDE GDB in a Python stand-alone script

MathewCoyle — Sun, 12 Dec 2021 01:37:56 GMT

Have you tried removing those lines completely? The help examples shows just the with statement as able to stop and close the edit session automatically.

http://resources.arcgis.com/en/help/main/10.1/index.html#//018w00000005000000

    with arcpy.da.Editor(workspace) as edit:
        arcpy.CalculateField_management(
            layer_name, 'Usage', '"PUBLIC"', 'PYTHON')

Re: Trying to edit a layer in a versioned SDE GDB in a Python stand-alone script

JaimeMcKeown — Thu, 18 Jul 2013 16:57:21 GMT

I did and it still doesn't work, very frustrating...

Re: Trying to edit a layer in a versioned SDE GDB in a Python stand-alone script

MathewCoyle — Thu, 18 Jul 2013 17:14:07 GMT

Can you post your code you are running again? The only lines you should need are these

import arcpy workspace = "Database Connections\\CCENTGIS_SCLFinal_PRSCL_test.sde\\prscl_test.SCLADMIN.GMSCL" fc = "prscl_test.SCLADMIN.sclarc" arcpy.env.workspace = workspace arcpy.MakeFeatureLayer_management(fc, "sclarc_layer") with arcpy.da.Editor(workspace) as edit:     arcpy.CalculateField_management("sclarc_layer", "STRNAME", "!strname!.strip", "PYTHON_9.3", "")

Re: Trying to edit a layer in a versioned SDE GDB in a Python stand-alone script

JaimeMcKeown — Sun, 12 Dec 2021 01:37:58 GMT

It finally works! The example you just sent worked once I set the workspace only to the database and not the dataset. The longer way that I was trying also works after I changed the object on the statement. I did'nt realize that I needed to use a differenct object from the one I used above. My boss that hasn't been available for 2 days final came to help as well.

Here are both scripts that finally worked.

import arcpy
workspace = "Database Connections\\PRSCL_TEST_SCLAdmin.sde"
fc = "prscl_test.SCLADMIN.sclarc"
arcpy.env.workspace = workspace
arcpy.MakeFeatureLayer_management(fc, "sclarc_layer")
with arcpy.da.Editor(workspace) as edit:
    arcpy.CalculateField_management("sclarc_layer", "STRNAME", "!strname!.upper()", "PYTHON_9.3", "")

import arcpy
workspace = "Database Connections\\PRSCL_TEST_SCLAdmin.sde"
fc = "prscl_test.SCLADMIN.sclarc"
arcpy.env.workspace = workspace
arcpy.MakeFeatureLayer_management(fc, "sclarc_layer")
edit = arcpy.da.Editor(workspace)
edit.startEditing(False, True)
edit.startOperation()
with arcpy.da.Editor(workspace) as fieldEdit:
    arcpy.CalculateField_management(fcLayer, "STRNAME", "!strname!.upper()", "PYTHON_9.3", "")
edit.stopOperation()
edit.stopEditing(True)

Thank you so much for your help!!!