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?
Solved! Go to Solution.
Does (Did) your geodatabase contain any replicas? http://downloads.esri.com/support/whitepapers/ao_/J9842_GDB_Compress_With_Replicas.pdf - Old but still valid
When you ran the compress were there any other connections being made to it?
The compress operation and geodatabases—ArcGIS Help | ArcGIS Desktop
https://community.esri.com/groups/geodatabase?sr=search&searchId=802d7876-f540-4be3-9b7d-ea3ae39170d... https://community.esri.com/community/gis/managing-data?sr=search&searchId=04e2942e-9c6e-4313-aba3-9f...
Does (Did) your geodatabase contain any replicas? http://downloads.esri.com/support/whitepapers/ao_/J9842_GDB_Compress_With_Replicas.pdf - Old but still valid
When you ran the compress were there any other connections being made to it?
The compress operation and geodatabases—ArcGIS Help | ArcGIS Desktop
https://community.esri.com/groups/geodatabase?sr=search&searchId=802d7876-f540-4be3-9b7d-ea3ae39170d... https://community.esri.com/community/gis/managing-data?sr=search&searchId=04e2942e-9c6e-4313-aba3-9f...
Thank you. Someone else was connected. Once they were disconnected, compress got sde.default to state 0.
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
Having a real tough time with this. No matter what i do, our SDE won't compress to state 1. It's always at 2 for the last year or so. We compress every week via a python script for the last 5-6 years.
The script puts sets the SDE not to accept new connections, disconnects all existing users/clears locks. Then runs the compress. After the compress, it rebuilds the indexes and does an analysis of the tables.
Seems like the for last year or so, none of the deltas have been moving to the business table either on any later. Causing a lot of downstream issues. Wondering if anyone has run into the issue.