gismoe

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

Discussion created by gismoe on Feb 25, 2014
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?

Outcomes