topic Re: Strange Error While Using arcpy.da.UpdateCursor on SDE in Python Questions

Strange Error While Using arcpy.da.UpdateCursor on SDE

Anonymous User — Wed, 16 Feb 2022 13:55:50 GMT

I ran the following code on a gdb target and it worked just fine. Now that I've redirected at an SDE target I am getting an ambiguous error:

def edit_feature_class(structure_data,workspace): fc = "Target Feature" fields = ["Target Field"] descriptions = structure_data["Target Field"].tolist() with arcpy.da.Editor(workspace) as edit: with arcpy.da.UpdateCursor(fc, fields) as cursor: i=0 for row in cursor: row[0] = descriptions[i] cursor.updateRow(row) i = i+1

The error it throws is: with arcpy.da.UpdateCursor(fc, fields) as cursor TypeError Cannot update table

Any help is appreciated,

Thank you

Re: Strange Error While Using arcpy.da.UpdateCursor on SDE

DonMorrison1 — Wed, 16 Feb 2022 14:23:11 GMT

Is "Target Field" really the field name or is it an alias? I think some databases don't allow spaces in the field names....

If the failure is on the updateRow I would add some print or AddMessage statements to dump out descriptions[i] to see which record it is choking on and the contents of the field at that point.

Re: Strange Error While Using arcpy.da.UpdateCursor on SDE

Anonymous User — Wed, 16 Feb 2022 14:35:15 GMT

Target Field just a dumby name I'm using for the purposes of the question, the real name is a single word. The failure is on

with arcpy.da.UpdateCursor(fc, fields) as cursor:

Re: Strange Error While Using arcpy.da.UpdateCursor on SDE

DanPatterson — Wed, 16 Feb 2022 15:18:16 GMT

fc ... is that the full path to the featureclass?

fields ... you have confirmed the field names?

as for the cursor, do you have permissions to create one for the source file?

Re: Strange Error While Using arcpy.da.UpdateCursor on SDE

DonMorrison1 — Wed, 16 Feb 2022 16:31:17 GMT

Another idea is to start removing fields from the list until is starts working, or try a SearchCursor on that feature class- perhaps with just the ['objectid'] field to start with ( assuming you have field called that).

Re: Strange Error While Using arcpy.da.UpdateCursor on SDE

Cristian_Galindo — Tue, 29 Nov 2022 07:40:02 GMT

Hi fellow,

to be hones I do not trust yet in the implementation of arcpy for the use of objects with the function "with",

I would strongly suggest to go in the direction of the old school and use the methods of the editor object:

startOperation ()

stopOperation ()

abortOperation ()

undoOperation ()

redoOperation ()

https://gis.stackexchange.com/questions/158594/using-arcpy-da-editor-correctly

Here ( https://pro.arcgis.com/en/pro-app/latest/arcpy/data-access/editor.htm )

check the Editor Example 2

Re: Strange Error While Using arcpy.da.UpdateCursor on SDE

PantelisKaniouras — Tue, 26 Nov 2024 11:31:58 GMT

Was this resolved?

Re: Strange Error While Using arcpy.da.UpdateCursor on SDE

DaveSivertsenz — Thu, 05 Dec 2024 18:42:28 GMT

Any resolution? I migrated my SDE from MSSQL to PostGres. Update and Insert cursors that worked now fail with TYPEERROR: CANNOT UPDATE THE TABLE. Search cursor works. Connection user has Edit privileges, no schema locks, script uses EDIT session, with or without undo, All fail.PostGres error logs complain pg_dist_node and sde_spatial_references do not exist.

Re: Strange Error While Using arcpy.da.UpdateCursor on SDE

DaveSivertsenz — Wed, 11 Dec 2024 12:16:35 GMT

Please ignore my previous comment. Migration removes versioning settings at the geodatabase, feature dataset, feature class and table level. Scripts with update cursors (multiuser mode) that worked on the previous versioned database will fail, until versioning is rebuilt, or modified for unversioned data.