Historian Administration Guide - Logic Control

1 AVEVA formerly Wonderware Historian Administration Guide AVEVA Historian Administration Guide formerly Wonderware 2 2020 AVEVA Group plc and its subsidiaries. All rights reserved. No part of this documentation shall be reproduced, stored in a ret rieval system, or transmitted by any means, electronic, mechanical, photocopying, rec ordi ng, or otherwise, without the prior written permission of AVEVA. No liability is assumed with respect to the use of the i nformation contai ned herei n. Although precaution has been taken in the preparation of this docum entation, AVEVA assumes no responsibility for errors or omissions. The information in this documentation is subject to change without notice and does not represent a commitment on the part of AVEVA. The soft ware described in this documentation is furnished under a license agreement. This soft ware may be used or copied only in accordance with the terms of such license agreement. ArchestrA, Aquis, Avantis, Citect, DYNSIM, eDNA, EYESIM, InBatch, InduSoft, InStep, Int elaTrac, InTouch, OASyS, PIPEPHASE, PRiSM, PRO/II, PROVISION, ROMeo, SIM4ME, SimCentral, SimSci, Skelta, SmartGlance, Spiral Software, Termis, WindowM aker, WindowViewer, and Wonderware are trademarks of AVEVA and/or its subsidiaries.

2 An extensi ve listing of AVEVA tradem arks can be found at: All other brands may be trademarks of thei r respecti ve owners. Publication date: Tuesday, Decem ber 1, 2020 Contact Information AVEVA Group plc High Cross Madingley Road Cam bridge CB3 0HB. UK For information on how to cont act sales and customer training, see For information on how to cont act technical support, see AVEVA Historian Administration Guide formerly Wonderware 3 Welcome .. 11 AVEVA Historian Documentation Set .. 11 Chapter 1 Getting 13 About AVEVA Historian Licensing .. 13 Viewing License Information .. 13 Refreshing the License Information .. 14 Registering AVEVA Histori an Servers .. 14 Registering an AVEVA Historian .. 15 Editing Registration Properti es .. 16 Deleti ng a Registered Historian .. 17 Movi ng a Registered Server to a Different 17 About Administrati ve Tools .. 17 About the System Managem ent Consol e .. 17 About the Managem ent 19 About the Configuration 20 System Management Consol e Menu Commands.

3 22 Microsoft SQL Server Management Studi o .. 23 Registering a Server in Microsoft SQL Server Management Studio .. 24 Navigating in Micros oft SQL Server M anagem ent 24 About AVEVA Historian Insight .. 24 Starting AVEVA Historian 24 Starting and Stopping AVEVA Historian .. 27 About the Startup Process .. 27 Starting the AVEVA Historian .. 27 About Connecting to SQL Server .. 28 Manually Starting SQL Server .. 28 Stopping the AVEVA Historian .. 29 Starting and Stopping M odul 29 Closing the System Management Console .. 31 Confi guri ng General Startup Options .. 31 Shutting Down the Entire AVEVA Historian .. 32 Creating Server 33 Adding a Server Group .. 33 Renaming a Server Group .. 34 Deleti ng a Server Group .. 34 About System-Level Consistency .. 34 Tim e Handli 34 System Parameters .. 35 System Messages .. 39 AVEVA Historian Processes .. 40 About System Dri ver and System 42 Contents AVEVA Historian Administration Guide formerly Wonderware Contents 4 Error Count Tags.

4 42 Date Tags .. 42 Tim e 42 Storage Space Tags .. 43 I/O Statistics Tags .. 43 System Monitoring Tags .. 44 Miscellaneous (Other) Tags .. 45 Classic Event Subsystem Tags .. 46 Replicati on Subsystem Tags .. 46 Perform ance M onitoring Tags .. 47 Defining Tags .. 51 About Tags .. 51 Tag Naming Conventions .. 51 Tag Properties (Tag Metadata).. 52 Tag Configuration Versioning .. 53 About Floating-P oint Values .. 53 Viewing and Configuring Tags .. 53 Confi guri ng Analog Tags .. 54 Adding an Analog Tag .. 54 Editing General Inform ation for an Analog Tag .. 58 Editing Acquisition Information for a Tag .. 59 Editing Storage Information for an Analog 61 Editing Limit Inform ation for an Anal og Tag .. 62 Editing Summary Informati on for an Anal og Tag .. 64 Editing Extended Properties for an Analog 65 Confi guri ng the Engineering Units Catal og .. 67 Confi guri ng Engineeri ng Units .. 77 Confi guri ng Discrete 79 Adding a Discrete Tag.

5 79 Editing General Inform ation for a Discrete Tag .. 80 Editing Storage Information for a Discrete 81 Editing Extended Properties for a Discrete 82 Confi guri ng Message Pairs .. 84 Confi guri ng String Tags .. 86 Adding a String Tag .. 86 Editing General Inform ation for a String Tag .. 86 Editing Storage Information for a String Tag .. 87 Editing Extended Properties for a String Tag .. 88 Confi guri ng E vent Tags .. 90 Adding an E vent Tag .. 90 Copyi ng Tag Definiti 93 Deleti ng a Tag .. 93 Organizing Tags into Groups .. 94 Adding a Group .. 94 Renaming a Group .. 95 Adding a Tag to a Group .. 95 Deleti ng a Group or Tag Reference .. 95 Filtering Tags in the SMC Details 96 Applying a Filter .. 96 Disabling or Rem ovi ng a 97 Importing and Exporting Tag Confi gurations .. 98 Importing an InTouch Data Dictionary .. 98 Before You Im port .. 98 Contents AVEVA Historian Administration Guide formerly Wonderware 5 Importing or Reimporting a Dictionary.

6 101 Viewing Tags Associated with an InTouch 108 Importing or Exporting Tag Inform ation .. 109 Encoding Form ats for Confi guration Exports .. 110 Confi guration Exporter E rror Log .. 110 Exporting a Confi 111 Importing a Configuration .. 116 Editing the Configuration Text File .. 119 Configuring Data Acquisition .. 123 About the Data Acquisition Subsystem .. 123 Data Acquisition Com ponents .. 123 I/O Server Addressing .. 124 I/O Server Redundancy .. 125 Redi recting I/O Servers to InTouch HM I Soft 125 Tim e Synchronization for Data Acquisition .. 125 Viewing Dat a Acquisition Inform 126 Confi guri ng IDASs .. 127 About IDASs .. 127 IDAS Configuration .. 128 IDAS Data Proc essing .. 128 IDAS Security and Firewalls .. 128 IDAS Error Logging .. 130 IDAS Store-and-Forward Capability .. 130 IDAS Redundancy .. 130 IDAS Autonom ous Startup .. 131 Adding an IDAS .. 131 Editing General Inform ation for an IDAS .. 133 Editing Advanced Inform ation for an IDAS.

7 134 Setting a rem ote IDAS to "Classic" .. 135 Deleti ng an 136 Confi guri ng I/O Server 136 Adding an I/ O Server Ty 136 Editing I/O Server Type Properties .. 137 Deleti ng an I/O Server Type .. 137 Confi guri ng I/O Servers .. 137 Adding an I/ O Server .. 138 Editing General Inform ation for an I/O Server .. 138 Editing Storage Rule Information for an I/O Server .. 139 Deleti ng an I/O Server .. 141 Confi guri ng Topics .. 141 Adding a Topic .. 142 Editing General Inform ation for a Topic .. 142 Editing Storage Rules for a Topic .. 144 Deleti ng a Topic .. 146 Reinitializing I/O Topics .. 146 Managing Data Storage .. 147 About Data 147 About Data Storage Subsystem Processes .. 147 Integration with Microsoft SQL 148 AVEVA Historian Administration Guide formerly Wonderware Contents 6 About Delta Storage 148 Tim e and Value Deadbands for Delta 148 Swingi ng Door Deadband for Delta Storage .. 150 Benefits of the S wingi ng Door Deadband.

8 150 Additional Options that Affect the Swingi ng Door Deadband .. 152 Swingi ng Door Deadband Exampl es .. 152 Managing the AVEVA Historian Runtime Databas e .. 155 Changi ng the Properties for the Runtime Databas e .. 156 Managing the Runtime Database .. 157 Backing Up the Runtime Database .. 157 Backing Up the 157 Restori ng the Database .. 159 Managing a Runtime Database Obj 160 Space Management for E vent and Summary History .. 161 Managing Partitions and History Blocks .. 161 Storage Partition Locations .. 161 Circul ar Storage .. 162 Alternate Storage .. 162 Permanent Storage .. 162 Buffer Storage .. 163 About the Auto-Summ ary 163 About Block Gaps .. 163 Viewing Storage and Auto-Summ ary Partitions .. 164 Viewing History Blocks .. 166 History Block Notation and 167 Automatic Deleti on of History 168 Backing Up History Blocks .. 169 About VSS-Aware Backups .. 169 Backing Up Data Stored on Net work Shares .. 169 Adding History Blocks from Pri or Versi ons to the System.

9 169 Importi ng, Inserting, or Updati ng History Data .. 171 Ways to Acquire History Data .. 171 Guidelines for Importing, Inserting, and Updati ng History Data .. 171 Importing History 172 Importing Data from an InTouch History File .. 174 Importing Data from CSV Files .. 175 Predefi ned CSV File Im port 176 About Norm al CSV File Im ports .. 176 About Fast Load CSV File Imports .. 176 General Fil e Form at for a CSV Import .. 177 Form atting the CSV File for a Normal Import .. 177 Form atting the CSV File for a Fast Load Im port .. 179 Handling of NULL Val ues in CSV 180 Copyi ng a CSV File int o an Import 180 Running the Histori an Data Importer from a Command Prompt .. 181 Inserting or Updating Data with Transact-SQL 181 INSE RT .. VALUES Syntax .. 181 Using the wwV ersion Parameter for INSERTs .. 183 Inserting Real-time Ori ginal Dat a .. 183 Inserting Original Non-St ream ed 183 Inserting Latest Revision Data .. 184 Contents AVEVA Historian Administration Guide formerly Wonderware 7 UPDA TE Syntax.

10 184 Renaming Tags .. 185 About Histori an Tag Ownership .. 186 Preparing to Renam e Application Server Tags .. 186 Renaming Tags Using the Tag Rename Utility .. 187 Updating Replicated Data .. 188 Managing and Configuri ng Replication .. 191 About 191 Replicati on Schedules .. 191 Replicati on Schedules and Daylight Savings Time .. 191 Replicati on Groups .. 193 How Replication is Handl ed for Different Types of Data .. 193 Streaming Replication .. 194 Queued Replication .. 194 Tag Configuration Synchronization bet ween Tiered Historians .. 195 Replicati on Run-time Operations .. 195 Replicati on Latency .. 195 Replicati on Delay for "Old" Data .. 195 Conti nuous Operation .. 196 Overflow Protection .. 196 Security for Data Replication .. 196 Adding a Replication 197 Adding AVEVA Insight as a Replication 200 Specifying Nami ng Schem es for Replication .. 204 Editing Replication S erver P 208 Deleti ng a Replication Server .. 209 Confi guri ng Tags to Be Replicated.