Kbase P16907: Getting errors 129 and 4431
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/03/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1A
Progress 9.1B
Progress 9.1C
Progress 9.1D
SYMPTOM(s):
Getting errors 129 and 4431 during idxbuild
Getting errors 129 and 4431 when deleting record
The total length of the fields in an index exceeds max key size. (129)
SYSTEM ERROR: Failed to build key for recid = <RECID> index number <index-num> table number <table-num>. (4431)
CAUSE:
The index exceeded 188 characters in length. A PROGRESS index consists of one or more fields. Prior to OpenEdge 10.1B, for an individual record, the sum of the lengths of all fields in an index cannot be more than 188. This is a Progress limit. There were a number of bugs that allowed this limit to be exceeded.
CAUSE:
Bug# 20000830-003
FIX:
Upgrade to 9.1D05 or later.
WORKAROUND:
1. Deactivate the index.
2. Dump the record - this might allow you to edit it later so that it can be reloaded and not cause the limit to be exceeded.
3. Delete the record using its recid.
4. Rebuild the index in order to reactivate it.
Note: A product enhancement has been implemented in the OpenEdge 10.1B in the form of the "proutil -C enablelargekeys" utility only for databases with 4KB or 8KB database blocksize. Once enabled, the new index key is limited to approximately 1970 characters.
Please refer to "OpenEdge Data Management: Database Adminstration" for further information.