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.
@Brian McLeer
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.