Consultor Eletrônico

Status: Verified

FACT(s) (Environment):

Windows

SYMPTOM(s):

Corrupt block detected when reading from database. (4229)

SYSTEM ERROR: read wrong dbkey at offset <offset> in file <file>
found <dbkey>, expected <dbkey>, retrying. (1152)

Idxbuild fails to correct the problem.

CAUSE:

There is corruption in the database due to hardware failure.

FIX:

1) Make a backup of the damaged DB files in another directory.

2) Go to the Windows START button > PROGRAM FILES > PROGRESS > PROENV option.

Set the screen buffer to the maximum of 9,999. To change the value of the screen buffer, you must click the upper left corner of the PROENV window and go to PROPERTIES > LAYOUT Section > SCREEN BUFFER SIZE box, and modify HEIGHT to 9,999.

This way you will be able to see all the output of DBRP on the screen.

3) Try to truncate the BI using:

proutil <db name> -C truncate bi

4) Run the DBRPR utility as follows:

proutil <db name> -C DBRPR

5) In case the truncation of the BI is not possible add the -F parameter to the DBRPR call:

proutil <db name> -C DBRPR -F

6) Select option 1: Database Scan Menu

7) Select the following options:

ON 1. Report Bad Blocks
ON 3. Reformat Bad Blocks
ON 4. Report Bad Records
ON 5. Delete Bad Records
ON 7. Rebuild Free Chain
ON 8. Rebuild RM Chain
ON A: Apply scan to all areas <---- V9 only

8) Rebuild all indexes using:

proutil <db name> -B <# of buffers> -C idxbuild all -TB 24 -TM 32