Desktop: 9.3.1 sp1, 9.3.1 sp2 & 9.3.1 (we can't force some of our folks to upgrade to sp2) Database: SQL sde 9.3 Enterprise License
We run a bi-weekly maintenance routine where our distributed editors all reconcile and post, their versions are deleted, and the database is compressed. The last time we ran this process, we noticed a series of hung states in the database. We were unable to achieve a full compression to state 0. What stood out as odd, after having talked to our editors, is that the hung state times all coincide with a reconcile/post event.
Attached are screesnhots of the versioning lineage and the sde_states table post compression. The red highlighted state is my reconcile/post even just prior to compression.
Can anyone help with why these states are hanging, how can we fix them, and how do we prevent them from occurring?