BI Rapidly Growing: How to Extend BI Threshold on the Fly
RecTrac 3.1
Table of Contents
Problem
The rectrac.b3 continues to grow. How do you extend the default 3GB size to avoid a BI stall and database crash?
Error Message
Receiving emails every 15 minutes relaying that the BI file is growing
Solution
- On the RecTrac Database server, run the Proenv command as administrator (right-click and run as admin).
- The command to run is: proquiet -bithreshold 8192
- This command will set the BI to an 8GB size limit temporarily.
- If the RecTrac database is restarted, the threshold sets back to the limit configured in OpenEdge Explorer.
Note: The runnaway process needs to be stopped to halt the BI growth. Find the agent and PID that lingers in a Busy status for a long time (Likely hours or days), use the Promon command to find user (database assigned user number) linked to that PID, and disconnect user.