SDE.Default not at state zero after compress

Jump to solution
01-05-2018 12:37 PM
Occasional Contributor

I'm using ArcGIS 10.2.1.  After deleting all versions except SDE.Default, I ran compress several times.  I still have 2 states in SDE.States and SDE.Default state is not at state zero.  Any ideas on how I can get Default to state zero?

Tags (2)
0 Kudos
1 Solution
3 Replies
Occasional Contributor

Thank you.  Someone else was connected.  Once they were disconnected, compress got sde.default to state 0.

Esri Contributor

You could also be dealing with state locks.....check the sde.state_locks table to see what's holding them up. The replica versions that George mentioned would be visible in the sde.versions table. Check those two to see what the hang up is, resolve that, then recompress.

Adam Z