Kbase P3694: Running proutil idxcheck returns errors 8879, 2805, 129.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/03/2003 |
|
Status: Unverified
FACT(s) (Environment):
SCO UnixWare 7.0.1
FACT(s) (Environment):
SCO UnixWare 7.1.1
FACT(s) (Environment):
Progress 9.1B
SYMPTOM(s):
Running proutil idxcheck returns errors 8879, 2805, 129:
SYSTEM ERROR: Index <index-num> (<owner-name>.<table-name>, <index-name>) contains <entry-count> entries, but <record-count> records found. (8779)
SYSTEM ERROR: Index check found <error-cnt> errors. (2805)
The total length of the fields in an index exceeds max key size. (129)
CAUSE:
SYSTEM ERROR: Index <index-num> (<owner-name>.<table-name>, <index-name>) contains <entry-count> entries, but <record-count> records found. (8779)
The number of entries in the index does not match the number of records in the table. The index can still to be used, but should be rebuilt at some point. If used as is, some CAN-FIND calls may return the wrong value.
SYSTEM ERROR: Index check found <error-cnt> errors. (2805)
This message lists the number of errors discovered by the index check utility. The errors themselves were listed while the utility was running, and can also be found in the database log file (dbname.lg).
FIX:
Run an idxfix.