Select to view content in your preferred language

Lingering SDE States in in Child replicated database

892
2
06-28-2019 09:43 AM
Brian_McLeer
Frequent Contributor

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:

Brian
0 Kudos
2 Replies
JoeBorgione
MVP Emeritus

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.

That should just about do it....
0 Kudos
by Anonymous User
Not applicable

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

0 Kudos