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

BarbaraS

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<SPAN class="punctuation token">.</SPAN>ValidateFieldName<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"abcdefghijklmnopq"</SPAN><SPAN class="punctuation token">,</SPAN>workspace<SPAN class="punctuation token">)</SPAN>
<SPAN class="string token">'abcdefghij'</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

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?

RandyBurton

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?