Manage Your History Queue Database Size

The History Queue Manager monitors the size of your History Queue Database. When the database is half full (approximately 1 GB), the History Queue Manager will send a warning message to the logger. When the database is close to completely full (approximately 1.9 GB), the History Queue Manager will send a warning message to the logger and stop accepting history data to prevent the loss or corruption of data. Once History Queue Manager stops accepting data, Batch Manager will shut down.

You have two options for starting Batch Manager again: wait for the data to move to the History Queue Reader, or backup the full database and replace it with an empty default History Queue Database. Each of these methods are described below.

To recover from a full History Queue Database condition

1. Start History Queue Reader on the AVEVA Batch Management Historian node which is on the Service console.

2. Allow time for History Queue Manager to push all the data to History Queue Reader and compress the History Queue Database.

3. Restart the system runtime.

To set up a default database

4. Shut down the system.

5. Copy the History Queue Database to a safe place and drop in a new default History Queue Database.

6. Restart the system.

7. Recover the saved History Queue Database at a later time by dropping the database into a system with a working History Queue Manager.

WARNING! Using this method may result in data being rejected in the Historian. You will have to resubmit the failed data using the History Error Queue application in the History Admin utility.