English

Error: ORA-00001: unique constraint (AA.UK_AS_xxx) violated

Error Message

This error occurs when using the sdelayer command like this:

sdelayer -o register -l GD_AS_EISENBAHN,geometry -e sl -c gid -k SDO_GEOMETRY -u aa -p aa

The complete error is:

ArcSDE 8.0.2
Layer Administration Utility
-----------------------------------------------------
Error: Underlying DBMS error (-51).
Error: Unable to alter registration for table GD_AS_EISENBAHN
Error: Underlying DBMS error (-51).
Error: External table cannot be registered.
ORA-00001: unique constraint (AA.UK_AS_EISENBAHN) violated
ORA-06512: at line 1

Cause

An attempt to register an Oracle spatial layer with name greater than 14 characters long violates SDE layer name unique constraint (truncating name).

Solution or Workaround

Shorten the table name to 14 characters or less.