NIM012712 for No Product Found

Bug ID Number	NIM012712
Submitted	October 31, 2007
Last Modified	June 5, 2024
Applies to	No Product Found
Version found	9.3
Version Fixed	9.3
Status	Fixed

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.