Multiple Editor Cursors on Same Table

mpboyle — Mon, 19 Feb 2018 21:08:51 GMT

Is it possible to have multpile arcpy.da.Editor cursors run on the same enterprise feature class / table simultaneously? I have a few scripts that are setup to insert a row into the same table. There are times when a script may run longer than expected and there will be multiple scripts running at the same time. Through testing it seems like the first script will not have an issue and insert a row without a problem, however, the second script may (or may not) throw an error on startEditing().

This dataset is versioned, so I'm using startEditing(True, True) for the parameters. I do use del to delete the Editor cursor once stopEditing() has finished.

I'm wondering a couple things:

1) First of all, is having multiple arcpy.da.Editor instances running on the same table an issue?

2) Is startEditing(True, True) the correct / recommended set of parameters to use?

Re: Multiple Editor Cursors on Same Table

JoshuaBixby — Tue, 20 Feb 2018 14:18:48 GMT

Although it can be beneficial at times to have the scripted workflow different than the corresponding manual/user workflow, in this case I think the scripted workflow should follow the same steps. If there is a chance that scripts can overlap, I would Create Version—Help | ArcGIS Desktop , Editor—Help | ArcGIS Desktop , and Reconcile Versions—Help | ArcGIS Desktop .

topic Re: Multiple Editor Cursors on Same Table in Python Questions

Multiple Editor Cursors on Same Table

Re: Multiple Editor Cursors on Same Table