85
Chapter 6
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.
Features and capabilities
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 writes data to the BatchHis SQL table in the
BatchHistory 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:
• End-of-Batch
• Incremental
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.
To Next Page
Loading...
Need help?
General
