I am trying to run a MessageBroker sheet that does a pull of 10,000 rows. I want to see what the performance will be like. I get the following error "Error: Memory usage above Engine.MAX_QUEUE"What can I do about this?

I am trying to run a MessageBroker sheet that does a pull of 10,000 rows. I want to see what the performance will be like. I get the following error "Error: Memory usage above Engine.MAX_QUEUE"What can I do about this?

book

Article ID: KB0091826

calendar_today

Updated On:

Products Versions
TIBCO MessageBroker -
Not Applicable -

Description

Resolution:
To increase engine Queue parameters, the following instructions apply to MsgSheet.cfg or MsgSheetEditor.cfg depending on whether you are running in engine or GUI mode:  
a) Go to tibco\messagebroker\bin\resources\params\MsgSheet.cfg. At the bottom of the file, increase the number for MAX_QUEUE, HI_QUEUE and LO_QUEUE. The values are in KB, so the number 8000 is approx 8 MB. Increase these values to something suitable for your worksheet, message rate etc. We cannot suggest black box values for these parameters. A bit of trial and error is involved in figuring out the correct values. A difference of about 5 MB between LO, HI and MAX is OK.
b) Also edit broker.bat or engine.bat, and increase the heap space for jre by using the -mx&ltsize parameter. This value should be at least 10 MB bigger than the size you defined for Engine MAX_QUEUE. e.g., jre.exe -mx100m -cp "..\java\mb.jar;..\java\InfraCore-2.7.4.jar;......... etc. The above example sets the heap space to 100 MB.
Please note that the number given to the java.exe should be at least 8MB larger than the number in the MAX_QUEUE parameter

Environment

Product: TIBCO MessageBroker Version: 2.5.0 OS: All --------------------

Issue/Introduction

I am trying to run a MessageBroker sheet that does a pull of 10,000 rows. I want to see what the performance will be like. I get the following error "Error: Memory usage above Engine.MAX_QUEUE"What can I do about this?