Kbase P151101: Tabanalys is showing more records in a table than the actual number of records being dumped from the
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/14/2009 |
|
Status: Unverified
SYMPTOM(s):
Tabanalys is showing more records in a table than the actual number of records being dumped from the table.
An ASCII dump of the table results in less records than being reported by tabanalys for this table.
proutil dbname -C idxbuild completed successfully but had many 1127 errors.
Index rebuild complete. <number> error(s) encountered. (1644)
Fix RECID <recid>, <file-name> already exists with <field value>. (1127)
(1644) Index rebuild complete. 4524 error(s) encountered.
(1127) Fix RECID 15055785, d_SlProdPrice already exists with Project ID "10140" Model "30004END" Elevation "B" Product I.D. 5028.
Idxfix against the table after the index build shows error (8779)
SYSTEM ERROR: Index <index-num> (<owner-name>.<table-name>, <index-name>) contains <entry-count> entries, but <record-count> records found. (8779)
SYSTEM ERROR: Index 1463 (PUB.d_SlProdPrice, Proj-Mod-Elev-Prod) contains 110441 entries, but 114965 records found. (8779)
4524 warnings issued. (2806)
5 indexes, 2137174 blocks, 574825 keys checked.
SYSTEM ERROR: Index fix found 1 errors. (4974)
FACT(s) (Environment):
Database being dumped for the purposes of creating a new database.
Windows
OpenEdge 10.1B03 Service Pack
CAUSE:
There are duplicate records on unique index keys for this table.
FIX:
1. Use the proutil dbname -C idxfix utility to delete the duplicate records.
This utility checks the Progress database records and indexes to determine whether an index is corrupt or a record has a missing or an incorrect index. You can specify whether to scan the database, or the indexes, or both. You can run IDXFIX online or offline.
Option 6 is called "Delete one record and it's index entries."
This option prompts you to specify the RECID of the record you want to delete. The utility deletes one record and all its indexes from the database.
2. If this database is just being dumped into a new database and subsequently this database will be deleted, then there is no need to fix the issue within the original database.