topic Re: 'Cannot find field' error with arcpy.da.SearchCursor in ArcGIS Pro Questions

'Cannot find field' error with arcpy.da.SearchCursor

DavidHeacock — Tue, 29 Mar 2022 17:08:42 GMT

Hi there - I have some scripts I've been trying to use that I haven't run in several months. There have been updates to Pro/Arcpy since then and now they are throwing errors, so I'm trying to get to the bottom of all them.

I'm getting the "Cannot find field 'PARCEL_ID'" error coming from the code:

with arcpy.da.SearchCursor(templayer3, ['PARCEL_ID', "Acres"]) as cursor: for row in cursor:

I've checked for any typos, exported versions of 'templayer3' throughout the script and 'PARCEL_ID' is in there correctly formatted, without aliases, etc. Are there alternative reasons why one might get the 'Cannot find field' error?

Thanks

Re: 'Cannot find field' error with arcpy.da.SearchCursor

JayantaPoddar — Tue, 29 Mar 2022 17:35:53 GMT

What if you replace single quotes with double quotes?

"PARCEL_ID"

Also you might want to copy-paste the fieldname rather than typing it down.

Re: 'Cannot find field' error with arcpy.da.SearchCursor

DanPatterson — Tue, 29 Mar 2022 17:36:19 GMT

print the results of ListFields just before the with statement

ListFields—ArcGIS Pro | Documentation

Re: 'Cannot find field' error with arcpy.da.SearchCursor

DavidHeacock — Tue, 29 Mar 2022 17:55:20 GMT

Double quotes don't work either (that's how they were before actually, the single quotes were just an attempt at trying to resolve the bug)

Re: 'Cannot find field' error with arcpy.da.SearchCursor

DavidHeacock — Tue, 29 Mar 2022 17:58:09 GMT

The feature class outputs the correct fields. Placed before the problematic cursor:

field_names_output = [f.name for f in arcpy.ListFields(templayer3)] arcpy.AddMessage(field_names_output)

Outputs:

['OID', 'Shape', 'PARCEL_ID', 'Acres']

Re: 'Cannot find field' error with arcpy.da.SearchCursor

DanPatterson — Tue, 29 Mar 2022 19:04:46 GMT

There are 2 ways to run the searchcursor.

with arcpy.da.SearchCursor(templayer3, ["PARCEL_ID", "Acres"]) as cursor: for row in cursor: blah # --- or ----- cursor = arcpy.da.SearchCursor(templayer3, ["PARCEL_ID", "Acres"]): for row in cursor: blah

'Cannot find field' error with arcpy.da.SearchCurs... - Esri Community

If the approach yields the same issue AND it is a table in a file geodatabase and not some other variant of a table, then I would escalate to tech support, since you seem to have confirmed that the table and the field exist.

Re: 'Cannot find field' error with arcpy.da.SearchCursor

DominicRobergeIADOT — Tue, 29 Mar 2022 19:13:54 GMT

what is you try something like this:

fields = ['PARCEL_ID', 'Acres'] with arcpy.da.SearchCursor(templayer3, fields) as cursor: for row in cursor: print(u'{0}, {1}'.format(row[0], row[1]))

Re: 'Cannot find field' error with arcpy.da.SearchCursor

DavidHeacock — Tue, 29 Mar 2022 20:08:40 GMT

Thanks, I didn't have luck with either of those approaches. 'templayer3' is in memory, but I tried converting to a feature class in a gdb and I'm getting the same result.

Re: 'Cannot find field' error with arcpy.da.SearchCursor

DavidHeacock — Tue, 29 Mar 2022 20:09:01 GMT

getting the same error declaring the fields as a list

Re: 'Cannot find field' error with arcpy.da.SearchCursor

JayantaPoddar — Tue, 29 Mar 2022 20:42:37 GMT

In case you haven't tried,

1. Close all applications.

2. Shut down your machine.

3. Get yourself a cup of coffee.

4. Start your system.

5. Start ArcGIS Pro, and give it another try.

Re: 'Cannot find field' error with arcpy.da.SearchCursor

DavidHeacock — Wed, 30 Mar 2022 13:49:13 GMT

Well today the cursor is working with the in_memory layer converted to a feature class. So I'll note that in other places in my script. Not sure if something changed with arcpy in any of the updates since the cursor used to work on an in_memory layer. Thanks all.

Re: 'Cannot find field' error with arcpy.da.SearchCursor

JuneS — Sat, 04 Feb 2023 07:45:13 GMT

Not sure if you ever figured it out, David, but I wanted to put this here in case anybody is having a similar issue...

I was using templates to create my empty feature class and when I tried to use an insert cursor it said the field was missing. I realized I needed to update my table template to accommodate the extra field I was adding. So make sure in your original creation of the feature class/table that you have actually made the field you are trying to insert your values into!

Not sure if this is what it was for you, but I hope you figured it out in the end! 🙂

Re: 'Cannot find field' error with arcpy.da.SearchCursor

JeffWard — Wed, 01 May 2024 14:24:46 GMT

Thank you @DanPatterson! This saved me a lot of extra frustration. My field aliases were using . instead of underscores.