Kbase P128782: Record count different between DBANALYS and FOR EACH or SELECT COUNT (*)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/07/2008 |
|
Status: Unverified
SYMPTOM(s):
DBANALYS shows X amount of records in a table
FOR EACH, "SELECT COUNT (*)" and IDXCHECK report Y amount of records in that particular table
DBANALYS has been run in 9.1D08
Database has been migrated to 9.1E04 via dump and load
FOR EACH, "SELECT COUNT (*)" and IDXCHECK have been run in 9.1E04
FACT(s) (Environment):
Windows
Progress 9.x
CAUSE:
DBANALYS has been run on a corrupted database prior to the dump and load, therefor the count cannot expected to be right
FIX:
Run DBANALYS again after the dump and load.