Rockwell Automation FactoryTalk Historian Classic for Batch User Guide - Manual (Page 48)

Chapter 3 Collecting Batch Data
delete residual data from these tables by completing the following
steps:
1. Verify that no batches are currently running.
2. From the FactoryTalk Batch Service Manager, stop the
FactoryTalk Batch Archiver service to ensure that no new
event data will be written to the database while performing
maintenance on the FactoryTalk Historian for Batch tables.
3. Query the BHTempBatch table using the following query:
SELECT * FROM BHTempBatch
4. If data exists, remove the data using the following query:
DELETE FROM BHTempBatch
5. Query the BHTempBatchEnd table using the following query:
SELECT * FROM BHTempBatchEnd
6. If data exists, remove the data using the following query:
DELETE FROM BHTempBatchEnd
7. From the FactoryTalk Batch Service Manager, start the
FactoryTalk Batch Archiver service.
48 Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014