Copy Tables or Features Classes changes fieldnames that exceeds length of 28?!

gismoe — Wed, 26 Feb 2014 07:43:19 GMT

Since 10.0 SP4 (until 10.1 SP1) i can't use arcpy.CopyRows_management or arcpy.CopyFeatures_management
with fieldnames that exceeds 28 characters.

These fieldname were change. Here some examples:

aaaaaaaaaaaaaaaaaaaaaaaaaa28     aaaaaaaaaaaaaaaaaaaaaaaaaa28         everything OK
aaaaaaaaaaaaaaaaaaaaaaaaaaa29    aaaaaaaaaaaaaaaaaaaaaaaaaaa2_20      wrong name
aaaaaaaaaaaaaaaaaaaaaaaaaaaa30   aaaaaaaaaaaaaaaaaaaaaaaaaaaa_21      wrong name
aaaaaaaaaaaaaaaaaaaaaaaaaaaaa31  aaaaaaaaaaaaaaaaaaaaaaaaaaaaa_22            wrong name

The number after the underscore seems to be the field-id.

FGDB to FGDB works but FGDB to ArcSDE (on SQL Server) doesn't!
Copy the data with ArcCatalog works.

Is this a known bug?
Is there a workaround or patch?

topic Copy Tables or Features Classes changes fieldnames that exceeds length of 28?! in Python Questions

Copy Tables or Features Classes changes fieldnames that exceeds length of 28?!