Export file and layer attribute schemas are not compatible

Last Published: April 25, 2020

Error Message

When attempting to import an SDE export file using the 'sdeimport -o append' or 'sdeimport -o init' commands, you may receive the following error message:

Export file and layer attribute schemas are not compatible.


The spatial column is the last column in both the export file and the SDE layer business table. This is a known limit for SDE 3.x.

Solution or Workaround

Arrange the columns in the SDE layer business table in such a way that the spatial column is not last in the table.

A. Use 'sdeexport' to export the original SDE layer to a new SDE export file. If problems occur with this procedure, the original SDE layer is preserved in the export file.

B. To use the same layer name, use 'sdetable -o delete' to remove all the tables associated with the original SDE layer from the database.

C. Use 'sdetable -o create' to create a new SDE table. Be sure to use the '-d' option to specify the column definitions. Make sure the spatial column is not last.

D. Use 'sdelayer -o add' to spatially enable the table.

E. Use 'sdeimport -o init' to import the previously exported file into the new layer.

SDE doesn't care if the columns in the export file and the SDE layer are not in exactly the same order. SDE is only concerned with having matching column names.

Article ID:000002481

  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic