Kbase P12261: Characters limit on a word-indexed field is exceeded (42)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1B
SYMPTOM(s):
bfx: Field too large for a data item. Try to increase -s. (42)
Error 42 at the assign statement when a variable is assigned to the record field
Characters limit on a word-indexed field is exceeded (42)
Increase the -s parameter not an option
Upgrading to latest commercial release where the limit is 31981 is not an immediate option
CAUSE:
The character limit on a word-indexed field is exceeded.
A word indexed field used to have a limit of about 18,799 bytes in Progress 9.1B. This was raised to 32K (actually 31,981 bytes) in a patch. In addition, the right part of the CONTAINS operator cannot exceed 18,420 bytes, so the word index does not help to manage a word larger than this limit (Word index was not really designed to handle these kind of words)
FIX:
Downsize by putting a 12,000 character limit onto the word-indexed field