ERROR

SDE Error(-114) Wrong column type

Last Published: April 25, 2020

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.

    Article ID:000010658

    Software:
    • 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

    Esri Community

    Search for related information

    Training

    Find training related to this topic

    ArcGIS Ideas

    Explore ideas and give feedback

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options