SDE 3.x for Informix: Unable to setup attribute table for insert (shp2sde)

Last Published: April 25, 2020

Error Message

Running shp2sde like this:

shp2sde -o create -l rows_B,shape -f rows -S "Rights of Ways" -g 256,0,0 -c 1000 -x 6000000,1800000,1000 -a all -G 26946 -e a+ -v -u sdetest -p passwd -s server1 -D mydb -i sde5152

Produces this error:

ESRI SDE Shape to Layer Loading Utility Tue Jul 11 08:50:23 2000
SDE Code (-51)= Underlying DBMS error
Extended DBMS error code: 0
Underlying DBMS error
Unable to setup attribute table for insert.
Delete layer "rows_B" ...


The shape file contains an attribute column that is an Informix reserved word.

Solution or Workaround

Use a column name translation file, e.g. "-a file=translate.txt". This file contains a list of all attribute columns to include from the shape file into the layer, as well as a new name for any columns that are reserved words. The file contents would look like this:

row rightofway

Article ID:000001922

  • Legacy Products

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options