Continue in the app
Be The First To Get Support Updates
Want to know about the latest technical content and software updates?

Bug: Saving a feature class registered with move edits to base and using stand-alone log files in Oracle fails


Saving or posting a version to the DEFAULT version with a class registered as versioned with the option to move edits to base in Oracle fails with the following underlying database error:

"ORA-00900: invalid SQL statement".


The cause is an invalid SQL INSERT statement used by ArcSDE to log modified rows with stand-alone log files. Prior to rows being written to the base state during a save operation for a class registered as versioned with the option move edits to base, ArcSDE must log each object's row_id to a log file for further data management steps. If the ArcSDE instance has been configured to use stand-alone session log files, an invalid SQL statement is executed and encounters the ORA-00900 error.


Change the ArcSDE log file settings to use the default configuration.

See the link in Related Information below on 'Log file configuration options' for more information on how to alter and set log file parameters.

    Related Information

    Last Published : 5/5/2016

    Article ID: 000009702