Kbase P46968: IDXFIX not removing record with an indexed field with more than 180 charcters.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
08/09/2004 |
|
Status: Unverified
SYMPTOM(s):
SYSTEM ERROR: fillkey: error formatting existing key. (127)
The total length of the fields in an index exceeds max key size. (129)
Errors accessing record via an index
SYSTEM ERROR: Index in for recid could not be deleted. (1422)
1422 error and core dump attempting to edit field
User accidentally added multiple blank characters to an indexed field within a record.
IDXFIX does not remove index.
Unable to upgrade to 9.1D07
CAUSE:
Bug# 20030502-019
CAUSE:
During the idxbuild, the buffer for the keybuild is not taking into
consideration the fact that the trailing blanks in field are not part of the
index.
FIX:
Shut down database, disable index, edit problem field to remove characters causing the problem, and reenable index with an IDXFIX.
The problem is fixed in 9.1D07.