nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Enable Archiving Fail

GlenColgate

The error I keep getting is

Failed to enable archiving. Invalid column data type.

Setup is: ArcGIS Desktop 10.2.0.3348; SDE Enterprise Geodatabase 10.2.0; Oracle 11.2.0.3.0

I am trying to enable archiving on nonversioned data using 10.2.0. (and failing miserably). It is possible according to online help (LINK). I can't find anything describing this as an added feature for 10.2.1 or 10.2.2 (or a known bug in 10.2.0).

Any thoughts?

Find more posts tagged with

Accepted answers

All comments

MelissaJarman

This has been logged as a documentation enhancement as non-versioned archiving is supported on tables and sql spatial types such as SQL Server Geometry\ST_GEOMETRY\SDO_geometry but not older geometry types such as SDEBINARY\SDELOB:

NIM102878 - The "Enabling archiving on nonversioned data" section of the link below doesn't highlight the unsupportability of SDEBNARY or SDELOB feature classes.

http://resources.arcgis.com/en/help/main/10.2/index.html#/Enabling_archiving/003n000000rs000000/

TilmannSteinmetz

I've done the same tests as Glen (in both 10.2 and 10.2.1 Geodatabases) and see the same results (works with GEOMETRY & fails when I try it with a vanialla SDEBINARY fc). Difference being that I want my dataset to be stored as SDEBINARY. The help for 10.2/10.2.1/10.2.2 only says: "Geodatabase archiving is now supported on tables that are not registered as versioned" - no mention of storage types so I was under the impression that this would work for all available storage types.

Is this supposed to be working with SDEBINARY or not?

Thanks!

Tilmann

SebastianRoberts

Thanks for this post. I was getting the same error when trying to enable archiving on a feature dataset that isn't versioned. I had some feature classes in there that were created at 10.0 or earlier so their geometry type was SDEBINARY. Confirming that the GEOMETRY_STORAGE parameter is set to GEOMETRY (SQL server) for the DEFAULTS keyword in the SDE_bdtune table, and then using the Migrate Storage geoprocessing tool with the DEFAULTS keyword fixed the issue for me.

GlenColgate

Guess we'll call this one solved.

The geometry column was the culprit. When default config key was used the field was being defined as a NUMBER(38), likely holding compressed binary, without versioning, nonversioned archiving did not like this field type.

Tried the same with SDO_GEOMETRY and ST_GEOMETRY and nonversioned archiving apparantly works.

VinceAngelo

ST_GEOMETRY should be the default storage type by now.

- V

GlenColgate

...just did the same test using a config keyword to create SDO_GEOMETRY and the archive seems to have completed normally...

 Name                                      Null?    Type
 ----------------------------------------- -------- --------------------

 OBJECTID                                  NOT NULL NUMBER(38)
 SHAPE                                              MDSYS.SDO_GEOMETRY
 SE_ANNO_CAD_DATA                                   BLOB
 GDB_FROM_DATE                             NOT NULL TIMESTAMP(6)
 GDB_TO_DATE                               NOT NULL TIMESTAMP(6)
 GDB_ARCHIVE_OID                           NOT NULL NUMBER(38)

GlenColgate

The error happens even when I create a new FC accepting all of the defaults:

Name                                      Null?    Type
----------------------------------------- -------- ----------

OBJECTID                                  NOT NULL NUMBER(38)
SHAPE                                              NUMBER(38)

no frills here... OBJECTID is the reg'd rowid (SDE-set of course), and SHAPE is the geometry.

VinceAngelo

Since it's complaining about column types, please provide a list of the columns with types. Be sure to specify which one is the registered rowid, and whether it's SDE-set or USER-set. -V

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.