Kbase 19621: IDXFIX inaccurately reports when running in offline mode
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/23/2000 |
|
This document applies to: Running idxfix on UNIX and Windows platforms
Version and Release Number: 9.0B and V9.1A
Summary: The following error occurs when a user id and password are added to the database through the standard Security of the Data Dictionary and the idxfix is subsequently run against the database..
SYSTEM ERROR: Index 0 (PUB._User, _Userid) contains 0 entries, but 1 records found. (8779)
91 indexes, 285 blocks, 11694 keys checked.
SYSTEM ERROR: Index fix found 1 errors. (4974)
Step by step details:
Normal conditions in v.8.3
- Connect to a valid database
- Go into Admin
- Add a User with a Password
- Verify _User-name and _Password exist with "for each" statement
- Log out of database.
- Run the following from command line: proutil <dbname> -C idxfix
- You will get the following results:
-
PROGRESS version 8.3B as of Fri Jan 29 1999
Index Fix Utility
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.
Enter selection:
Select one of the following:
All - Check all the indexes
Some - Check only some of the indexes
Quit - Quit, do not check
Enter your selection:
Validate recids for index entries.
Is this correct? (y
)
Fix indexes on Scan.
Is this correct? (y
)
Provide a range of records to scan through.
Type All or the recid to start the scan at.
Is this correct? (y
)
Index 8 (Invoice, Invoice-Num): 147 keys.
Index 9 (Invoice, Cust-Num): 147 keys.
Index 10 (Invoice, Invoice-Date): 147 keys.
....
29 Scan the database records for missing keys.
Record scan complete: 4605 keys read.
26 indexes, 114 blocks, 4605 keys checked.
Index fix completed successfully.
NORMAL CONDITIONS IN VERSION 9.0B/9.1A
- Connect to a valid database
- Go into Admin
- ADD A USER WITH A PASSWORD
- Verify _User-name and _Password exist with "for each" statement
- Log out of database.
- Run the following from command line: proutil <dbname> -C idxfix
- You will get the following results:
PROGRESS version 9.0B/9.1A as of Sat May 08 1999
Index Fix Utility
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.
Enter selection:
Select one of the following:
All - Check all the indexes
Some - Check only some of the indexes
Quit - Quit, do not check
Enter your selection:
Validate recids for index entries.
Is this correct? (y
)
Fix indexes on Scan.
Is this correct? (y
)
Provide a range of records to scan through.
Type All or the recid to start the scan at.
Is this correct? (y
)
Index 0 (PUB._User, _Userid): 0 keys.
Index 1 (PUB._File, _File-Name): 144 keys.
...
Scan the database records for missing keys.
Record scan complete: 7018 keys read.
Scan the database records for missing keys.
Record scan complete: 9120 keys read.
Scan the database records for missing keys.
Record scan complete: 11694 keys read.
SYSTEM ERROR: Index 0 (PUB._User, _Userid) contains 0 entries, but 1 records found. (8779)
91 indexes, 285 blocks, 11694 keys checked.
SYSTEM ERROR: Index fix found 1 errors. (4974)
Summation
When adding a User to 9.0B and V9.1A databases, receiving errors when running online idxfix. are in the system, no errors encountered when running online idxfix.
Workaround
It was determined through testing that it is possible to run idxbuild successfully as a workaround. Thus, this problem does not seem to be impairing system operations.