ERROR

Failed to enable archiving. Invalid column data type.

Last Published: April 26, 2020

Error Message

When users attempt to archive non-versioned data, the following error message is encountered:

“Failed to enable archiving. Invalid column data type.”

Cause

This error occurs if:

• In SQL Server, SDEBINARY is specified as the GEOMETRY_STORAGE type when feature classes are created.

• In Oracle, SDELOB is specified as the GEOMETRY_STORAGE type when feature classes are created.

Feature classes created with SDEBINARY or SDELOB as the geometry storage type are not supported for non-versioned archiving.

Solution or Workaround

Register the data as versioned.

OR

To archive non-versioned data, use the Migrate Storage geoprocessing tool to migrate the data to a supported geometry storage type.

• In Oracle, migrate the data to SDO_GEOMETRY or ST_GEOMETRY.
• In SQL Server, migrate the data to GEOMETRY or GEOGRAPHY.

    Article ID:000012255

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

    Related Information

    Discover more on this topic

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options