SQL server 2008; arcsde 10.1

567
1
10-30-2013 01:13 PM
BC
by
New Contributor II
I have records stuck in Adds, Deletes table.  Just default version only no other versions at this time.  I can see the updates that I made both in versioned View and ArcMap as well but not when querying the base table in SQL Management studio query.  Compress status is successful every time but the updated records can not be seen in SQL since the delta table is not empty.  Any suggestions?  Thank you in advance.
0 Kudos
1 Reply
JakeSkinner
Esri Esteemed Contributor
When performing the compress, make sure no users are connected, no locks exist, and all replicas have been synchronized.  Also, since you are editing the DEFAULT version, you may want to consider registering your feature class with the option of moving edits to base:

http://resources.arcgis.com/en/help/main/10.2/index.html#//003n000000rp000000

Checking this option causes edits that have been saved to the DEFAULT  version to be  saved in the base (business) tables.
0 Kudos