Teradata Database Message 8505 - 8505 - Analytics Database - Teradata Vantage

Message

LOB ID could not be generated

Explanation

A unique LOB identifier could not be generated because there are no more unused IDs for the specified key.

Generated By

lobCreate

For Whom

Site support representative or customer.

Notes

A LOB identifier is composed of a key based on the primary index of the table and an additional 16 bits for uniqueness. This error indicates that all the possible uniqueness values are currently in use. It could occur if the table that contains the LOB column has more than 65534 rows with the same primary row hash value.

Remedy

Redesign the table so that its primary index has fewer rows with the same primary index value.