Rockwell-automation FactoryTalk Historian Classic for Batch User Guide Manuale Utente Scaricare il pdf (Pagina 13)

Configuring FactoryTalk Historian for Batch Chapter 2

The traffic light icon displays a red light when the server is

stopped.

3. Run the RSBizWare Database Wizard. In Windows Explorer,

navigate to C:\Program Files\Rockwell

Software\RSCommon\DBLoadWiz.exe. Double-click

DBLoadWiz.exe to start the RSBizWare Database Wizard.

4. On the Welcome dialog box, click Next.

5. On the RSBizWare Product and Database Connection

dialog box, enter the ODBC DSN, User, and Password that

you configured for the Information Services Manager in step 1.

Click the Connect button.

The database is queried to determine available modules, which

are then displayed in the RSBizWare Available Modules area.

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

1 2 ... 8 9 10 11 12 13 14 15 16 17 18 ... 73 74

Table of Contents 3
Chapter 4 4
Analyzing Reports 4
Chapter 1 7
Types Of Users 8
Where Can I Go for Help? 8
Chapter 2 11
Initializing the RSBizWare 12
Database On Oracle 9i 12
Database On SQL Server 15
Migrating Batch History Data 17
From an Oracle 8i 17
Database 17
To Oracle 9i 17
From SQL Server 18
Updating the Database GMT 21
Offset Value 21
Instructions for Daylight 21
Savings Time (SQL Server 21
Manually Updating the GMT 22
Creating a Data Source For 22
FactoryTalk Historian for 22
Updating the Database 23
Connection String 23
Verifying the Database 23
Batch Archiver Event Filters 23
Recommendations for 25
Optimum Data Access 25
Event Filter 27
Recommendations For 27
Multiple Batch Server 27
Environments 27
Collecting Batch Data 29
Batch Tables and Fields 30
Sample Data 30
BHBatchHis Table 31
How To Display All 33
Instruction HTML Data From 33
Output.html 34
BHBatch Table 35
BHUnitProcedure Table 36
BHUnit Table 36
BHPhase Table 37
BHParameter Table 38
BHParameterChange Table 38
BHPrompt Table 39
BHPromptResponse Table 39
BHModeCommand Table 40
BHModeChange Table 40
BHBinding (Unit Binding) 41
BHOperation Table 41
BHFailure and BHFailureClear 42
BHStateCommand Table 42
BHStateChange Table 43
BHComment Table 43
BHControlSteps Table 44
BHMaterialEvent Table 45
BHDeviationEvents Table 45
BHTemporary Tables 47
Manually Clear BHTemporary 47
SELECT * FROM BHTempBatch 48
DELETE FROM BHTempBatch 48
SELECT * FROM BHTempBatchEnd 48
DELETE FROM BHTempBatchEnd 48
Modifying Batch Reports 50
Removing Sample Data from 50
Batch Analysis Chart Object 52
(SQL Server Only) 52
Adding the Batch Analysis 53
Chart Object 53
Batch Summary Report 54
Selecting Data To Display On 55
Objects 55
Batch Compare Report 56
Selecting Data to Display on 56
Batch Equipment Utilization 57
Utilization Report 58
Analyzing Reports Chapter 4 59
Report Objects 60
Batch Event History Report 60
Batch BHBatchHis 62
Material Genealogy By Batch 63
Material Genealogy By 63
Material Report 63
Material Report Objects 65
Operator Action Report 65
Batch Analysis Report (SQL 66
Server Only) 66
Deviation Events Report 67
Chapter 4 Analyzing Reports 70
Where Can I Go for Help? 8 73
Rockwell Automation Support 74

Commenti su questo manuale

Nessun commento

Rockwell-automation FactoryTalk Historian Classic for Batch User Guide Manuale Utente Pagina 13

Commenti su questo manuale

Prodotti e manuali riguardandi Apparecchiature Rockwell-automation FactoryTalk Historian Classic for Batch User Guide