English

Error: SDE Error(-114) Wrong column type

Error Message

If the '-a option' is set to none when executing cov2sde and the target feature class uses either ST_Geometry or SDO_Geometry storage in an Oracle database, the following error is returned:

"SDE Error(-114) Wrong column type
'-a none' not supported with ST_GEOMETRY and SDO_GEOMETRY.
Please use '-a all' or '-a file=<file_name>' option."

Cause

Changes made in ArcSDE 10.0 to support table creation of native, DBMS, spatial types impact the way the cov2sde command and '-a none' options operate when creating layers that use the SDO_GEOMETRY or ST_GEOMETRY geometry storage type. This is a known limit.

Solution or Workaround

When using the '-a' option, either specify 'all' or 'file=<file_name>' with at least one valid coverage item. This column can be deleted at a later time if it is not needed.