Consultor Eletrônico



Kbase P5740: The total length of the fields in an index exceeds max key size. (129)
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   3/20/2008
Status: Verified

SYMPTOM(s):

The total length of the fields in an index exceeds max key size. (129)

Concatenating two fields and assigning the result to an indexed field.

CAUSE:

The resulting length of the indexed field exceeded the allowed maximum of 188 characters.

FIX:

A PROGRESS index consists of one or more fields. For an individual record, the sum of the lengths of all fields in any one index cannot be more than 188 characters. The solution is to either modify the data or the index definition to avoid exceeding this limit.