After troubleshooting with:
- a series of compresses, rebuild indexes and analyze datasets ran manually
- Two nights of automated compress, rebuild and analyze Python routines
- Recreate replicas with a different ID
I still have lingering SDE states in the SDE_States table. When running a query for all records in the table, I receive:
I think those lingering states may be tied to the underlying version that replication creates. If your states table is only 4 records, I wouldn't lose too much sleep over it.
Is there any editing version still need to reconcile, post and delete.
Try to remove all versions except replicas.
And run compress tool and check for states.