Kbase P116320: SYSTEM ERROR: File <bi > too small 0, blocksize 8192 extend failed." (4524)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/14/2008 |
|
Status: Unverified
SYMPTOM(s):
SYSTEM ERROR: File <file-name> too small <length>, blocksize <blocksize> extend failed." (4524)
SYSTEM ERROR: File b1 too small 0, blocksize 8192 extend failed." (4524)
truncate bi fails with error (4524) as well
.bi file truncated. (123) is the last entry in database log before the power failure.
FACT(s) (Environment):
Windows 2000 Advanced Server
Progress 9.1D
CAUSE:
Machine power failure after truncate bi finished causing the bi file to stay 0 in size.
FIX:
Restore backup.
If there is no backup available the following steps will bring the database up and running again:
1. Backup all database files as they are now to have at least one backup for the case any further step goes wrong.
2. Replace 0 length bi extend with no 0 length bi extend of same blocksize of other bi truncated database -> e.g. from sports database.
3. unlock the database structure with the command:
prostrct unlock <database name>
4. truncate the before image file with the force option:
proutil <database name> -C truncate bi -F
5. Check or unlock the database structure again for the case still locked with the command:
prostrct unlock <database name>
6. Check if it is possible to start the database:
proserve <database name>
7. Reset the damaged flag after shutting down the database with the command:
proshut <database name> -by
by rebuilding one database index with the command:
proutil <database name> -C idxbuild