Knowledge Base - Technical Articles


Technical Article   Bug:  Invalid column definition ... exceeds the maximum column name length of 31

Article ID: 27636
Bug Id: CQ00220790
Software:  ArcGIS - ArcEditor 9.0, 9.1, 9.2, 9.3 ArcGIS - ArcInfo 9.0, 9.1, 9.2, 9.3 ArcGIS - ArcView 9.0, 9.1, 9.2, 9.3
Platforms: N/A

Description

Overlay tools fail with the following error message:

"Invalid column definition[geoprocessing_SDE_Featureclass_Field_1 exceeds the maximum column name length of 31.]"

Cause

When using the buffer command, or any of the overlay tools, if the same field name is in more than one input the field names are differentiated in the output by concatenating the input field name plus the fully qualified table/featureclass name. In some cases it is possible to exceed the 31 character limit of the underlying database.

Workaround

Follow the steps below.

  1. Write the output to a personal geodatabase, in which the field name length limit is higher.
  2. Use ArcToolBox > Data Management Tools > Layers and Table Views > Make Feature Layer to alter the field names in the new layer.
  3. Use ArcToolBox > Data Management Tools > Features > Copy Features to copy the features back into SDE.

Created: 9/13/2004
Last Modified: 1/2/2009

If you would like to post a comment, please login