BI File Threshold size has been reached.

G

gregorytje

New Member
Today MFGPRO was not working. DB down cause of:

07:20:16 SRV 2: BI file size has grown to within 90 percent of the threshold value of 943194112 . (6559)
07:20:16 SRV 2: BI File Threshold size of 943194112 has been reached. (6558)
07:20:16 SRV 2: Forward processing stalled until database administrator intervention. (6560)

After a truncate everything was working.
Why this happens?
How to monitor this?
How to prevent?

MFGPRO version 86E sp2
Progress 8.3D
 
The before image contains transaction notes which are used for crash recovery.

There are three factors which make the bi file grow unexpectedly:

  • Large transaction
  • Long running transactions
  • Heavy transaction load
But, I think your problem is that you're running Progress V8 which is at least 15 years old software. Although I think they were already available in V8, I don't know how the VSTs (virtual system tables) looked like back then - maybe others know - and if they provide a VST for something like the area status (as the database didn't have storage areas back then).

How to prevent: That's easy - avoid the three factors I mentioned above. But, seriously: I think most probably this application will use a pessimistic locking strategy which will ensure long running transactions in case a user presses the update button and then leaves his desk for a long time, or for the next day.

HTH, RealHeavyDude.
 
You must log in or register to reply here.
Back
Top