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; } } }

Why UpdateCursor Returns- RuntimeError: workspace already in transaction mode

DevinUnderwood3

I am trying to use an UpdateCursor to update a feature class by referencing a Search Cursor.

Here is a sample of my code. Note that I consulted the following ESRI document https://support.esri.com/en/technical-article/000019111 to troubleshoot. The feature class is registered as versioned and I created the cursor as an object as opposed to a loop. Edit.startEditing is set to False ,False as suggested in the ESRI document.

<SPAN class="keyword token">import</SPAN> arcpy

arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'Database Connections\THIS IS A VERSION'</SPAN>

<SPAN class="comment token"># Create variables </SPAN>
FC1 <SPAN class="operator token">=</SPAN> r'Database Connections\<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>
FC2 <SPAN class="operator token">=</SPAN> r'Database Connections\<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN> 
fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'A'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'B'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'C'</SPAN><SPAN class="punctuation token">]</SPAN> expression <SPAN class="operator token">=</SPAN> <SPAN class="string token">"B = 6"</SPAN>

<SPAN class="comment token">#Search Cursor for item 1 </SPAN>
scursor <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>FC2<SPAN class="punctuation token">,</SPAN>fields<SPAN class="punctuation token">,</SPAN>where_clause<SPAN class="operator token">=</SPAN>expression<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Process: Start Edit   </SPAN>
edit <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>Editor<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace<SPAN class="punctuation token">)</SPAN>   
edit<SPAN class="punctuation token">.</SPAN>startEditing<SPAN class="punctuation token">(</SPAN><SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">)</SPAN>   
edit<SPAN class="punctuation token">.</SPAN>startOperation<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># UpdateCursor for item 2 </SPAN>
cursor <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>FC1<SPAN class="punctuation token">,</SPAN> fields<SPAN class="punctuation token">)</SPAN> 
<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>             
row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> scursor<SPAN class="punctuation token">[</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>              
cursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>             
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>u<SPAN class="string token">'{0},{1},{2}'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">del</SPAN> row 
<SPAN class="keyword token">del</SPAN> cursor

edit<SPAN class="punctuation token">.</SPAN>stopOperation<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> 
edit<SPAN class="punctuation token">.</SPAN>stopEditing<SPAN class="punctuation token">(</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Encuentra más publicaciones etiquetadas con

Accepted answers

EQTAdmin

Hi Devin,

Not sure exactly how you're trying to update fc1 from fc2, but if the B field is the unique identifier between the two this could be a solution for you.

import arcpy

arcpy.env.workspace = r'Database Connections\THIS IS A VERSION'

# Create variables

FC1 = r'Database Connections\...

FC2 = r'Database Connections\...

fields = ['A','B','C']

# removed expression to pull all values from FC2

# expression = "B = 6"

# empty dictionary to hold values from FC2

# assuming B field is unique and is used as field to update FC1

# use with, populate dictionary, then search cursor closes automatically

fc2_lookup = {}

with arcpy.da.SearchCursor(FC2, fields) as cursor:

for row in cursor:

# create variables to hold row values

# not necessary, but helps with readability

a = row[0]

b = row[1]

c = row[2]

# B field is key to find other field values in list

fc2_lookup[b] = ["A": a, "C": c]

# Process: Start Edit

edit = arcpy.da.Editor(arcpy.env.workspace)

edit.startEditing(False,False)

edit.startOperation()

# use with again for updatecursor

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

for row in cursor:

# FC1 fields to variables

a = row[0]

b = row[1]

c = row[2]

print("initial row: A: {}, B: {}, C:{}".format(a, b, c))

# check B column to see if it's in lookup

if b in fc2_lookup:

# update a field in row using values from dictionary

row[0] = fc2_lookup[b]["A"]

row[2] = fc2_lookup[b]["C"]

print("updated row: A: {}, B: {}, C:{}".format(row[0], row[1], row[2]))

cursor.updateRow(row)

else:

# depending on data you might want to investigate why it's missing

print('{} not found in lookup'.format(b))

# don't need to delete, with statement cleans these up

# del row

# del cursor

edit.stopOperation()

edit.stopEditing(True)

All comments

DevinUnderwood3

I modified the script as seen in my provided script to suit my needs. There is only one thing I would like to change. The actual field that I want to change an attribute must match the exact naming for FC1 and FC2. I want to set it up so that the each field NAME can be different.

import arcpy
arcpy.env.workspace = (r'Database Connections...')

# Create variables
FC1 = r'Database Connections\...
FC1_fields = ['INVENTORYID','SAMPLE']
#expression = "INVENTORYID = 1"

FC2 = r'Database Connections\...'
FC2_fields = ['INVENTORYID','ANOTHERSAMPLE']

# Create empty dictionary to hold INVENTORYID values from FC2
# Create Search Cursor
# Populate dictionary, then search cursor closes automatically

fc2_lookup = {}
with arcpy.da.SearchCursor(FC2, FC2_fields) as cursor:
   for row in cursor:
      # create variables to hold row values
      # not necessary, but helps with readability
      a = row[0] # INVENTORYID
      b = row[1]

# Used to look up existing INVENTORYID values in list
fc2_lookup = {"INVENTORYID": a, "B":b}

# Process: Start Edit
edit = arcpy.da.Editor(arcpy.env.workspace)
edit.startEditing(False,True)
edit.startOperation()

# use with again for updatecursor
with arcpy.da.UpdateCursor(FC1, FC1_fields) as cursor:
for row in cursor:

      # FC1 fields to variables
      a = row[0] # INVENTORYID
      b = row[1]
      print("initial row: INVENTORYID: {}, B: {}".format(a, b))

# check A column to see if INVENTORYID is in lookup (FC2)
if a in fc2_lookup:

         # update a field in row using values from dictionary
         #row[0] = fc2_lookup["A"]
         row[1] = fc2_lookup["B"] # is INVENTORYID which look to see if match and ["B"] is the Dictionary Key value for what will be updated.
         print("updated row: B: {}".format(row[1]))
         cursor.updateRow(row)
      else:
         # depending on data you might want to investigate why it's missing
         print('INVENTORYID {} not found in lookup'.format(a))

edit.stopOperation()
edit.stopEditing(True)

print "done"

JoshuaBixby

I think the following over simplifies the situation:

You can't use multiple cursors at the same time.

For starters, you can have as many search cursors as you like accessing the same data set at the same time. It may be your statement was meant for update cursors, but it is also possible to have many update and insert cursors pointing to the same data set at the same time with one big caveat. The way Esri has implemented its update and insert cursors, a user needs to have an edit session open (arcpy.da.Editor) to manipulate data simultaneously through multiple cursors.

DevinUnderwood3

Thank you for providing the sample code. I incorporated it into my script and it worked exactly as I wanted.

JohannesLindner

<SPAN class="comment token"># Just FYI:</SPAN>

<SPAN class="comment token"># instead of this:</SPAN>
<SPAN class="keyword token">with</SPAN> <SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
        a <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
        b <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
        c <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN>
        <SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>

<SPAN class="comment token"># you can just do this:</SPAN>
<SPAN class="keyword token">with</SPAN> <SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">for</SPAN> a<SPAN class="punctuation token">,</SPAN> b<SPAN class="punctuation token">,</SPAN> c <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
        <SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JohannesLindner

You can't use multiple cursors at the same time. it MIGHT be possible, but in most cases it raises an error like the RuntimeError you got.

The way to do this is to first pull the information from FC2 with a SearchCursor and then use an UpdateCursor to write the matching records into FC1.

To find the matching records, a dictionary is the best way. See Jason's answer below.

EQTAdmin

Hi Devin,

Not sure exactly how you're trying to update fc1 from fc2, but if the B field is the unique identifier between the two this could be a solution for you.

import arcpy

arcpy.env.workspace = r'Database Connections\THIS IS A VERSION'

# Create variables

FC1 = r'Database Connections\...

FC2 = r'Database Connections\...

fields = ['A','B','C']

# removed expression to pull all values from FC2

# expression = "B = 6"

# empty dictionary to hold values from FC2

# assuming B field is unique and is used as field to update FC1

# use with, populate dictionary, then search cursor closes automatically

fc2_lookup = {}

with arcpy.da.SearchCursor(FC2, fields) as cursor:

for row in cursor:

# create variables to hold row values

# not necessary, but helps with readability

a = row[0]

b = row[1]

c = row[2]

# B field is key to find other field values in list

fc2_lookup[b] = ["A": a, "C": c]

# Process: Start Edit

edit = arcpy.da.Editor(arcpy.env.workspace)

edit.startEditing(False,False)

edit.startOperation()

# use with again for updatecursor

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

for row in cursor:

# FC1 fields to variables

a = row[0]

b = row[1]

c = row[2]

print("initial row: A: {}, B: {}, C:{}".format(a, b, c))

# check B column to see if it's in lookup

if b in fc2_lookup:

# update a field in row using values from dictionary

row[0] = fc2_lookup[b]["A"]

row[2] = fc2_lookup[b]["C"]

print("updated row: A: {}, B: {}, C:{}".format(row[0], row[1], row[2]))

cursor.updateRow(row)

else:

# depending on data you might want to investigate why it's missing

print('{} not found in lookup'.format(b))

# don't need to delete, with statement cleans these up

# del row

# del cursor

edit.stopOperation()

edit.stopEditing(True)

DevinUnderwood3

Thank you for providing your response. Can you explain how your example includes feature class 1 in a search cursor which will be referenced in the update cursor feature class 2 ? Copying from feature class 1 to feature class 2 attribute information.

DevinUnderwood3

I wanted to copy all records information from FC1 field 1 to FC2 matching field.

JohannesLindner

It's not really clear to me what you're trying to do. You extract 3 fields from FC2 with a query. What do you want to do to FC1 and how does FC1 relate to FC2?

Anyway, this won't work:

row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> scursor<SPAN class="punctuation token">[</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>     <SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

arcpy.da.SearchCursor returns a generator object, not an iterable (like a list). You can turn the generator into a list, though:

generator <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>FC2<SPAN class="punctuation token">,</SPAN>fields<SPAN class="punctuation token">,</SPAN>where_clause<SPAN class="operator token">=</SPAN>expression<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>generator<SPAN class="punctuation token">)</SPAN>

actual_rows <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>row <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> generator<SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>actual_rows<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># or short, because you probably don't need the generator:</SPAN>
actual_rows <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>row <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>FC2<SPAN class="punctuation token">,</SPAN> fields<SPAN class="punctuation token">,</SPAN> expression<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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