Error: Failed to Enable Archiving. Invalid Column Data Type.

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: