NIM039363 for ArcSDE/Enterprise Geodatabase

Bug ID Number	NIM039363
Submitted	October 17, 2008
Last Modified	April 2, 2025
Applies to	ArcSDE/Enterprise Geodatabase
Version found	9.3
Version Fixed	N/A
Status	Fixed

Description

When moving a versioned feature class with archiving enabled and the feature classes geometry stored as SDEBINARY, between load_only mode and normal_io mode, it fails with the following error:

Code:
Underlying DBMS error[ORA-02264:
name already used by an existing constraint (A<#>_FK1)][<owner>.<feature_class>]

This error may be encountered in ArcCatalog after deleting the spatial index on the feature class and defining a new grid size.

Cause

The error is only encountered when the data is stored as an SDEBINARY feature class and archiving is enabled. The problem is when the archive class is being brought out of load_only mode; it attempts to use the base feature classes layer_id in the name of the A<#>_FK1 constraint. The creation of the constraint fails because the constraint was created (and disabled) when the base feature class was first brought out of load_only mode.