Edit Application - sometimes edits don't save

Discussion created by millsa on Feb 25, 2014
Latest reply on Feb 26, 2014 by millsa
I wasn't sure if I should post this in the ArcGIS Server or Flexviewer forum, so I chose to start here:
ArcGIS Server 10.1
Flexviewer source code version 3.6 utilizing "out of the box" edit widget
SDE 9.3 - two feature classes with approximately 100,000 features to edit (minor attribute edits, maybe 4 - 5 columns)

We have a couple of versioned (move to base enabled) feature classes that our users are editing on an internal flexviewer application.  At first, everything worked perfectly.  Then the problems started - users were complaining that the feature classes were getting updated on screen, but when they checked them the next day, they had reverted back to pre-edit.  My colleagues and I researched it and found some erratic behavior.  We weren't able to R&P at first, so when I finally did I found over a million records in the state lineages table.  It took a couple of hours to clean up with the compress and now we R&P and compress every night.  I thought this would fix the problems, but users are still complaining.

Could the 9.3 SDE be the problem?  Maybe domains are an issue?  Too many features?  Any suggestions or ideas for the ideal web editing environment would be greatly appreciated.