SQL field name limit - arcpy.ValidateFieldName and error "Attribute column not found"

BarbaraS — Sat, 11 Dec 2021 17:30:09 GMT

I am working on adapting a script for filling in field values in existing features, previously used in ArcMap, now transitioning to ArcGIS Pro, using a SQL database. The adapted script throws me the error "Attribute column not found". I tried then to validate my field name and was confronted with a character limit. A field name with more than 10 characters is returned with just 10 characters.

arcpy.ValidateFieldName("abcdefghijklmnopq",workspace)
'abcdefghij'‍‍

So, now how do I find my way around that limitation? I have several field names, that are longer than 10 characters and I won't be able to shorten them. Is this a setting in the database itself? Or what do take that into consideration in my code? What am I missing here?

Re: SQL field name limit - arcpy.ValidateFieldName and error "Attribute column not found"

RandyBurton — Wed, 24 Jul 2019 23:00:30 GMT

What is the workspace?

If the optional workspace is not specified, the field name is validated against the current workspace

Are you wanting to create a new field and validate a name you are planning to use? Or did you want to use something like ListFields to verify that a certain field exists?

topic SQL field name limit - arcpy.ValidateFieldName and error "Attribute column not found" in Python Questions

SQL field name limit - arcpy.ValidateFieldName and error "Attribute column not found"

Re: SQL field name limit - arcpy.ValidateFieldName and error "Attribute column not found"