topic Re: Item not found in this collection error - UpdateCursor on Query Table in Python Questions

Item not found in this collection error - UpdateCursor on Query Table

DanEvans — Sat, 11 Dec 2021 11:45:14 GMT

The following code:

with arcpy.da.UpdateCursor("QueryTable", ("SHAPE", "leakage_with_pon_list_Eastings", "leakage_with_pon_list_Northings", "leakage_with_pon_list_RandomNumber")) as cursor:
  for row in cursor:
  row[1] = row[0].positionAlongLine(row[3], True).X
  row[2] = row[0].positionAlongLine(row[3], True).Y

  cursor.updateRow(row)

fails with an "item not found in this collection" error, apparently on line 02. Is it not possible to use an update cursor on a query table or something?

Re: Item not found in this collection error - UpdateCursor on Query Table

JoshuaBixby — Wed, 28 Jan 2015 16:27:35 GMT

Although I don't think this is related to the error, it looks like your indentation is off on lines 03 and 04. Not sure if the code itself is that way or just a copy & paste problem into the text box.

Can you post the specific error output, all of it? Knowing the line of the error is helpful, but usually additional information is output that is also helpful.

Re: Item not found in this collection error - UpdateCursor on Query Table

DanEvans — Wed, 28 Jan 2015 16:32:01 GMT

The indentation is correct in the script, must just be a copy and paste problem.

The full text of the error is:

Traceback (most recent call last):

File "D:\Design_Layer_Tools\Leakage\Code\ValidateLeakage.py", line 93, in <module>

for row in cursor:

RuntimeError: Item not found in this collection.

(Line 93 = Line 02 of the code segment I posted).

Re: Item not found in this collection error - UpdateCursor on Query Table

JamesCrandall — Sat, 11 Dec 2021 11:45:16 GMT

Change this:

with arcpy.da.UpdateCursor("QueryTable", ["SHAPE", "leakage_with_pon_list_Eastings", "leakage_with_pon_list_Northings", "leakage_with_pon_list_RandomNumber"]) as cursor:

or to this:

flds = ["SHAPE", "leakage_with_pon_list_Eastings", "leakage_with_pon_list_Northings", "leakage_with_pon_list_RandomNumber"]
with arcpy.da.UpdateCursor("QueryTable", flds) as cursor:

(Edits applied above)

Re: Item not found in this collection error - UpdateCursor on Query Table

JoshuaBixby — Wed, 28 Jan 2015 16:54:06 GMT

Although using lists for field names is much more common, tuples are supported. I am leaning more towards the query table.

Re: Item not found in this collection error - UpdateCursor on Query Table

JoshuaBixby — Wed, 28 Jan 2015 17:06:58 GMT

You mention "query table." Are you using Make Query Table or Make Query Layer? Make Query Table is powerful, but it is an older tool, and I am not sure if its outputs are editable.

I just did a quick test using Make Query Table where I took a single feature class and used Make Query Table to create a layer, so this is a very simple case without multiple data sets or joins. Although I could use an update cursor on the feature class directly, I could not use it on the layer created from Make Query Table.

Re: Item not found in this collection error - UpdateCursor on Query Table

JamesCrandall — Wed, 28 Jan 2015 18:37:37 GMT

I struggle with this type of stuff because python is so finicky with specifics and I never know what I can get away with