FactoryTalk Event Archiver

FactoryTalk Event Archiver

collects data from the batch record files (

.evt

files) generated by the

FactoryTalk Batch

Server, and stores the data in a

SQL Server

database.

The

FactoryTalk Batch

Server creates an electronic batch record for every batch on the

Batch List

. View this batch record file with a text processor or spreadsheet application.

FactoryTalk Event Archiver

collects data from each electronic batch record file and writes it to the database. Each electronic batch record file contains individual lines, each representing an event that occurred in a batch.

FactoryTalk Event Archiver

inserts a unique identifier with date and time to each event into the database.

FactoryTalk Event Archiver

with Reporting Services writes data to the

BHBatchHis

SQL table in the

BatchHistoryEx

database.

Configure

FactoryTalk Event Archiver

to archive data to the database in either of two ways:

With End-of-Batch archiving,

FactoryTalk Event Archiver

inserts records into the database after a batch is removed from the batch list. The

FactoryTalk Batch

Server initiates

FactoryTalk Event Archiver

when a batch is removed from the batch list to archive the removed batch.

With Incremental archiving,

FactoryTalk Event Archiver

inserts records into the database on a pre-defined schedule. Configure this archiving time interval in

FactoryTalk Batch Equipment Editor

.

When a control recipe on the

FactoryTalk Batch

Server executes, the server adds the name of the batch record file to the

FactoryTalk Event Archiver

work queue file (

Archque.txt)

. After

FactoryTalk Event Archiver

inserts all of the electronic batch records into the database, and the file is marked for removal from the batch list,

FactoryTalk Event Archiver

removes the name of the batch record file from the work queue file.

FactoryTalk Event Archiver

does not delete the batch record file unless it is specifically configured.

If

FactoryTalk Event Archiver

cannot successfully insert each item from the batch record file, it does not remove the name from the

FactoryTalk Event Archiver

work queue file. Each time

FactoryTalk Event Archiver

runs, it attempts to insert the records from each file listed in the queue into the database. In the event of a failure,

FactoryTalk Event Archiver

attempts to store the data later. This helps make sure that failures do not result in a loss of archived data.