Hitachi

Hitachi Advanced Database Messages


KFAA30616-E

The B-tree index key length exceeded the maximum length. (M+J+O)

The length of a B-tree index key exceeds the maximum length. <SQLSTATE: 56007>

S:

Ignores this SQL statement. Alternatively, the system invalidates this transaction.

Action:

Take one of the following corrective actions:

  • Make the page size larger for the DB area that stores the B-tree index.

  • Correct the B-tree index key length so that it is no greater than the maximum length.

If this message was issued while a CREATE INDEX statement was executing, check the maximum length for B-tree index keys by referencing Rules in Specification format and rules for the CREATE INDEX statement in the manual HADB SQL Reference.

If this message was issued while a CREATE TABLE statement was executing, check the maximum length of B-tree index keys corresponding to the primary key by referencing Rules in Specification format and rules for the CREATE TABLE statement in the manual HADB SQL Reference.