Enabling the Queue History Information

The Intelligence Runtime service uses a database table named [Queue], which is available under the [Model] schema, to keep Measures in synchronization with updates to their associated Time Defining Dimensions. This synchronization feature supports many updates to the Time Defining Dimension, but less and consolidated updates to their respective measures.

The Queue adds and removes data very quickly, which makes it necessary to diagnose the data that goes into the Queue and the data that is removed, i.e. processed by the measure.

The EnableQueueHistory settings available in the EMIRuntimeConfigurator.xml file controls this diagnostic feature. The default value of this setting is False. By changing this default value to True, predefined triggers are enabled that will move queued data into a table called [Queue_History], also under the [Model] schema. Make sure to restart the BI Gateway Runtime after you have made this configuration change in order for this setting to take effect.

Important: You must take care to change the EnableQueueHistory setting back to "False" when done with your diagnosis. Failure to do so may result in an extremely large data set in the Queue_History table.

To configure the EnableQueueHistory setting

1. Open the EMIRuntimeConfigurator.xml file in a notepad editor from the BI Gateway Installation Bin directory. For example: C:\Program Files (x86)\Wonderware\Intelligence\Bin.

2. Edit the XML file and update the following information, which is set to False, by default.:

   <EnableQueueHistory>False</EnableQueueHistory>

3. Save and close the file.