Rockwell-automation FactoryTalk Historian Classic for Batch User Guide Manuel d'utilisateur Page 1

HISTORIAN FOR BATCH USER GUIDE Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014 Supersedes Publication BHIST-UM010A-EN-E-March 2011

Chapter 1 Welcome to FactoryTalk Historian for Batch 10 Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014

Chapter 2 Configuring FactoryTalk Historian for Batch The process of configuring FactoryTalk Historian for Batch includes the following tasks: • In

Chapter 2 Configuring FactoryTalk Historian for Batch • Creating an RSBizWare Data Source Explains required setup tasks for the FactoryTalk Batch s

Configuring FactoryTalk Historian for Batch Chapter 2 The traffic light icon displays a red light when the server is stopped. 3. Run the RSBizWare

Chapter 2 Configuring FactoryTalk Historian for Batch If a module is already installed, it will not be in the list of available modules. 6. Select

Configuring FactoryTalk Historian for Batch Chapter 2 The following instructions explain how to initialize the database schema for FactoryTalk Histo

Chapter 2 Configuring FactoryTalk Historian for Batch 5. On the RSBizWare Product and Database Connection dialog box, enter the ODBC DSN, User, and

Configuring FactoryTalk Historian for Batch Chapter 2 The SQL database has been successfully initialized with the FactoryTalk Historian for Batch sc

Chapter 2 Configuring FactoryTalk Historian for Batch DECLARE CURSOR c1 IS SELECT GMT, LCLTIME, UNIQUEID, BATCHID, RECIPE, DESCRIPT, EVENT, PVA

Configuring FactoryTalk Historian for Batch Chapter 2 4. In the Source Database area, from the Server Name drop-down, select the name of the compu

Customer Support Telephone — 1.440.646.3434 Online Support — http://www.rockwellautomation.com/support/overview.page © 2014 Rockwell Automation Tech

Chapter 2 Configuring FactoryTalk Historian for Batch This must be the user that is the owner of the user tables in the destination database. 12. I

Configuring FactoryTalk Historian for Batch Chapter 2 Each event record that is written into the FactoryTalk Historian for Batch BHBatchhis database

Chapter 2 Configuring FactoryTalk Historian for Batch 2. Modify the name of the database, BizWare, to match the name of your database, if it is dif

Configuring FactoryTalk Historian for Batch Chapter 2 NOTE All FactoryTalk Batch users previously archiving data to a BatchHis Table must perform th

Chapter 2 Configuring FactoryTalk Historian for Batch indicating you will be using FactoryTalk Historian for Batch. If you forgot to select this opt

Configuring FactoryTalk Historian for Batch Chapter 2 settings provide for optimum performance, but you may need to adjust them based on your server

Chapter 2 Configuring FactoryTalk Historian for Batch TIP These settings are a guideline and may vary depending on the number of events generated pe

Configuring FactoryTalk Historian for Batch Chapter 2 • Batch Archiver for Batch Server1 should be started at 1 minute past the hour. • Batch Arch

Chapter 2 Configuring FactoryTalk Historian for Batch that must be parsed, transformed, and stored in the database, resulting in better performance.

Chapter 3 Collecting Batch Data All batch event data is collected using the FactoryTalk Batch Archiver. The BHBatchHis database table is the source

Table of Contents Chapter 1 Features And Benefits ... 7 Types Of Users

Chapter 3 Collecting Batch Data BHInsert calls various stored procedures (in SQL) or functions (in Oracle) that parse and store the data in the tab

Collecting Batch Data Chapter 3 • BHModeChange • BHModeCommand • BHPromptResponse • RSDataPointSample For instructions on removing the sample data,

Chapter 3 Collecting Batch Data Field Name Data Type Description Example Printed Date/Time Last date the batch report was printed 2013-04-29 14:5

Collecting Batch Data Chapter 3 If you are archiving data to an SQL database, you must use the READTEXT function to retrieve all data in the Instruc

Chapter 3 Collecting Batch Data FROM bhbatchhis WHERE recordno = '5817' --PRINT 'Total length of column: &apo

Collecting Batch Data Chapter 3 NOTE Be sure to specify the .html extension, change the Save as type to All Files (*.*), and change the File Format

Chapter 3 Collecting Batch Data Column Datatype Description Example classinstance text Class- or instance-based recipe Class useridbatch list te

Collecting Batch Data Chapter 3 of essential unit data and allows data from other tables to be linked to a given unit. Column Datatype Descrip

Chapter 3 Collecting Batch Data Column Datatype Description Example contains the phase The BHParameter table contains data pertaining to a give

Collecting Batch Data Chapter 3 Column Datatype Description Example changed the parameter area text Area THE_PAINT_COMPANY eventtime date/time T

Table of Contents How To Display All Instruction HTML Data From an SQL Database ...

Chapter 3 Collecting Batch Data Column Datatype Description Example userid text User ID mjames1 area text Area THE_PAINT_COMPANY eventtime date/t

Collecting Batch Data Chapter 3 The BHBinding table contains data pertaining to the binding of the recipe to a given unit. This table allows you t

Chapter 3 Collecting Batch Data Column Datatype Description Example completion state text State when operation finished COMPLETE / STOPPED / ABO

Collecting Batch Data Chapter 3 regarding operator control of the batch in terms of state commands. A state command record is linked to only one bat

Chapter 3 Collecting Batch Data be important when reconstructing the batch. A comment record is linked to only one batch record. Column Datatype D

Collecting Batch Data Chapter 3 The BHMaterialEvent table contains a record for every MBR (material-based recipe) event. This table provides storag

Chapter 3 Collecting Batch Data linked to a given batch. Only one deviation is created per parameter or report, for the most severe limit violation.

Collecting Batch Data Chapter 3 Column Datatype Description Example limitcalculation text Type of equation used to calculate the limit: Absolute

Chapter 3 Collecting Batch Data delete residual data from these tables by completing the following steps: 1. Verify that no batches are currently r

Chapter 4 Analyzing Reports Several default reports are supplied with FactoryTalk Historian for Batch. These reports contain sample data from simula

Table of Contents Selecting Data to Display on the Batch Compare Report ... 56 Batch Compare Report Objects ...

Chapter 4 Analyzing Reports To open a batch report, expand the BatchHistorian folder and click the name of the report you want to open. The report o

Analyzing Reports Chapter 4 Argument Description Notes -U login_id User login ID Login IDs are case sensitive -d db_name Name of the database to u

Chapter 4 Analyzing Reports 6. In the Open field, enter the path of the RemoveOracleSampleBatchData.bat file you modified. 7. Click OK. The sample

Analyzing Reports Chapter 4 In Design mode, you can insert the Batch Analysis Chart object into any report using either the Insert menu, or the bu

Chapter 4 Analyzing Reports 2. In the Report Object Name box, type a unique name for the Batch Analysis Chart object. 3. In the Batch Unique ID b

Analyzing Reports Chapter 4 When you switch from Design mode to Preview mode, the Batch Summary report displays information based on the Batch ID

Chapter 4 Analyzing Reports Object Type Description each Operation of each Unit Procedure in the batch. Batch Alarm Summary Text Shows alarm info

Analyzing Reports Chapter 4 or Ctrl keys to make multiple selections in this list. Click a highlighted batch to deselect it. The Batch Compare Rep

Chapter 4 Analyzing Reports • Recipe, batch alarm, and operator prompt summary information in text form. • Bar charts showing recipes by batch and

Analyzing Reports Chapter 4 shown on the rest of the report. See the FactoryTalk Historian Classic User Guide for more information on adjusting the

Table of Contents 6 Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014

Chapter 4 Analyzing Reports The Recipes Run by Time report object shows the amount of time it took each unit procedure to run. The Batch Equipment

Analyzing Reports Chapter 4 When you switch from Design mode to Preview mode, the Runtime Report Criteria dialog box opens. From the BatchID list,

Chapter 4 Analyzing Reports The Batch Event History Report contains the following report object. You can use this report without making any modifica

Analyzing Reports Chapter 4 When you are viewing the report, you can filter information further using the dynamic filters under the header fields. C

Chapter 4 Analyzing Reports When you switch from Design mode to Preview mode the Runtime Report Criteria dialog box displays. From the MaterialNam

Analyzing Reports Chapter 4 The Material Genealogy by Material Report contains the following report object. You can use this report without making a

Chapter 4 Analyzing Reports The Operator Action Report contains the following report object. You can use this report without making any modificati

Analyzing Reports Chapter 4 When you switch from Design mode to Preview mode, the Report Object drop-down list displays at the top of the report.

Chapter 4 Analyzing Reports When you switch from Design mode to Preview mode, the Runtime Report Criteria dialog box opens. From the BatchID list,

Analyzing Reports Chapter 4 The Deviation Events Report contains the following report object. You can use this report without making any modificati

Chapter 1 Welcome to FactoryTalk Historian for Batch FactoryTalk Historian for Batch extends the capability of the FactoryTalk Historian Classic sof

Chapter 4 Analyzing Reports 70 Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014

Index A Adding the Batch Analysis Chart Object 53 Analyzing Reports 49 B Batch Analysis Chart Object (SQL Server Only) 52 Batch Analysis Report (SQL

Index I Initializing Ranges For CreateIDs 26 Initializing the RSBizWare Database On Oracle 9i 12 Initializing the RSBizWare Database On SQL Server 15

Index V Verifying the Database Connection String 23 W Welcome to FactoryTalk Historian for Batch 7 Where Can I Go for Help? 8 Rockwell Automation Pub

Rockwell Automation Support Rockwell Automation provides technical information on the Web to assist you in using its products. At http://www.rockwel

Chapter 1 Welcome to FactoryTalk Historian for Batch This information is intended for the following users. • RSBizWare Administrator The administra

Welcome to FactoryTalk Historian for Batch Chapter 1 The administration guide helps the RSBizWare administrator install and configure the software a