Bug: Compress has the potential to detach rows in the feature and spatial index tables
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.
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.
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