Kbase P22463: Database bi file has grown beyond 2 GB
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/19/2009 |
|
Status: Verified
SYMPTOM(s):
Bi file grew to 2 GB with error 9452
SYSTEM ERROR: Attempted to exceed maximum size on file *.b1. (9452)
Whenever database access is attempted this now results in the 9452 error.
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
Progress 9.1x
CAUSE:
A long running Process created a very large transaction that eventually exceeded the *.bi file size limit.
FIX:
1. Make a backup of the database as it is now (an OS or system backup may be the way to backup the database).
2. Create a new .st file to add one more bi extent as variable extent.
3. Prostrct add the new st file to the DB. This will convert the blown *.bi file to become a fixed extent and add one variable bi extent.
4. proutil truncate bi . This will take a while and backout the transaction.