nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

JaimeMcKeown

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)

Vind meer berichten getagd met

Accepted answers

MathewCoyle

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", "")

All comments

JaimeMcKeown

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!!!

MathewCoyle

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", "")

JaimeMcKeown

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

MathewCoyle

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')

JaimeMcKeown

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...

MathewCoyle

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

JaimeMcKeown

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'

MathewCoyle

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

JaimeMcKeown

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

MathewCoyle

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

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.