Consultor Eletrônico

Status: Unverified

SYMPTOM(s):

Database abnormally shuts down.

Database log file shows error (759).

SYSTEM ERROR: No blocks on free chain number 2. (759)

SYSTEM ERROR: No blocks on free chain number <number>. (759)

proutil db -C chanalys shows the warning message (7273) for a particular area on INDEX DELETE CHAIN section.

Index Delete chain count inconsistancy. (7273)

The object block indicates 6 blocks on the index delete chain. (7272)

The object block indicates <num> blocks on the index delete chain. (7272)

The actual number of Index Delete blocks = 0 (7271)

The actual number of Index Delete blocks = (7271)

FACT(s) (Environment):

All Supported Operating Systems
OpenEdge 10.x

CAUSE:

There is an inconsistency at the Index Delete chain block count.

FIX:

Use proutil's DBRPR tool to rebuild the Index Delete chain on the area that chain analysis detected the problem.
Example
If the chain analysis showed an error on area 10 (Customer Index Area) we can use DBRPR from proenv like this to fix the problem:
1) Truncate the BI

proenv>proutil sports -C truncate bi

2) Start DBRPR tool

proenv>proutil sports -C dbrpr
3) Select 1. Database Scan Menu
4) Select 10. Change Current Working Area

5) Select area 10 (Customer Index Area) after this it should display (Current Working Area: Customer Index Area)
6) Select 9. Rebuild Index Delete Chain (it must toggle the option as ON)
7) Select G. Go to start to rebuild the chain
8) At the prompt "Scan Backward (Yes/No)?" select n .