ssstanton

StopEditing(false) not rolling back

Discussion created by ssstanton on May 14, 2013
My application is loading data into a series of SDE tables (in an Oracle database). Prior to loading, it uses IWorkspaceEdit like this:

                    if (!workspaceEdit.IsBeingEdited())
                    {
                        workspaceEdit.StartEditing(false);
                        workspaceEdit.StartEditOperation();
                    }

If something goes wrong along the way, it's meant to rollback changes with:

                    if (workspaceEdit.IsBeingEdited())
                    {
                        workspaceEdit.StopEditOperation();
                        workspaceEdit.StopEditing(false);
                    }

This works fine on my own Oracle database. But my customer says it's not working for them (the rows inserted prior to failure don't get rolled back). Is anyone aware of some Oracle config setting that may end up producing different results?

In both cases, we're inserting into sde.DEFAULT. The tables are marked as versioned, with the option to move edits to base.

Outcomes