English

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

Description

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".

Cause

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.

Workaround

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