This document and any accompanying Rockwell Software products are copyrighted by Rockwell Automation
Technologies, Inc. Any reproduction and/or distribution without prior written consent from Rockwell
Automation Technologies, Inc. is strictly prohibited. Please refer to the license agreement for details.
FactoryTalk, Rockwell Automation, Rockwell Software, the Rockwell Software logo are registered trademarks
of Rockwell Automation, Inc.
The following logos and products are trademarks of Rockwell Automation, Inc.:
FactoryTalk Historian Site Edition (SE), FactoryTalk Historian Machine Edition (ME), RSView, FactoryTalk View,
RSView Studio, FactoryTalk ViewStudio, RSView Machine Edition, RSView ME Station, RSLinx Enterprise,
FactoryTalk Services Platform, FactoryTalk Live Data, and FactoryTalk VantagePoint.
The following logos and products are trademarks of OSIsoft, Inc.:
PI System, Sequencia, Sigmafine, gRecipe, sRecipe, and RLINK.
ActiveX, Microsoft, Microsoft Access, SQL Server, Visual Basic, Visual C++, Visual SourceSafe, Windows,
Windows ME, Windows NT, Windows 2000, Windows Server 2003, and Windows XP are either registered
trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.
Adobe, Acrobat, and Reader are either registered trademarks or trademarks of Adobe Systems Incorporated in
the United States and/or other countries.
ControlNet is a registered trademark of ControlNet International.
DeviceNet is a trademark of the Open DeviceNet Vendor Association, Inc. (ODVA).
Ethernet is a registered trademark of Digital Equipment Corporation, Intel, and Xerox Corporation.
Restricted Rights Legend
Warranty
OLE for Process Control (OPC) is a registered trademark of the OPC Foundation.
Oracle, SQL*Net, and SQL*Plus are registered trademarks of Oracle Corporation.
All other trademarks are the property of their respective holders and are hereby acknowledged.
Use, duplication, or disclosure by the Government is subject to restrictions as set forth in subparagraph
(c)(1)(ii) of the Rights in Technical Data and Computer Software clause at DFARS 252.227-7013.
This product is warranted in accordance with the product license. The product’s performance may be affected
by system configuration, the application being performed, operator control, maintenance, and other related
factors. Rockwell Automation is not responsible for these intervening factors. The instructions in this
document do not cover all the details or variations in the equipment, procedure, or process described, nor do
they provide directions for meeting every possible contingency during installation, operation, or
maintenance.
This product’s implementation may vary among users.
This document is current as of the time of release of the product; however, the accompanying software may
have changed since the release. Rockwell Automation, Inc. reserves the right to change any information
contained in this document or the software at anytime without prior notice. It is your responsibility to obtain
the most current information available from Rockwell when installing or using this product.
Chapter 1
Table of Contents
Overview
System Requirements
Integration with Other Rockwell Automation Products .................... 8
FactoryTalk Historian Installation Package ........................................... 9
Removing the Suite Using the Start Menu ........................................ 140
Removing the Suite Using Control Panel .......................................... 140
Removing the Suite Using the Installation DVD ............................. 141
Chapter 1
Overview
FactoryTalk Historian Site Edition (SE) provides the capability to
collect, store, analyze, and visualize data using a powerful engine and
a set of reporting tools such as time-series trends, bar charts, pie
charts, pareto and tabular trends, and a method of generating reports
using Microsoft Excel. It also uses compressed-storage data
algorithms to contain a vast amount of data in a small format.
In the following chapters, you will find information on how to
install, secure, configure, use, and troubleshoot FactoryTalk
Historian SE:
• System Requirements (page 17)
• Pre-Installation Tasks (page 23)
• Installing FactoryTalk Historian (page 25)
• Post-Installation Tasks (page 53)
• Configuring FactoryTalk Historian (page 61)
• Troubleshooting FactoryTalk Historian (page 107)
• Appendix A: Configuring Historian Servers in High
Availability Mode (page 117)
• Appendix B: Configuring Live Data Interface Redundancy
(page 129)
• Appendix C: FactoryTalk View SE TrendX (page 131)
• Appendix D: Upgrading FactoryTalk Historian (page 137)
• Appendix E: Removing FactoryTalk Historian (page 139)
Integration with Other
Rockwell Automation
Products
FactoryTalk Historian SE is closely integrated with FactoryTalk
Services Platform and the following Rockwell Automation
applications:
Application Description
FactoryTalk Live Data
(FTLD)
A direct data interface to FTLD delivers native FTLD data directly to
FactoryTalk Historian SE without requiring intermediate interfaces
and standards such as OPC.
FactoryTalk Directory FactoryTalk Historian SE uses FactoryTalk Directory to look up data
points for configuring points to historize. The FactoryTalk Directory
is also used for auto-discovering controller data sources and tags in
the initial configuration process.
FactoryTalk
Activation
FactoryTalk Historian SE is activated by Rockwell Automation's
central licensing system based on the FactoryTalk Activation
Server.
FactoryTalk
Diagnostics
Because of a close integration of FactoryTalk Historian SE with
FactoryTalk Diagnostics, all system and diagnostics messages from
FactoryTalk Historian SE are centrally stored and maintained in the
FactoryTalk Diagnostics database.
FactoryTalk Audit All FactoryTalk Historian SE Server auditing messages are stored
and available in the FactoryTalk Audit database.
FactoryTalk View SE
Trending
FactoryTalk Historian
Machine Edition (ME)
FactoryTalk View Site Edition natively trends data from FactoryTalk
Historian SE.
FactoryTalk Historian ME provides a Data Transfer service to allow
its logged data to be transferred to the FactoryTalk Historian SE for
long-term storage and analysis.
FactoryTalk
VantagePoint
The data from multiple FactoryTalk Historian SE Servers and
FactoryTalk Historian ME Servers can be brought together into a
single information management and decision support system
using FactoryTalk VantagePoint.
FactoryTalk Batch The event journal data from your FactoryTalk Batch system can be
collected through the FactoryTalk Batch Interface and stored
within FactoryTalk Historian SE.
Rockwell provides dedicated technical support internationally, 24
hours a day, 7 days a week.
You can read complete information about technical support
options, and access all of the following resources at the Rockwell
Automation Support Web site
(http://www.rockwellautomation.com/support/).
Please visit Rockwell Automation Customer Support Center
(http://www.rockwellautomation.com/support/) for access to user
forums, sample code, software and firmware updates, product
manuals, and other downloads.
The Customer Support Center offers an extensive online
knowledgebase that includes frequently asked questions (FAQs) and
the latest patches. Please visit the support site
(http://www.rockwellautomation.com/resources/support.html)
and select the Knowledgebase link located under Tools & Resources to:
• View technical and application notes.
• Obtain software patches and firmware updates.
• Subscribe to product and service e-mail notifications.
• Ask questions.
Worldwide Support
If you are not located in North America and want to contact
Rockwell Automation Support, use the Worldwide Locator
(http://www.rockwellautomation.com/locations/) for worldwide
contact information.
Training Programs
Rockwell Automation offers a wide range of training programs that
include e-learning, regularly scheduled and custom-tailored classes,
self-paced training, and certificate programs. For more information
on the trainings, visit the Rockwell Automation Training site
(http://www.rockwellautomation.com/services/training/) or call
1.440.646.3434.
If you are not located in North America and want to contact
Rockwell Automation Support, use the Worldwide Locator
(http://www.rockwellautomation.com/locations/) for worldwide
contact information.
TechConnect Support
With TechConnect Support, your site has unlimited, real-time
access to Rockwell Automation's global network of Customer
Support Centers and technical resources. TechConnect service
levels are provided at the TechConnect site
(http://www.rockwellautomation.com/services/onlinephone/techc
onnect/).
When you contact Rockwell Technical Support, please provide:
• Product name, version, and/or build numbers.
• Computer platform (CPU type, operating system, and version
number).
• Exact wording of any messages that appeared on your screen.
To find version and build numbers for each Historian Server
subsystem (which vary depending on installed upgrades, updates, or
patches), use either of the following methods:
To check the numbers with System Management Tools (SMT):
1. Go to Start > All Programs > Rockwell Software > FactoryTalk
Historian SE > System Management Tools. The System
Management Tools dialog box appears.
2. Under Collectives and Servers, select the name of the server
you want to check.
3. Under System Management Tools, select Operation > PI
Version.
The Version in Memory and Version on Disk columns
display information on versions of all the server subsystems.
If you do not have System Management Tools installed, open a
command prompt, change to the pi\adm directory, and type
piversion -v. To see individual version numbers for each subsystem,
change to the pi\bin directory and type the subsystem name
followed by the option -v (for example, piarchss.exe -v).
View Computer Platform
Information
To view platform specifications, right-click My Computer and
select Properties. For more detailed information, choose Start >
The hardware required with FactoryTalk Historian Site Edition
depends on the demands an application places on the system. The
greater the demand, the more powerful a system is required. In any
application, faster processors and more memory will result in better
performance. In addition, there should always be sufficient disk
space to provide virtual memory that is at least twice the size of the
physical memory.
FactoryTalk Historian SE
Server Machine
Learn about the system requirements for the following components
of FactoryTalk Historian SE:
• FactoryTalk Historian SE Server Machine (page 17)
• FactoryTalk Historian Live Data Interface Machine (page 18)
• FactoryTalk Historian Client Machine (page 18)
• FactoryTalk Historian Asset Framework (page 19)
• FactoryTalk Historian DataLink (page 20)
Item Description
System requirements
• FactoryTalk Historian SE 25,000 points and below
Minimum: Intel Pentium Xeon, 3.2 GHz, 4GB RAM
• FactoryTalk Historian SE 50,000 points and below
Minimum: Intel Pentium Xeon, 3.2 GHz, 4GB RAM
• FactoryTalk Historian SE 100,000 points and below
FactoryTalk Historian Asset Framework requirements
Item Description
Hardware Processor: a single quad-core processor, minimum 2.2 GHz
Operating systems
(both 32-bit and
64-bit versions, if
available)
• Microsoft Windows Server 2008 R2
• Microsoft Windows Server 2008
• Microsoft Windows Server 2003 (with Service Pack 1 or later)
• Microsoft Windows 7
• Microsoft Windows Vista
• Microsoft Windows XP with Service Pack 2 or later
Database size
Database storage is consumed depending on the type and quantity of
FactoryTalk Historian Asset Framework objects. The table below
shows approximate database sizes of some representative Asset
Framework systems.
Supported SQL Server versions (both
32-bit and 64-bit versions, if
available)
Required SQL Server components
Required memory
NOTE
For databases with up to 1000 elements, Asset Framework may be
installed on the FactoryTalk Historian server.
For more information on the Microsoft SQL Server system requirements,
refer to the Microsoft Development Network
(http://msdn.microsoft.com/en-us/library/ms143506(SQL.90).aspx).
• Express
• Standard
SQL Server 2008
• Database Engine
• Agent (backup and replication)
• 1GB for databases with up to 50000 elements
• 4 GB for databases with up to 200000 elements
FactoryTalk Historian
DataLink
Item Description
Hardware
• Physical memory:
Min. 32 MB, recommended 128 MB
• Processor: Pentium or higher
• Disk space requirements:
Min. 120 MB for application files and registry entries as well as
space for keeping a backup copy of the pisdk.msi and
ProcessBook.msi files.
Operating systems
• Microsoft Windows Server 2008 R2
• Microsoft Windows 7
• Microsoft Windows XP with Service Pack 2 or higher
Microsoft Excel 2010 (32-bit) *, **Microsoft Excel 2007 *
• FactoryTalk Services Platform 2.50 (CPR 9 SR 5)
* If this is a Microsoft Office upgrade and there is a pre-existing
installation of DataLink 4.x on that machine, a removal and
reinstallation of DataLink may be necessary. Refer to the KB article
254380
(http://rockwellautomation.custhelp.com/app/answers/detail/a_id/25
4380/kw/254380) to eliminate VBA related errors that might occur
after an Excel upgrade.
** In rare instances, the PI tab does not appear on the ribbon
immediately following the installation of the Microsoft Excel add-in.
Refer to the KB article 254379
(http://rockwellautomation.custhelp.com/app/answers/detail/a_id/25
4379/kw/254379) to resolve the situation.
Before you install FactoryTalk Historian SE, do the following:
• Synchronize time settings on Historian system computers
(page 23).
Synchronize Time Settings
on FactoryTalk Historian
System Computers
• Disable the Windows time zone (page 23).
• Learn about installation-related recommendations (page 24).
For all machines that are part of the FactoryTalk Historian system,
you must ensure that the time is set correctly and synchronized with
the FactoryTalk Historian server. In addition, make sure that all
Windows machines have the proper time-zone settings and that they
are set to automatically adjust for daylight-saving changes.
The clocks of the FactoryTalk Historian server computer and client
computers should all be synchronized. This is typically done through
the domain controller. The domain controller's time is synchronized
first by an NTP source. Then, the domain controller synchronizes
all the other computers that are a part of the FactoryTalk Historian
system.
For details, search the Rockwell Automation Technical Support
(http://rockwellautomation.custhelp.com/) web site for daylight
saving time.
Disable the Windows Time
Zone (TZ) Environment
Variable
The Windows time zone (TZ) environment variable adversely
affects the Historian server. You must ensure that TZ is not set on
the Historian server computer.
To confirm that the TZ variable is not set on computers prior to
Windows 2008:
1. Go to Start > My Computer.
2. Right-click and select Properties.
3. In the System Properties dialog box, click the Advanced tab.
4. Click Environment Variables.
5. If the TZ variable is present, delete it.
6. If prompted, restart the computer.
To confirm that the TZ variable is not set on Windows Server
2008 and 2008 R2:
1. Go to Start > My Computer.
2. Right-click and select Properties.
3. Click Advanced system settings.
4. Click Environment Variables.
5. If the TZ variable is present, delete it.
6. If prompted, restart the computer.
Learn About
We recommend that you use the default installation options.
If you want to use the SMT software installed on a FactoryTalk
Historian SE server computer to manage a FactoryTalk Historian
Live Data Interface installed on another computer, you must log on
to both computers with the same user name. (The user must have
administrator privileges on both computers.)
Chapter 4
Installing FactoryTalk Historian
In this chapter you will find instructions on how to install the
following:
• Core components of the product (page 25).
Installing Core Components
Install Microsoft SQL Server
• FactoryTalk Historian suites (page 32).
In this section you will find instructions on how to install the
following core components of FactoryTalk Historian SE:
• Microsoft SQL Server (page 25)
• FactoryTalk Services Platform (page 27)
• FactoryTalk Activation Manager (page 30)
• RSLinx Enterprise (Data Server) (page 31)
Microsoft SQL Server 2008 is a requirement for running
FactoryTalk Historian Asset Framework.
FactoryTalk Historian SE 3.01 supports SQL Server Express and
Standard Editions. Rockwell Automation recommends using the
SQL Server Express Edition, which is available on the FactoryTalk
Historian SE installation DVD. If you choose to use the SQL
Standard Edition (for example, from the FactoryTalk VantagePoint
installation DVD), please acquire appropriate Client Access
Licenses (CAL) and/or processor licenses from Microsoft. For more
information, refer to the Microsoft site
(http://www.microsoft.com/sqlserver/en/us/get-sql-server/how-tobuy.aspx).
If you already have an SQL Server, you will be able to point to it
during the installation of FactoryTalk Historian Asset Framework.
If you are going to use FactoryTalk VantagePoint as your Historian
client, you can use Microsoft SQL Server 2008 R2 that is provided
on the FactoryTalk VantagePoint installation DVD. Refer to the
following documentation before the installation of the SQL Server:
When you select this option, the following components will be
installed:
• FactoryTalk Diagnostics
• Windows Firewall Configuration Utility (WFCU)
• FactoryTalk Services Platform
FactoryTalk Services Platform is an underlying architecture and a set
of common services (such as diagnostic messages, health monitoring
services, access to real-time data, and shared plant resources such as
tags and graphic displays) that Rockwell Automation products build
upon. It is a prerequisite for all FactoryTalk-enabled software
products, such as FactoryTalk Historian SE, FactoryTalk View, and
RSLinx Enterprise.
FactoryTalk Diagnostics collects and provides access to activity,
status warnings, and error messages generated throughout a
FactoryTalk system.
For more information on FactoryTalk, refer to FactoryTalk Help.
You can access it from Start > All Programs > Rockwell Software > FactoryTalk Tools > FactoryTalk Help after you have installed
FactoryTalk Services Platform on your machine.
NOTE
Make sure to install FactoryTalk Services Platform on all the computers,
including the computer that will serve as the FactoryTalk Directory.
To install FactoryTalk Services Platform:
1. Run the FactoryTalk Historian SE installation DVD.
2. On the welcome page of the installation wizard, click Install
FactoryTalk Historian SE > Install FactoryTalk Services
The system checks if you have all the required components
installed. If any components are missing, a dialog box appears
prompting you to install the missing components. Click
Install to install the components.
The installation wizard appears.
3. On the Welcome... page, click Next.
4. On the License Agreement page, read and accept the terms of
the license agreement, selecting the I accept... option.
Click Next.
5. On the Setup Type page, select Standard and click Next.
6. On the Ready to Install the Program page, click Install to
start the installation.
Specify FactoryTalk
Directory Server Location
The Installing page appears with the status of the installation.
7. On the InstallShield Wizard Completed page, click Finish
to exit the wizard.
You may be prompted to restart your computer to complete
the installation. If you do not choose to restart your computer
at this time, be sure to restart it at the completion of the
required installation steps for FactoryTalk Historian SE.
This configuration points your client computer to the FactoryTalk
Directory server computer. Once your computer is connected to the
FactoryTalk Directory server, you can use the client computer to
administer the Network directory on the FactoryTalk Directory
server computer. Also, the FactoryTalk Administration Console
window on your client computer reflects the content of the
Network Directory server computer.
8. Click OK. The system connects to the FactoryTalk
Directory server.
Install FactoryTalk
Activation Manager
NOTE
On the computers that have FactoryTalk Services Platform
installed, you can open the Specify FactoryTalk Directory Server Location Utility dialog box also from
FactoryTalk Activation Manager allows you to download activation
files using an Internet connection, and transfer activation files to a
computer that does not have an Internet connection. Install this
software on the same computer as the FactoryTalk Directory server.
To install the FactoryTalk Activation Manager:
1. Run the FactoryTalk Historian SE installation DVD.
2. On the welcome page of the installation wizard, click Install
FactoryTalk Historian Site Edition > Install FactoryTalk