English

Error: Unable to create shape attribute table for reject shape: Bad column definition

Solution or Workaround

Error Message

Creating a reject shapefile, like this:

Code:
shp2sde -o create -l inc_83892,shape -f width20 -g 0.25 -a all -i sde_won8 -u sde -p xxx -r rjct

Produces this error message:

Code:
ArcSDE 8.0.1 Build 719 Tue Dec 7 11:01:56 PST 1999
Shape to Layer Loading Administration Utility
-----------------------------------------------------
Unable to create shape attribute table for reject shape: Bad column definition
Continue with loading data into SDE layer...
Shape 46 failed initial verification: Ring crosses ring
Shape 70 failed initial verification: Ring crosses ring
68 features converted.
68 features stored.

Cause

The shapefile has a numeric attribute field with a width of 20 or greater.

This is a known issue.

Solution

Change the shapefile's numeric field width to 19.

Code:
shp2sde -o create -l inc_83892,shape -f width19 -g 0.25 -a all -i sde_won8 -u sde -p xxx -r rjct

Now it works:

Code:
ArcSDE 8.0.1 Build 719 Tue Dec 7 11:01:56 PST 1999
Shape to Layer Loading Administration Utility
-----------------------------------------------------
Set X_offset = 153
Set Y_offset = -27
Set XY_scale = 2000000000
Shape 46 failed initial verification: Ring crosses ring
Writing input shape #46 part #1 of 1 into rejected shape #1
Shape 70 failed initial verification: Ring crosses ring
Writing input shape #70 part #1 of 1 into rejected shape #2
68 features converted.
68 features stored.

D:\work\Incidents\83892>pause
Press any key to continue . . .