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.