Kbase P126796: Query against records fail with errors 10831 and 10833.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/07/2009 |
|
Status: Verified
SYMPTOM(s):
Query against records fail with errors 10831 and 10833.
SYSTEM ERROR: Record continuation not found, fragment recid <recid> area <areanum> <msg-inst> . (10831)
SYSTEM ERROR: Invalid record with recid <recid> area <area-num> <inst-num>. (10833)
Attempts at using idxfix option 6 to remove the recids listed in the 10831 and 10833 errors fails.
FACT(s) (Environment):
All Supported Operating Systems
Progress 8.2x
Progress 8.2C
Progress 9.x
OpenEdge 10.x
CAUSE:
The exact cause is unknown at the time of this writing.
Data corruption within the indices is suspected.
FIX:
This problem may be corrected by using the idxfix option of proutil.
Example:
Step 1)
proutil <dbname> -C idxfix
Step 2)
Enter selection:
1. Scan records for missing index entries.
2. Scan indexes for invalid index entries.
3. Both 1 and 2 above.
4. Cross-reference check of multiple indexes for a table.
5. Build indexes from existing indexes.
6. Delete one record and it's index entries.
7. Quit.
Choose option 2.
Step 3)
Select one of the following:
All - Check all the indexes
Some - Check only some of the indexes
Quit - Quit, do not check
When Choosing Some:
If unsure what table(s) are associated with the recids listed in errors 10831 and 10833 then choose All.
If the table the recid(s) are associated with are known, choose some.
Then:
Enter the name of table containing the index.
Enter ! to indicate input is complete. (9176)
Table name:
Enter Table Name.
Index name:
Enter index of Table
Repeat entering the table and index for each index which belongs to the table.
Enter ! (exclamation point) on the Enter Table Name entry when finished entering entries.
A list of tables and indices you have chosen will be listed for you to confirm:
**** The following indexes will be fixed:
Owner: PUB
Table: customer
Index: custnum
Is this correct? (y
)
y
When Choosing All:
Enter your selection:
all
Step 4)
Validate recids for index entries.
Is this correct? (y
)
Enter y for yes
Step 5)
Fix indexes on Scan.
Is this correct? (y
)
Enter y for yes