Back to SPR List Previous Next
A database that can EXPORT/IMPORT and VERIFY ok can corrupt after UNLOAD/RELOAD.
Moderate Closed - Fixed Found:XS.01.10 07 OCT 2008 Fixed:XS.01.11 08 OCT 2008

DETAILS
 A particular exported database can import and verify ok. After unload/reload the verify
 gives errors like those below. The output is infinite.

 This problem has only been found in one database and is under investigation
EXAMPLE PROGRAM
 Verify database USERSTAT
 Creation Date/Time                     Sep 30, 2008  21:34:46
 Last update Date/Time                  Sep 30, 2008  21:35:49
 Update level                           1
 **30/N** Missing cir: case id changed but no cir record195711:3848(195709)/195841/2
 **07/C** CIR REC count mismatch 195711:3848(195709)/9/26
 **30/N** Missing cir: case id changed but no cir record198392:3881(198390)/198522/8
 **07/C** CIR REC count mismatch 198392:3881(198390)/9/26
 **25/N** Index key out of order 20454/1/205833:4015(205831)/205884
 **03/C** Index entry count mismatch 3/2004414567/42/866
 **27/N** Non-matching index block keys 0/3/205833:4015(205831)/205884
 **03/C** Index entry count mismatch 3/2004414567/42/866
 **27/N** Non-matching index block keys 0/3/205833:4015(205831)/205884
 **03/C** Index entry count mismatch 3/2004414567/42/866
 **27/N** Non-matching index block keys 0/3/205833:4015(205831)/205884
 **03/C** Index entry count mismatch 3/2004414567/42/866
 **27/N** Non-matching index block keys 0/3/205833:4015(205831)/205884
 **03/C** Index entry count mismatch 3/2004414567/42/866
 **27/N** Non-matching index block keys 0/3/205833:4015(205831)/205884
 **03/C** Index entry count mismatch 3/2004414567/42/866
 **27/N** Non-matching index block keys 0/3/205833:4015(205831)/205884
 **03/C** Index entry count mismatch 3/2004414567/42/866
 **27/N** Non-matching index block keys 0/3/205833:4015(205831)/205884
 **03/C** Index entry count mismatch 3/2004414567/42/866
 **27/N** Non-matching index block keys 0/3/205833:4015(205831)/205884
 and on....
WORKAROUND
Export the database before unload reload.
Back to SPR List Previous Next