Hitachi

Hitachi Advanced Database Messages


KFAA31714-E

The SQL statement cannot be executed, because the unique constraint for the B-tree index "aa....aa"."bb....bb" was violated between SQL preparation and SQL execution. (M+J+O)

The SQL statement cannot be executed because a uniqueness constraint violation occurred on B-tree index "aa....aa"."bb....bb" between the time the preprocessing of the SQL statement began and the time the SQL statement was executed. <SQLSTATE: 52020>

aa....aa: Schema name
  • Schema name of the B-tree index on which a uniqueness constraint violation occurred

bb....bb: Index identifier
  • Index identifier of the B-tree index on which a uniqueness constraint violation occurred

S:

Invalidates this transaction.

Action:

Re-execute the SQL statement.