Feature classes that contain versioned edits in a lineage not referenced by a version will still have orphan entries in the F and S tables after performing a compress. A<> and D<> tables are compressed correctly.

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.

Steps to Reproduce