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

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Related Information

    Discover more on this topic