Information

Title	idxbuild completes with 0 errors; idxfix on a word index returns (8829) (8783)

URL Name	idxbuild-completes-with-0-errors-idxfix-on-a-word-index-returns-8829-8783

Article Number	000198286

Environment	Product: OpenEdge Version: All supported versions OS: All supported platforms

Question/Problem Description

idxbuild completes with 0 errors, but idxfix on a word index returns (8829) (8783).
Only word indexes affected.

Steps to Reproduce

Clarifying Information

Error Message	Index <index number> (<owner name>.<table name>, <index name>): Found invalid key <key value> recid <record identifier>. (8829) SYSTEM ERROR: Index<index-num> (<owner-name>.<table-name>, <index-name>): couldn't find key <key> recid <DBKEY>. (8783)

Defect Number

Enhancement Number

Cause

Incorrect word-break table applied to database, inappropriate for the database codepage.

Resolution

proutil -C word-rules run against the database offline will indicate what the current word-break is, as discussed in the article -
How to see what word-break table is defined for a database?
Apply the correct word-break table appropriate to the database codepage, then carry out idxbuild.

For example, if proutil -C word-rules returns 0 when the database codepage (as indicated under Data Admininstration >Utilities >Information) is utf-8, the word-break table 254 needs to be applied.

Workaround

Notes

References to Other Documentation:

OE10, OE11: OpenEdge Development: Internationalizing Applications
OE12: Internationalize ABL Applications

Keyword Phrase

Last Modified Date	12/4/2020 10:45 AM

idxbuild completes with 0 errors; idxfix on a word index returns (8829) (8783)

Information