Administer the Error Queue

You can view and edit the data that is stored in the Error Queue table of the AVEVA Batch Management History database.

During normal batch processing, all historical data is written to the History database on the History server.

If a failure prevents data from being written into the History database, data accumulates in the Error Queue.

Use the Error Queue Admin page if you observe that historical data seems to be erroneous or if there are any other errors or warnings.

The Error Queue enables you to edit the contents of historical records that are bound for the history database but have not yet been stored because of processing errors. A skilled administrator can use the Error Queue tool to modify the error statement in the erroneous records to resolve the problems that are preventing proper processing and storage. This activity should be attempted only by someone with an understanding of SQL Server, the SQL language, and the schema used by AVEVA Batch Management to store historical data.

To access the Error Queue Admin page from the Batch Management History Server

1. On the Start menu of the AVEVA Batch Management History Server, choose Programs > AVEVA Batch Management > History Database Administration.

   The AVEVA Batch Management History Database Administration page opens.

2. Click Error Queue Admin.

   The Error Queue Admin page opens.

   Note: This example shows an error. If no errors exist, the table is blank.

   

To edit an error entry

3. Click the ID of the error statement that you want to edit.

   The Edit Error Queue Entry form appears.

4. Edit the data in the Error Statement box as needed to correct the error.

   Here is an example of an edited entry.

   

5. Click Update Entry.

Note: If you decide not to fix the error, you can clear the Disable retry attempts for this statement setting.