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.