BI File Threshold size has been reached.

[gregorytje]

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

 

[RealHeavyDude]

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.