BUG
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.
Article ID: 000009702
Get help from ArcGIS experts
Download the Esri Support App