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

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

DavidHeacock

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

Najděte více příspěvků označených jako

Accepted answers

All comments

JeffWard

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

JuneS

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! 🙂

DavidHeacock

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.

JayantaPoddar

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.

DavidHeacock

getting the same error declaring the fields as a list

DavidHeacock

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.

DominicRobergeIADOT

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]))

danretired

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.

DavidHeacock

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']

DavidHeacock

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)

danretired

print the results of ListFields just before the with statement

ListFields—ArcGIS Pro | Documentation

JayantaPoddar

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.

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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