Kbase P101163: Record counts in dbanalys don't match after dump and load.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/09/2008 |
|
Status: Verified
SYMPTOM(s):
Record counts in dbanalys don't match after dump and load.
IDXFIX shows errors 8827
Index <index name> (<owner name>.<table name>, <index name>): Added key <index value> recid <record identifier>. (8827)
Count of records dumped doesn't match count of records in table.
FACT(s) (Environment):
Progress 8.2x
Progress 8.3x
Progress 9.x
OpenEdge 10.x
Progress 8.2x
Progress 8.3x
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
CAUSE:
Corruption in the indices of the source database prevented records from dumping correctly thus decreasing the number of records to be loaded into the new database.
FIX:
Use idxfix (version 8.2 or later) to scan the indices for the tables of the source database. If any errors are found then use idxfix or idxbuild to correct the index corruption.
Idxfix can fix errors found while the database is online.
Idxcheck may be used to scan the database for corruption but idxcheck can not fix any errors found.
Idxbuild can be used to correct problems with indices but can not perform any fixes while the database is online.
After the index corruption is corrected dump and load from source to target databases again.