Kbase P23622: S/E 210 for block number 32 or 64
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
S/E 210 for block number 32 or 64
SYSTEM ERROR: Attempt to read block <number> which does not exist. (210)
Above error on truncate bi or proserve
The last extent of the schema area is not fixed
The schema area size is at its limit
CAUSE:
With a none fixed data extent there is no Progress security on the area size limit.
For a 1K database block, the schema area (32 records per block) has a limit of 64GB. For both 8K and 4K database block, the schema area (64 records per block and 32 records per block respectively) has a limit of 256GB.
FIX:
1. Restore earlier backup
2. Create a new area
"prostrct add <db> <file.st>"
3. Move table(s) and/or index(es) to free space in the area which is reaching its maximal size
"proutil <db> -C tablemove <table> <area>"
"proutil <db> -C idxmove <index> <area>"