Rockwell Automation FactoryTalk Historian Classic for Batch User Guide User 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.

Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014