English
Continue in the app
Be The First To Get Support Updates
Want to know about the latest technical content and software updates?

Bug: Compress has the potential to detach rows in the feature and spatial index tables

Description

Note:
ArcSDE software, including the application server, command tools, and SDK with C and Java APIs, was deprecated at ArcGIS 10.2.2 and is no longer distributed.

When deleting rows from a table in the base state (state 0), the compress operation may inadvertently not delete the object's corresponding geometry in the feature and spatial index tables. The issue is specific to tables registered as versioned and stored as SDEBINARY.

Cause

When the compress operation is deleting rows from a versioned class' base table (state 0), there are specific conditions when the row's geometry in the feature table and spatial index table are also not deleted.

Workaround

The detached rows in the feature and spatial index table do not cause or lead to any problems. The rows are completely detached and consuming storage space in the tables.

To remove the additional rows requires the feature class to be unregistered as versioned.

The owner of the feature class can either use the 'Unregister as versioned' command in ArcCatalog or the sdetable -o alter_reg command.

Last Published : 5/6/2021

Article ID: 000009701

Software: ArcSDE 9.2