Ge Proficy Historian User Manual

Posted on

Installing GE Proficy Historian on an iFIX SCADA AutomaTech Inc. Unsubscribe from AutomaTech Inc.? Cancel Unsubscribe. Disclaimer of Warranties and Liability The information contained in this manual is believed to be accurate and reliable. However, GE Intelligent Platforms.

  1. Ge Proficy Historian User Manual
  2. Ge Proficy Historian Latest Version
  3. Ge Proficy Historian Training
WORD PNG TXT JPG
Start display at page:
Download 'Proficy* Historian I MPORTANT P RODUCT I NFORMATION. Version 5.5 June 2013'
  • Melvyn Goodman
  • 3 years ago
  • Views:

Transcription

1 Proficy* Historian I MPORTANT P RODUCT I NFORMATION Version 5.5 June 2013

2 All rights reserved. No part of this publication may be reproduced in any form or by any electronic or mechanical means, including photocopying and recording, without permission in writing from GE Intelligent Platforms, Inc. Disclaimer of Warranties and Liability The information contained in this manual is believed to be accurate and reliable. However, GE Intelligent Platforms, Inc. assumes no responsibilities for any errors, omissions or inaccuracies whatsoever. Without limiting the foregoing, GE Intelligent Platforms, Inc. disclaims any and all warranties, expressed or implied, including the warranty of merchantability and fitness for a particular purpose, with respect to the information contained in this manual and the equipment or software described herein. The entire risk as to the quality and performance of such information, equipment and software, is upon the buyer or user. GE Intelligent Platforms, Inc. shall not be liable for any damages, including special or consequential damages, arising out of the user of such information, equipment and software, even if GE Intelligent Platforms, Inc. has been advised in advance of the possibility of such damages. The user of the information contained in the manual and the software described herein is subject to the GE Intelligent Platforms, Inc. standard license agreement, which must be executed by the buyer or user before the use of such information, equipment or software. Notice 2013 GE Intelligent Platforms, Inc. All rights reserved. *Trademark of GE Intelligent Platforms, Inc. Microsoft is a registered trademark of Microsoft Corporation, in the United States and/or other countries. All other brands or names are property of their respective holders. We want to hear from you. If you have comments, questions, or suggestions about our documentation, send them to the following address:

3 Table of Contents Proficy Historian 5.5 New Features.. 6 User Defined Data Types.. 6 Dynamically Sized Array Tags.. 6 Enhanced Data Query Filtering.. 6 Updated Operating System Support.. 6 Permanent Rename and Permanent Delete of Tags.. 6 New Calculation Modes.. 7 New Query Modifiers.. 7 New Comparison Modes.. 7 New Sampling Mode.. 7 Proficy Historian 5.5 Release Notes.. 8 Installation and Upgrade Troubleshooting.. 8 Upgrading from Historian 3.1 or greater.. 8 Upgrading to Historian 5.5 on a Windows 64-bit Operating System.. 9 Installing Proficy Historian Archive Backup Behavior.. 9 Security Compatibility with Historian Install and Upgrade.. 9 Installation Folders for Proficy Historian.. 9 On a 32-bit Windows Operating System:.. 9 Proficy Historian IHA (Historian Archive) Migration Tool Proficy Historian and Microsoft Excel Installing Excel Add-in for Excel 2007, Excel 2010(32-bit/64-bit) or Excel Support for VMWare Products Best Practices for VMWare Suspended Images/Power Metered Images I/O Devices and Connections and VMware.. 12

4 USB Controllers and VMware USB Devices, Historian, and VMware Additional VMware Notes Proficy Historian Alarm and Events Server with Microsoft SQL Server Configuring the Proficy Historian OLE DB Provider Properties in a Linked Server Proficy Historian Alarm and Event Archive Migration Backing up Alarm and Event Data Migrating Historical Alarm and Event Data Enhanced Security by Enforcing Strict Authentication Adding Multiple Archives Browsing Tags from Historian Clients Throttling Store and Forward Buffer Flush Configuring the BufferFlushMultiplier Proficy Historian and Antivirus Software Proficy Historian and Microsoft Windows Windows Firewall Enabled by Default in Windows XP SP3, Vista, Server 2003, and Server Optimizing Server Settings for Windows 2003 Server, or Windows 2008 Server Archiver Obtaining List of Domain Controllers Proficy Historian General Troubleshooting Receiving an ihconfigurationgetproperties Error User API Programs Not Freeing Up Memory Tag Rename Maximum Buffer Memory Size Differences between Proficy Historian and Proficy Historian for SCADA Upgrading from Proficy Historian for SCADA to 5.5 Plant Historian To upgrade Proficy Historian for SCADA to Plant Historian: Procedure for Updating the Historian License for the Proficy Mobility product to Plant Historian21

5 To update your Historian to Plant Historian: Command Line support for Alarm Migration Tool Command Line Switches (Case does not matter): EXAMPLES: Using Arrays and MultiField tag elements in Calculation, Server to Server Collectors Using Arrays in the Calculation and Server to Server collectors Using Multi field Tags in the Calculation and Server to Server collectors Historian Archive Ingestion Service Proficy Historian 5.5 System Requirements Hardware Requirements Guidelines for Determining Historian Server Size Example System for Sustained Event Rate* Recommended Historian Collector Configurations Recommended Historian Alarm and Event Archiver Configurations Hardware Requirements - Proficy Historian on Windows XP Embedded Software Requirements Compatibility with Other Proficy Products.. 30

6 Proficy Historian 5.5 New Features User Defined Data Types Proficy Historian now gives you the ability to create user defined data types which include multiple fields of selected data types. You can then create Historian tags of that type. All the tag operations can be performed on this tag such as raw and calculated queries. For more information, refer to the User Defined Type topic in the Using the Historian Administrator e-book in the online help. Dynamically Sized Array Tags Proficy Historian now allows you to store a set of values with a single timestamp and quality and then read the elements back individually or as an array. For more information, refer to the Array tag topic in the Using the Historian Administrator e-book in the online help. Enhanced Data Query Filtering With a Filter Expression you can now enter complex filter conditions that instruct the Data Archiver to examine the collected data and return time ranges that match the condition so that those ranges can be queried further. For more information, refer to the Using Filter Expression topic in the Advanced Topics e-book in the online help. Updated Operating System Support Proficy Historian 5.5 supports running on Windows 8 and Windows Server Permanent Rename and Permanent Delete of Tags You can now efficiently manage your tags and memory by truly deleting or renaming tags to meet your current needs instead of aliasing them and hiding the tags. Truly renaming or deleting the tags that are no longer needed saves disk space and memory and makes the names available for re-use. If you do a Permanent Rename or Delete, the reference to the previous names are changed or deleted from the Config file, but the previously collected data does not get purged. For more information, refer to the Permanently Rename a Tag and Permanent Delete a Tag topics in the Using the Historian Administrator e-book.

7 New Calculation Modes Proficy Historian now has the following calculation modes that add more combinations and contexts for data retrieval: FirstRawValue/FirstRawTime retrieves the first good raw sample value or timestamp for a given time interval. LastRawValue/LastRawTime retrieves the last good raw sample value or timestamp for a given time interval. Tagstats returns multiple calculation modes for a tag in a single query. For more information, refer to the Calculation Modes topic in the Advanced Topics e-book. New Query Modifiers Proficy Historian adds three additional Query Modifiers that alter the behavior of Sampling and Calculation Modes to meet your retrieval requirements. INCLUDEBAD directs the Data Archiver to consider raw samples of bad data quality when computing calculation modes. FILTERINCLUDEBAD directs the Data Archiver to consider the values of bad quality data when determining the time ranges that match the filter condition. USEMASTERFIELDTIME returns raw values of all the field elements in a multifield type tag at the timestamp determined by the MasterField. For more information, refer to the Query Modifiers topic in the Advanced Topics e-book. New Comparison Modes Proficy Historian now allows you to do a bitwise comparison for a tag. By using bitwise comparison you can compare the binary values of the given filter tag with the bits specified in the condition. The Bitwise comparison modes are: AllBitSet (^) comparison mode returns True when the binary value of the Filter Tag is equal to all the bits in the condition. AnyBitSet (~) comparison mode returns True when the binary value of the Filter Tag is equal to any of the bits in the condition. AnyBitNotSet (!~) comparison mode returns True when the binary value of the Filter Tag is not equal to any one of the bits in the condition. AllBitNotSet (!^) comparison mode returns True when the binary value of the Filter Tag is not equal to all the bits in the condition. For more information, refer to the Using Filter Expression topic in the Advanced Topics e-book. New Sampling Mode Proficy Historian now gives you a new sampling mode which can be used on retrieval of data that has already

8 been collected in the arhive. RawByFilterToggle sampling mode is a form of filtered data query. A filtered data query returns data values for a particular time period whereas RawByFilterToggle sampling mode returns the time periods where the condition becomes TRUE or FALSE. For more information, refer to the Sampling Modes topic in the Advanced Topics e-book. Proficy Historian 5.5 Release Notes Installation and Upgrade Troubleshooting IMPORTANT: Historian 5.5 does not support FIX32 and CIMPLICITY native collectors running on the Hitorian server or with 5.5 client tools, but these collectors will still be able to connect and send data to the 5.5 server, provided they have the proper SIMs and configuration. You must un-install Historian 3.0 or 3.1, which contains FIX32 and CIMPLICITY native collectors, and then install Historian 5.5. Upgrading from Historian 3.1 or greater Before upgrading Historian, it is recommended that you follow these steps: 1. Stop the Historian Data Archiver service. 2. Make sure you back up all archive data files (*.iha), configuration files (*.ihc) and backup files. By default, you can find these files in the c:proficy Historian DataArchives folder. The upgrade process will update these existing files to the new version. These new files are not backward compatible with the older version of Historian. 3. Optionally, use the Excel Add-In to export your tag configuration for all tags. It is recommended that you export tags associated with each collector to a separate worksheet. 4. If you are using a Microsoft SQL Server Data Engine (MSDE) database, then the Historian installer will install SQL Server Express 2008 and migrate the MSDE data into SQL Server Express 2008 automatically. NOTES: Please stop all Proficy applications (ifix, CIMPLICTY, PlantApps) and any custom applications which read/write data from Historian, before upgrade. If you choose to upgrade Historian, then you must upgrade your Historian license key to the new Proficy Historian license key. For upgrading Proficy Historian from version 3.1 to 5.5, you must uninstall both the Historian 3.1 service packs and/or SIMs and base product manually (from Control Panel -> Add/Remove Programs) and then, run the Historian installer. For upgrading from Historian versions older than 3.1, you must uninstall the old product then install the newer version of Proficy Historian. During maintenance or upgrade on Proficy Historian install with SIM, you may be prompted with a Re-boot dialog after the SIM uninstall. Click 'No' on the Re-boot dialog and continue. Main installer will proceed and ask for reboot at the end.

9 Upgrading to Historian 5.5 on a Windows 64-bit Operating System If you are using the 32-bit Data Archiver and have created registry keys such as RouteInterfaceStautsMsg under the Data Archiver in a 64 bit WoW registry path 'HKEY_LOCAL_MACHINESOFTWARE Wow64Intellution, Inc.iHistorianServicesDataArchiver, then you must manually re-create them under native 64-bit registry path 'HKEY_LOCAL_MACHINESOFTWAREIntellution, Inc.iHistorianServicesDataArchiver. You can also delete all the Data Archiver related registry entries from the 64 bit WoW registry path. Installing Proficy Historian 5.5 Before installing Proficy Historian, stop all running Proficy Historian services by going to Administrative Tools, and then Services. The installation process for the Proficy Historian 5.5 should automatically uninstall your SIMs. However, the automatic uninstall of your SIMs may fail during the install if files are locked. An error will display indicating the file which is in use. You will be required to stop the services or applications locking the file, and then attempt the installation again. You can choose to manually uninstall your Historian SIMs prior to installing the Historian 5.5. To uninstall SIMs manually, you must first stop all Historian Services, then go into your systems Control Panel, click Add/Remove Programs, and remove those SIMs. It is recommended after any SIM uninstall to restart your system, if prompted. NOTE: When you start Proficy Historian, it may take a longer time to start an archiver depending on number of archives online, number of tags, and number of connections. Archive Backup Behavior If you back up an archive more than once, the backup tool will, by default, attempt to use the same name for the backup file and will detect that an archive with the same name already exists. Rename the backup archive file or move the original backup archive file from the target backup directory. Security Compatibility with Historian Install and Upgrade Proficy Historian offers an enhanced security mode called Strict Client and Strict Collector authentication. Both modes are disabled when upgrading Historian. This option enables you to connect and complete the installation regardless of the version of your clients and collectors. You can enable the feature after upgrade, if desired. Installation Folders for Proficy Historian On a 32-bit Windows Operating System: The default installation folder is: C:Program FilesProficyProficy Historian The archives, log files, and buffer files are installed to these locations: C:Proficy Historian DataArchives C:Proficy Historian DataBufferFiles

10 C:Proficy Historian DataLogFiles The help files are installed to: C:Program FilesProficyProficyDoc1033Historian On a 64-bit Windows Operating System: The default destination folder for a 64-bit Historian Server is: C:Program FilesProficyProficy Historianx64Server directory. The default destination folder for all 32-bit components (such as collectors and APIs) is: C:Program FilesProficyProficy Historianx86 directory The default archives, log files, and buffer files are and help are same as a 32-bit operating system. Be aware that when upgrading earlier versions of Proficy Historian, the Server, OLEDB, API, NonWebAdmin, Samples, and Online help installs to the new locations described above. IMPORTANT: If you have uninstalled a previous version of Proficy Historian and did not remove the archives, ensure you direct the new Historian to the previous install folder (for example, C:Program FilesGE FanucProficy HistorianArchives ) so that the Historian install program will find the existing archives and configuration file. If you are rolling back to a previous versions of Historian, it is recommended to backup the Data Archives and Config file. NOTE: On a 64-bit Windows Operating System, all 32-bit components (such as collectors and APIs) related registry keys will be located under HKEY_LOCAL_MACHINESOFTWAREWow6432NodeIntellution, Inc.iHistorian. For more information, refer to the Installing the Historian Server topic in the online help. Proficy Historian IHA (Historian Archive) Migration Tool Historian now allows you to migrate up to 30 years of old data. The Historian Archive Migration Tool is commonly used for: Merging archives to save space. Migrating archives from one server to another with different server names. Reducing large archives into smaller archives. For more information, refer Migration Tool section in Getting Started Guide e-book.

11 Proficy Historian and Microsoft Excel Installing Excel Add-in for Excel 2007, Excel 2010(32-bit/64-bit) or Excel 2013 Requirement: Make sure that Visual Basic for Applications is installed before installing the Excel Add-in for Excel 2007, 2010 or This is typically located under Office Shared Features in the Office 2007, 2010 or 2013 installation process. To install Excel Add-in for Excel 2007, 2010 or 2013, use the following steps: 1. In Excel 2007, click the Office button in the top left corner. o In Excel 2010,2013, click the File tab -> Options. 2. Click Options and then go to Add-Ins. 3. Make sure the drop-down list for Manage is set for Excel Add-ins, and click Go. 4. Select Proficy Historian Add-In for Excel For Excel 2007 and above select Proficy Historian Add-In and Proficy_Historian_Helper. If the installation is successful a new menu item appears under Add-Ins or as Proficy Historian ribbon. If it does not appear then you may need to shut down and restart Excel. If you receive an error such as: 'This workbook has lost its VBA project, ActiveX controls and other programmability-related features ' the most probable cause is that Visual Basic for Applications was not installed. Install this application by navigating to Office Shared Features through the Office 2007, 2010 or 2013 installation process. Support for VMWare Products Proficy Historian provides support for VMware ESXi Server version 5.0 and above. The virtualization capability provided by VMware lets you run multiple virtual machines on a single physical machine, with each virtual machine sharing the resources of that one physical computer. Please be aware that while we have tested VMware ESXi 5.0 and above, issues with the VMware software or the virtualized environment are outside the scope of GE Intelligent Platform's responsibility. You must use VMWare Compatibility Hardware and Software before installing Proficy Historian 5.5 Data Archiver on a Virtual Machine. For the current release, the only supported type of Proficy licensing for use with VMware is keyless (software) licensing. NOTE: VMware Player is also not supported. IMPORTANT: Advanced features of ESXi Server (such as VMotion, High Availability, and Clustering support) have not been tested with Proficy Historian. For information regarding VMWare's compatibility and its supported software and hardware environments, please visit: Best Practices for VMWare To prevent disk growth during run time, make sure you pre-allocate the hard disk in your VMware image. If the VMware disk needs to grow at runtime because of IHA growth or creation, then the Data Archiver can be slowed. If there is not enough disk space on the host machine to grow the VMware disk, then the archiver may lose data.

12 Suspended Images/Power Metered Images ESXi servers have power meter functions and options as well as the ability to suspend images to conserve power. We do not recommend or support these functions due to the potential effects on the Guest operating system, specifically in regards to polling I/O and timely updates. I/O Devices and Connections and VMware There are a multitude of devices and methods of communications on the market. These devices may be used if you can successfully connect them from the virtual machine through the physical HOST, but we do not support the setup of that connection. Be aware that device drivers used to write to proprietary cards for the ESXi HOSTS as part of virtual device setup can cause issues. USB Controllers and VMware The USB controller has these limitations when using Historian and VMware: Minimum virtual hardware version 7 is required. Only one USB controller of each type can be added to a virtual machine. The USB arbitrator can monitor a maximum of 15 USB controllers. If your system includes an additional number of controllers and you connect USB devices to these controllers, the devices are not available to be passed through to a virtual machine. You must add a USB controller to a virtual machine before you can add a USB device. You must remove all USB devices from a virtual machine before you can remove the controller. USB Devices, Historian, and VMware USB devices have these limitations when using Historian and VMware: A virtual machine may have up to 20 USB devices attached to it, however each unique USB device can only be attached to one virtual machine at a time. Unsupported USB devices may not interact as expected with other ESXi features. Additional VMware Notes GE Intelligent Platforms cannot guarantee the performance of the Historian software in a virtualized environment due to the wide range of parameters associated with the hardware, configuration, memory settings, third-party software installations, and the number of virtual machines running all of which can affect performance. Therefore, GE Intelligent Platforms cannot provide support related to the performance of the Historian software running on a virtual machine if its determined that the issue is related to the virtual environment. Also, GE Intelligent Platforms does NOT provide support or troubleshoot a customer's virtual machine infrastructure. It is the responsibility of you, the customer, to ensure that the performance of the Historian software and any third-party applications (especially those not recommended by GE Intelligent Platforms) are adequate to meet the needs of your run mode environment. GE Intelligent Platforms does not support issues related to functionality that is not available as a result of running in a virtual machine infrastructure. Examples include the functionality of card level drivers such as those for the Genius family of drivers, the Allen-Bradley DH/DH+ drivers, the Cyberlogic's MBX Driver for the SA85 card, as well as functions requiring direct video access. Check with the vendor of your third-party application for support statements regarding that third-party

13 product's ability to run in a virtualized environment. For more detailed information regarding VMware specifications and requirements, please visit the VMware web site: Proficy Historian Alarm and Events Server with Microsoft SQL Server 2008 If you choose to install the Alarm and Event Archiver then you may be prompted to restart your computer to complete the SQL Server Express 2008 and Plant Database installations. Configuring the Proficy Historian OLE DB Provider Properties in a Linked Server To configure the Proficy Historian OLE DB provider Properties, perform the following steps: 1. Expand the Providers folder which is located inside the Linked Servers folder in the Object Explorer. 2. Right-click the iholedb.ihistorian provider and select Properties. 3. Enable Supports 'Like' operator Option. NOTES: Select the Level Zero Only option only when older versions of SQL Server are used. For better performance while executing small queries, select the Allow in Process option. Clear the option if larger queries are to be executed. For configuring the Historian 64-bit OLE DB provider as a linked server, the Allow in Process option is mandatory. Proficy Historian Alarm and Event Archive Migration If you are upgrading to the newest version of Historian and you have already collected alarms, you can migrate the Historical Alarm and Event data after upgrading to Proficy Historian 5.5. Alarms are not available for retrieval until they are migrated. New alarms collected with the new version of Proficy Historian will be available immediately. Before migrating alarm and event data, ensure that you have backed up the data. To migrate your alarms into the new alarm database, you must do a backup of the old alarms and restore them into the new database. The backup can be done before upgrade using the Historian Administrator or it can be done after upgrade using the Proficy Alarm Database Migration Tool on the start menu. Backing up Alarm and Event Data To back up the Alarm and Event Data, perform the following steps:

14 1. Click the Backup Existing Alarms and Events tab. 2. In the Time Range section, in the From and To fields, set the start time and end time. You may need to migrate small time periods if you have many alarms. If you need to migrate the alarms in blocks of time, do the oldest alarms first. 3. In the Database Name field, enter the name of the database from which you have to backup the data. Typically, this will be the same as the SQL Server you are currently using. 4. Select either windows or SQL server authentication by selecting the Use Windows Authentication or Use SQL Authentication options. 5. In the User Id and Password fields, enter the login credentials. Be sure to use a user name with permission to connect and backup alarms. 6. In Backup Folder Path field, give the absolute path, including file name, to store the backed up alarms. For example, c:tempmarch2010.bak. Provide the path to place the backup folder on the local computer and if your SQL server is running on a remote computer, enter a path that exists on the remote computer. 7. Click the Test Connection button to check that the source database is active and the information is accurate. The Begin Backup button is activated. 8. Click the Begin Backup button to backup the alarms and when the backup is complete, you will get a count of rows backed up. Migrating Historical Alarm and Event Data To make the backed up alarms available for retrieval, you have to write them into the current alarm database. To migrate Historical Alarms and Events to the latest version of Proficy Historian, perform the following steps: 1. Click the Migrate Alarms and Events Backup tab. 2. In Backup File Path field, provide the location of the file containing the backup. If your server is running on a remote computer, enter a path that exists on the remote computer. 3. In the Database section, in the SQL Server Instance Name field, enter the server name. In the Database Name field, enter the name of the database to which you have to migrate the data. Click the Test Connection button to check that the database is active and the information is accurate. TIP: You can find this information in the registry under: HKEY_LOCAL_MACHINESOFTWAREIntellution, Inc.iHistorianServicesAlarmArchiver. 4. Select either windows or SQL server authentication by selecting Use Windows Authentication or Use SQL Authentication options. 5. In the User Id and Password fields, enter the login credentials. Be sure to enter an account with permission to restore alarms. 6. Click the Test Connection button to check that the database is active and the information is accurate. The Begin Migration button is activated and the alarm data is restored. 7. Click the Begin Migration button to migrate the data. Enhanced Security by Enforcing Strict Authentication Proficy Historian comes with enhanced security features to control access and protect user account credentials. For more information, refer to the Implementing Strict Authentication topic in the online help. SIMs are available for pre- 5.5 versions of Historian that can allow clients and collectors to connect to 5.5 Data Archiver even when the Enforce Strict security options are enabled. For example, an Excel Add-In running on Historian 4.0 will be able to connect to a 5.5 Data Archiver with Enforce Strict Client Authentication set to enabled. Or, a Historian 3.5 OPC collector can connect even when Enforce Strict Collector Authentication is enabled. The ability to connect is subject to the same rules as 5.5 clients and collectors. The account used to

15 connect must be known at the Data Archiver computer. The following table highlights the SIMs that apply to pre-5.5 versions of Proficy Historian. Historian Version SIM 5.0 IH50_SIM5.exe or newer 4.5 IH45_SIM12.exe or newer 4.0 IH40_SIM23.exe or newer 3.5 IH35_SIM20.exe or newer 3.0 Check the Historian SIM download section of the GlobalCare web site. 3.1 Check the Historian SIM download section of the GlobalCare web site. Installing SIMs may help other Proficy products connect but you should refer to the support site for each product to get the latest information. For more information, refer to the Implementing Strict Authentication topic in the online help. Adding Multiple Archives If you are creating multiple archives on a remote machine, then you must ensure that you have enough hard disk space on that machine. The Allocate Space slider does not display a remote machine's hard disk space. In other words, if you are creating multiple archives on a remote machine, you must ignore the percentage of available disk space will be used message displayed by the Allocate Space slider. If you receive the error message Runtime error 330 Invalid Property Value' while creating multiple archives on a remote machine, it is probably because you do not have enough hard disk space on that machine. When you click OK on the error message, Historian Administrator may disappear. You must now clean up the remote machine's hard disk space and restart the Historian Administrator.

16 Browsing Tags from Historian Clients By default, the Historian clients can return a maximum of 100K tags at a time. If the Historian clients are capable of retrieving more than 100K tags, then you can configure the maximum tags the search should return by adding the 'MaxTagsToRetrieve' registry key. For more information, refer to the Browsing Tags from Historian Clients topic in the online help. Throttling Store and Forward Buffer Flush Store and forward buffering is a key feature of Historian collectors. It prevents data loss during planned or unplanned network outage between a collector and Historian server. If the collector is disconnected from the archiver for several hours or days, many megabytes of data can be buffered and must be delivered by the collector to the Data Archiver upon reconnect. Since all data is sent from the collector to the archiver in time order, the design goal has been to catch up to real time as quickly as possible by sending data as fast as possible. If this is not the desired behavior because you want to limit the network load on a slow, shared Wide Area Network (WAN) or you want to limit the CPU load on the Data Archiver caused by the incoming data, you can configure the collector to throttle the data it is sending. NOTE: Throttling Store and Forward does not affect the alarm and events collector. Configuring the BufferFlushMultiplier Configuring the throttle is easy, but due to modifying a key in the registry, this should be done with caution. A DWORD registry key called BufferFlushMultiplier is present under each collector under: HKey_Local_MachineSoftwareIntellution, Inc.iHistorianServicesYOUR_COLLECTOR_TYPE. To slow the store and forward throttling, enter a value of 2 in the registry on the BufferFlushMultiplier key. To disable throttling, set the value to 0 or delete the registry value. The 2 means that the collector should never send data at more than 2 times its normal rate. This limits network and CPU load, but because data is sent in time order, you are not able to retrieve near current time historical data until the throttled flush is complete. Proficy Historian and Antivirus Software It is recommended that antivirus software be configured to exclude Historian archive and ihc files from antivirus scans, as this may interfere with server operation.

17 Proficy Historian and Microsoft Windows Windows Firewall Enabled by Default in Windows XP SP3, Vista, Server 2003, and Server 2008 If you install Proficy Historian on a Windows XP system, you will be prompted to allow Proficy Historian to reconfigure the Windows Firewall. If you answer Yes, Historian will be added to the firewall's exception list and set to Enabled. If you answer No, Historian will be added to the list and set to Disabled. You can change this setting through the Windows Firewall control panel at any time. Optimizing Server Settings for Windows 2003 Server, or Windows 2008 Server If you are running Historian on a Windows 2003 Server or Windows 2008 Server computer, do not set your File and Printer Sharing for the Server optimization options to Maximum Data Throughput for File Sharing. The Maximize Data Throughput for File Sharing setting in File and Printer Sharing for Microsoft Networks Properties controls the system cache size and allows the cache to grow very large. This could cause excessive paging when dealing with large files and might interfere with applications like Historian. It is recommended that you select the Maximum Data Throughput for Network Applications. To view or change your Server Optimization settings on Windows 2003 or Windows 2008 servers: 1. Open the Control Panel. 2. Double-click the Network and Dial-Up Connections icon. The Network and Dial-up Connections dialog box appears. 3. Right-click the Local Area Connection Properties icon and select Properties. 4. Select the File and Printer Sharing for Microsoft Networks component and click the Properties button. 5. Ensure that the Maximize Data Throughput for Network Applications options is selected. 6. Click OK. For more information on changing the Server Service properties, refer to the Microsoft Knowledge Base article Q Archiver Obtaining List of Domain Controllers If the archiver is configured to use domain group security, the data archiver obtains the list of primary and backup domain controllers at archiver startup. If a domain controller is not available at that time or if you add new domain controllers, they are not seen by the archiver until the next time the archiver is restarted.for example, if your backup domain controller was not available on archiver startup, the archiver will not fail over to the backup domain controller for user authentication. For more information, refer 'Working with Security' section in Online Help. Proficy Historian General Troubleshooting IMPORTANT: Before you start to troubleshoot any performance-related issue, it is important first to set correct expectations. If you installed Proficy Historian on a computer that only meets the minimum hardware requirements, but the computer does not meet the recommended hardware requirements, you may be unable to make a noticeable improvement to the performance of Proficy Historian unless you upgrade the hardware on the computer.

Sambandar thevaram in tamil pdf. 18 Receiving an ihconfigurationgetproperties Error If you receive a single ihconfigurationgetproperties[-2] error in the collector.log file, the error most likely occurred as a result of the collector connecting and querying for changes in the tag database immediately, getting a timeout, and then immediately querying again and succeeding. User API Programs Not Freeing Up Memory User API Programs built with anything other than Visual Studio.NET should be modified to call ihufreeptr() to free any memory pointers returned by the User API. Do not free these pointers using free() in your application or you can risk memory corruption. Tag Rename Whenever you rename a tag, only the active tag name (that is, the new tag name) will be visible in the Tags list on the Historian Administrator Tag Maintenance screen. You can rename tags multiple times, but only the latest active tag name will be visible in the Tags list. You can also retrieve the data using any alias (that is, the new or old tag names). However, the Tag Maintenance screen will display only an active tag name (that is, the new tag name). Whenever you change or copy a tag name, the information about the old tag name, new tag name, and time stamps are all recorded in the audit trail. Maximum Buffer Memory Size You can specify the maximum memory buffer size that an archiver queues can take. By default, memory buffer size is 100MB. Differences between Proficy Historian and Proficy Historian for SCADA 5.0 The following table highlights the different components supported by Proficy Historian and Proficy Historian for SCADA 5.0 Compenents Supported Proficy Historian Proficy Historian for SCADA 5.0 Historian Server Yes Yes Historian Administrator Yes Yes Historian Client Tools Yes Yes

19 Compenents Supported Proficy Historian Proficy Historian for SCADA 5.0 ifix Collector Yes Yes OPC Collector Yes Yes Server to Server Distributor Yes Yes Historian Excel Add-in Yes Yes Client Access API Yes Yes Alarm Event Archiver Yes Not Available Calculation Collector Yes Not Available File Collector Yes Not Available ifix Alarm Collector Yes Not Available OPC Alarm Collector Yes Not Available ServerToServer Collector Yes Not Available Simulation Collector Yes Not Available

20 Compenents Supported Proficy Historian Proficy Historian for SCADA 5.0 OSI PI Collector and Distributor Yes Not Available Incoming Remote Collector Connection Yes Not Available Collector ToolKit Yes Not Available Windows Performance Collector Yes Not Available Upgrading from Proficy Historian for SCADA to 5.5 Plant Historian If you are converting from Proficy Historian for SCADA to 5.5 Plant Historian, you must change your tags from SCADA data store to Historical data store, if your Plant Historian license does not have any SCADA data stores or tags. This is because, the Data Archiver will shutdown at startup due to licensing and you will not have the opportunity to change the tags in the Historian Administrator. If you change the entire SCADA data store into a Historical Data Store then all the tags will become historical tags that have no time-limit on collection. To upgrade Proficy Historian for SCADA to Plant Historian: 1. Purchase a license for the Plant Historian. 2. Upgrade your software to Proficy Historian. 3. Stop the Data Archiver service. 4. Apply your new Historian license key with the Historical Tags. Make sure the new license has enough historical tags to hold all tags the from SCADA Historian because you have to convert all the tags. You can see the licensed tag counts in the Proficy Common License Viewer. Here, you can view only the tag counts for Proficy Historian product and not for the Proficy SCADA Historian product. 5. In the command prompt, change the directory to the location of the ihdataarchiver.exe. For example: cd C:Program FilesProficyProficy HistorianServer on 32 bit operating system. 6. In the command prompt run the following command line: ihdataarchiver.exe UpgradeScadaToHistorical [NewDataStoreName] The UpgradeScadaToHistorical keyword tells the Data Archiver to convert the current SCADABuffer to a Historical Data Store.The new name for this historical store is specified following the keyword UpgradeScadaToHistorical. For example: ihdataarchiver.exe UpgradeScadaToHistoricalUserBuffer will convert the scada buffer and name the new DataStore 'UserBuffer'.

21 7. Start the Data Archiver service. If the conversion was successful, you can start your Data Archiver and run the Historian Administrator as long as you have enough Historical tags. If there are any errors you can view them from the Data Archiverlogfile. Procedure for Updating the Historian License for the Proficy Mobility product to Plant Historian If you are using Proficy Mobile to display data from Proficy Historian 5.5 or above your Historian license is limited to a certain amount of data. You can purchase a full Proficy Historian license and update your license key. For example, if you had a 30-day buffer for data, you can change this to unlimited data with the Plant Historian, so that the data is not overwritten after the 30-day buffer is reached. When the license is upgraded you will need to convert your rotational (SCADA) data store to a user data store by performing the following steps so that all tags become historical tags that have no time limit on collection. To update your Historian to Plant Historian: 1. Shut down the Data Archiver. 2. Apply your new Historian license key with Historical Tags.Make sure the new license has enough historical tags to hold all tags. You cannot upgrade only some of the tags.you have to upgrade all the tags. You can see the licensed tag counts in the Proficy Common License Viewer. 3. From the command prompt, change the directory to the location of the ihdataarchiver.exe. For example: cd C:Program FilesProficyProficy HistorianServer 4. From the command prompt run the following command line: ihdataarchiver.exeupgradescadatohistorical [NewDataStoreName] or if you are running a 64 bit operating system, run the 64 bit Data Archiver: ihdataarchiver_x64.exe UpgradeScadaToHistorical [NewDataStoreName] The UpgradeScadaToHistorical keyword tells the Data Archiver to convert the current SCADABuffer to a Historical Data Store.The new name for this historical store is specified following the keyword UpgradeScadaToHistorical. For example: ihdataarchiver.exeupgradescadatohistoricalhistoricalbuffer will convert the SCADA buffer and name the new data store. 5. Start the Data Archiver. If the conversion was successful, you can start your Data Archiver as long as you have enough Historical tags. If there are any errors you can view them from the Data Archiverlogfile. For More information, refer Knowledge Base Articles on the GE Intelligent Platforms support site: Command Line support for Alarm Migration Tool If you are using Alarm Migration Tool using command line you can use the following switches.

22 Command Line Switches (Case does not matter): REQUIRED SWITCHES: /TASK = Command to be executed (for example BACKUP 0r RESTORE) /SERVER = SQL Server Name (for example usgb021) /DBNAME = Database Name (for example AEDatabase) /SDATETIME = mm/dd/yyyy HH:MM:ss format (for example '5/21/ :20:30'). Alarms & Events recorded from this time will be considered. This option is mandatory only when used with BACKUP command. /EDATETIME = mm/dd/yyyy HH:MM:ss format (for example '5/25/ :20:30'). Alarms & Events recorded till this time will be considered. This option is mandatory only when used with BACKUP command. /BKPPATH = Fully qualified path of the.dat file where the backup of the Database will be taken.this switch is mandatory only when used with BACKUP command. /RSTPATH = Fully qualified path of the.dat file from where the Database will be restored.this switch is mandatory only when used with RESTORE command. /USERNAME = User Name (for example sa) used to connect to SQL Server using SQL Authentication. If this switch is not provided then Windows Authentication is used to connect to SQL Server. OPTIONAL SWITCHES: /PWD = Password (for example Pr0f1cyhist) Default is empty string (no password is okay, but not recommended for security reasons). If you want the password to be blank, simply skip using this switch. EXAMPLES: BACKUP Operation using SQL Authentication: Proficy.Historian.AandE.Migration.exe /TASK=Backup /SERVER=CPHIST45PROFICYHIST /DBNAME=CPHIST45_plantdatabase /SDateTime='3/9/ :00:00' /EDateTime='3/9/ :59:59' /BKPPATH=C:tempPDB_0309.dat /USERNAME=sa /PWD=Pr0f1cyhist BACKUP Operation using Windows Authentication: Proficy.Historian.AandE.Migration.exe /TASK=Backup /SERVER=DomainNode /DBNAME=AEDB /SDateTime='5/10/ :20:30' /EDateTime='6/10/ :20:30' /BKPPATH=E:DBBkpPathAEDB_1.dat RESTORE Operation using SQL Authentication: Proficy.Historian.AandE.Migration.exe /TASK=Restore

23 /SERVER=CPHIST45PROFICYHIST /DBNAME=CPHIST45_AEDatabase /RSTPATH=C:tempPDB_0309.dat /USERNAME=sa /PWD=Pr0f1cyhist RESTORE Operation using Windows Authentication: Proficy.Historian.AandE.Migration.exe /TASK=RESTORE /SERVER=DomainNode /DBNAME=AEDB /RSTPATH=E:DBBkpPathAEDB_1.dat Multiple Backups Using a Batch File: cd C:Program FilesProficyProficy DataBase start /b /wait Proficy.Historian.AandE.Migration.exe /TASK=Backup /SERVER=CPHIST45PROFICYHIST /DBNAME=CPHIST45_plantdatabase /SDateTime='3/9/ :00:00' /EDateTime='3/9/ :59:59' /BKPPATH=C:tempPDB_0309.dat /USERNAME=sa /PWD=Pr0f1cyhist start /b /wait Proficy.Historian.AandE.Migration.exe /TASK=Backup /SERVER=CPHIST45PROFICYHIST /DBNAME=CPHIST45_plantdatabase /SDateTime='3/10/ :00:00' /EDateTime='3/10/ :00:00' /BKPPATH=C:tempPDB_0310_1.dat /USERNAME=sa /PWD=Pr0f1cyhist start /b /wait Proficy.Historian.AandE.Migration.exe /TASK=Backup /SERVER=CPHIST45PROFICYHIST /DBNAME=CPHIST45_plantdatabase /SDateTime='3/10/ :00:00' /EDateTime='3/10/ :00:00' /BKPPATH=C:tempPDB_0310_2.dat /USERNAME=sa /PWD=Pr0f1cyhist Multiple Restores Using a Batch File cd C:Program FilesProficyProficy DataBase start /b /wait Proficy.Historian.AandE.Migration.exe /TASK=Restore /SERVER=CPHIST45PROFICYHIST /DBNAME=CPHIST45_AEDatabase /RSTPATH=C:tempPDB_0309.dat /USERNAME=sa /PWD=Pr0f1cyhist start /b /wait Proficy.Historian.AandE.Migration.exe /TASK=Restore /SERVER=CPHIST45PROFICYHIST /DBNAME=CPHIST45_AEDatabase /RSTPATH=C:tempPDB_0310_1.dat /USERNAME=sa /PWD=Pr0f1cyhist start /b /wait Proficy.Historian.AandE.Migration.exe /TASK=Restore /SERVER=CPHIST45PROFICYHIST /DBNAME=CPHIST45_AEDatabase /RSTPATH=C:tempPDB_0310_2.dat /USERNAME=sa /PWD=Pr0f1cyhist NOTE: Parameter values with spaces should be enclosed within quotation marks ('). For Example: /BKPPATH='C:Proficy Historian DataAEDB_Bkp.dat'.

24 Using Arrays and MultiField tag elements in Calculation, Server to Server Collectors. Using Arrays in the Calculation and Server to Server collectors In Proficy Historian 5.5 you can create tags of Array data type. You can use the array tags with the Calculation Collector or Servre to Server collector as a source of information. You can forward the entire array to the latest version of the Proficy Historian server using the Server to Server collector or distributor like you do for a regular tag. If you are using a Pre 5.5 Data Archiver then, you can only send an individual array element. For example: result = currentvalue('array1[4]') You cannot make calculation tags of array data type, but you can use data from array tags inside your calculations. For example: result = currentvalue('array1[4]')+5 Using Multi field Tags in the Calculation and Server to Server collectors In Proficy Historian 5.5 you can create tags of User Defined data types. You can use these tags with the Calculation Collector or Servre to Server collector as a source of information. You cannot make Server to Server tags of a User Defined data type. The Server to Server collector will not be able to write to them. However, you can use the fields of a multifield tag in your calculation formula. For example: result = currentvalue('tag1.intval')+5 If you want use a MultiField tag as a trigger tag you can use either the tag name 'Tag1' or tag name with the field 'Tag1.IntVal'. When you are sending a multifield tag data to a destination Historian Server using Server to Server collector, the tag will be converted into multiple tags at the destination. Even if you are using the latest Historian version, a tag with 2 fields will become 2 tags on the destination server and will not be a User Defined type. These tags will have the data type of the field. For example: If you have one tag 'Tag1' with two fields 'FloatVal' and 'IntVal' on a source archiver, the Server to Server collector will create 2 tags 'Tag1.FloatVal' and 'Tag1.IntVal' on the destination. Historian Archive Ingestion Service. This service, created as manual start, is reserved for use with the Proficy Historian HD big data analytics platform. Having this service stopped does not impact the functioning of Proficy Historian. For more information regarding Proficy Historian HD, please visit:

25 Proficy Historian 5.5 System Requirements Hardware Requirements For Historian Servers, the minimum hardware requirements are: A 2.4 GHz clock speed Intel Core i3 or i5 or i7 CPU or equivalent AMD Phenom CPU with 4 GB RAM for a 32-bit Historian Server and 4 GB RAM for a 64-bit Historian Server. A DVD-ROM drive. 100 Mbps TCP/IP-compatible network interface adapter for network communication and certain I/O drivers. 80 GB free hard drive space for the data archives, message files, buffer files, and log files used by the system. For Data Collector nodes, the recommended minimum hardware requirements are: A 2.0 GHz clock speed Intel Core i3 or i5 or i7 CPU or equivalent AMD Phenom CPU with 2 GB RAM. 40 GB of free hard drive space to store buffered data. A DVD-ROM drive. TCP/IP-compatible network interface adapter for network communication and certain I/O drivers. For the Microsoft Cluster service, the minimum hardware requirements are: A 2.6 GHz clock speed Intel Core i3 or i5 or i7 or Xeon or equivalent AMD Opteron CPU with minimum 8 GB RAM. 80 GB of local free hard drive space. 40 GB shared SCSI hard drive (RAID preferred). Two 100Mbit TCP/IP-compatible network interface adapters for network communication and certain I/O drivers (One for public network, another for private network). NOTE: The configuration of each server added to the cluster must be identical to the other servers in the cluster. Guidelines for Determining Historian Server Size You determine the size of an Historian Server as a function of the number of tags from which data is collected, the rate of alarm and event collection, and how often you intend to collect the data and how much data you want to keep online. The number of tags is an indicator of the number of concurrent users likely to access the system. The primary factor is server memory requirements; CPU load is a secondary factor. If the number of concurrent users is significantly different from the suggested guidelines, adjust server memory size accordingly. Use the following parameters to determine the size of the Historian Server.

TANDBERG MANAGEMENT SUITE 10.0

TANDBERG MANAGEMENT SUITE 10.0 Installation Manual Getting Started D12786 Rev.16 This document is not to be reproduced in whole or in part without permission in writing from: Contents INTRODUCTION 3 REQUIREMENTS

More information

Proficy * Change Management for Proficy * Machine Edition

Proficy * Change Management for Proficy * Machine Edition GETTING STARTED Version 7.00 June 2011 All rights reserved. No part of this publication may be reproduced in any form or by any electronic or mechanical

More information

WhatsUp Gold v16.2 Installation and Configuration Guide

WhatsUp Gold v16.2 Installation and Configuration Guide Contents Installing and Configuring Ipswitch WhatsUp Gold v16.2 using WhatsUp Setup Installing WhatsUp Gold using WhatsUp Setup.. 1 Security guidelines

More information

ProficyTM Historian A DMINISTRATOR S GUIDE. Version 3.1 Jan. 2006

Manual

ProficyTM Historian A DMINISTRATOR S GUIDE Version 3.1 Jan. 2006 All rights reserved. No part of this publication may be reproduced in any form or by any electronic or mechanical means, including photocopying

More information

VERITAS Backup Exec 9.1 for Windows Servers Quick Installation Guide

VERITAS Backup Exec 9.1 for Windows Servers Quick Installation Guide N109548 Disclaimer The information contained in this publication is subject to change without notice. VERITAS Software Corporation makes

More information

Sage Intelligence Financial Reporting for Sage ERP X3 Version 6.5 Installation Guide

Sage Intelligence Financial Reporting for Sage ERP X3 Version 6.5 Installation Guide Table of Contents TABLE OF CONTENTS.. 3 1.0 INTRODUCTION.. 1 1.1 HOW TO USE THIS GUIDE.. 1 1.2 TOPIC SUMMARY..

More information

Migrating MSDE to Microsoft SQL 2008 R2 Express

How To Updated: 11/11/2011 2011 Shelby Systems, Inc. All Rights Reserved Other brand and product names are trademarks or registered trademarks of the respective holders. If you are still on MSDE 2000,

More information

WhatsUp Gold v16.1 Installation and Configuration Guide

WhatsUp Gold v16.1 Installation and Configuration Guide Contents Installing and Configuring Ipswitch WhatsUp Gold v16.1 using WhatsUp Setup Installing WhatsUp Gold using WhatsUp Setup.. 1 Security guidelines

More information

Diamond II v2.3 Service Pack 4 Installation Manual

Diamond II v2.3 Service Pack 4 Installation Manual P/N 460987001B ISS 26APR11 Copyright Disclaimer Trademarks and patents Intended use Software license agreement FCC compliance Certification and compliance

More information

Installation Instructions Release Version 15.0 January 30 th, 2011

Release Version 15.0 January 30 th, 2011 ARGUS Software: ARGUS Valuation - DCF The contents of this document are considered proprietary by ARGUS Software, the information enclosed and any portion thereof

More information

VERITAS Backup Exec TM 10.0 for Windows Servers

VERITAS Backup Exec TM 10.0 for Windows Servers Quick Installation Guide N134418 July 2004 Disclaimer The information contained in this publication is subject to change without notice. VERITAS Software

More information

HYPERION SYSTEM 9 N-TIER INSTALLATION GUIDE MASTER DATA MANAGEMENT RELEASE 9.2

HYPERION SYSTEM 9 MASTER DATA MANAGEMENT RELEASE 9.2 N-TIER INSTALLATION GUIDE P/N: DM90192000 Copyright 2005-2006 Hyperion Solutions Corporation. All rights reserved. Hyperion, the Hyperion logo, and

More information

ProficyTM. HMI/SCADA - ifix I MPLEMENTING S ECURITY

ProficyTM HMI/SCADA - ifix I MPLEMENTING S ECURITY Version 4.0 December 2005 All rights reserved. No part of this publication may be reproduced in any form or by any electronic or mechanical means, including

More information

INSTALLATION GUIDE. AXIS Camera Station

INSTALLATION GUIDE AXIS Camera Station About this Guide This guide is intended for administrators and users of the AXIS Camera Station, and is applicable for software release 3.50 and later. It covers

More information

INSTALL AND CONFIGURATION GUIDE. Atlas 5.1 for Microsoft Dynamics AX

INSTALL AND CONFIGURATION GUIDE Atlas 5.1 for Microsoft Dynamics AX COPYRIGHT NOTICE Copyright 2012, Globe Software Pty Ltd, All rights reserved. Trademarks Dynamics AX, IntelliMorph, and X++ have been

More information

Interworks. Interworks Cloud Platform Installation Guide

Interworks Interworks Cloud Platform Installation Guide Published: March, 2014 This document contains information proprietary to Interworks and its receipt or possession does not convey any rights to reproduce,

More information

Ekran System Help File

Ekran System Help File Table of Contents About.. 9 What s New.. 10 System Requirements.. 11 Updating Ekran to version 4.1.. 13 Program Structure.. 14 Getting Started.. 15 Deployment Process.. 15

More information

Symantec Backup Exec TM 11d for Windows Servers. Quick Installation Guide

Symantec Backup Exec TM 11d for Windows Servers Quick Installation Guide September 2006 Symantec Legal Notice Copyright 2006 Symantec Corporation. All rights reserved. Symantec, Backup Exec, and the Symantec

More information

7.x Upgrade Instructions. 2015 Software Pursuits, Inc.

7.x Upgrade Instructions 2015 Table of Contents INTRODUCTION..2 SYSTEM REQUIREMENTS FOR SURESYNC 7..2 CONSIDERATIONS BEFORE UPGRADING..3 TERMINOLOGY CHANGES.. 4 Relation Renamed to Job.. 4 SPIAgent

More information

Quick Start Guide for VMware and Windows 7

PROPALMS VDI Version 2.1 Quick Start Guide for VMware and Windows 7 Rev. 1.1 Published: JULY-2011 1999-2011 Propalms Ltd. All rights reserved. The information contained in this document represents the

More information

Table of Contents. Introduction..9. Installation..17. Program Tour..31. The Program Components..10 Main Program Features..11

2011 AdRem Software, Inc. This document is written by AdRem Software and represents the views and opinions of AdRem Software regarding its content, as of the date the document was issued. The information

More information

User Manual. Onsight Management Suite Version 5.1. Another Innovation by Librestream

User Manual Onsight Management Suite Version 5.1 Another Innovation by Librestream Doc #: 400075-06 May 2012 Information in this document is subject to change without notice. Reproduction in any manner

More information

Metalogix SharePoint Backup. Advanced Installation Guide. Publication Date: August 24, 2015

Metalogix SharePoint Backup Publication Date: August 24, 2015 All Rights Reserved. This software is protected by copyright law and international treaties. Unauthorized reproduction or distribution of this

More information

ChangeAuditor. Migration Guide CA-MG-0808-470

ChangeAuditor Migration Guide CA-MG-0808-470 Copyright 2008 NetPro Computing, Inc. Disclaimer NetPro Computing, Inc. (NetPro) makes no representations or warranties, either expressed or implied, with

More information

Legal Notes. Regarding Trademarks. 2013 KYOCERA Document Solutions Inc.

Legal Notes Unauthorized reproduction of all or part of this guide is prohibited. The information in this guide is subject to change without notice. We cannot be held liable for any problems arising from

More information

WhatsUp Gold v16.1 Database Migration and Management Guide Learn how to migrate a WhatsUp Gold database from Microsoft SQL Server 2008 R2 Express

WhatsUp Gold v16.1 Database Migration and Management Guide Learn how to migrate a WhatsUp Gold database from Microsoft SQL Server 2008 R2 Express Edition to Microsoft SQL Server 2005, 2008, or 2008 R2

More information

Dell InTrust 11.0. Preparing for Auditing Microsoft SQL Server

2014 Dell Inc. ALL RIGHTS RESERVED. This guide contains proprietary information protected by copyright. The software described in this guide is furnished under a software license or nondisclosure agreement.

More information

Migrating TimeForce To A New Server

Rev. 4/28/14 Migrating TimeForce To A New Server Table of Contents 1. Installation Prerequisites.. 2 Required.. 2 Recommended.. 3 2. Update to a Migration Compatible Version.. 3 Determine the Database

More information

Getting Started with Vision 6

Getting Started with Vision 6 Version 6.9 Notice Copyright 1981-2009 Netop Business Solutions A/S. All Rights Reserved. Portions used under license from third parties. Please send any comments to: Netop

More information

WhatsUp Gold v16.2 Database Migration and Management Guide

WhatsUp Gold v16.2 Database Migration and Management Guide Contents CHAPTER 1 How to use this guide CHAPTER 2 Migrating the WhatsUp Gold Microsoft SQL Server 2008 R2 Express Edition database to Microsoft

More information

Installation Notes for Outpost Network Security (ONS) version 3.2

Outpost Network Security Installation Notes version 3.2 Page 1 Installation Notes for Outpost Network Security (ONS) version 3.2 Contents Installation Notes for Outpost Network Security (ONS) version 3.2..

More information

PHD Virtual Backup for Hyper-V

Ge Proficy Historian User Manual

PHD Virtual Backup for Hyper-V version 7.0 Installation & Getting Started Guide Document Release Date: December 18, 2013 www.phdvirtual.com PHDVB v7 for Hyper-V Legal Notices PHD Virtual Backup for Hyper-V

More information

Digipass Plug-In for IAS. IAS Plug-In IAS. Microsoft's Internet Authentication Service. Installation Guide

Digipass Plug-In for IAS IAS Plug-In IAS Microsoft's Internet Authentication Service Installation Guide Disclaimer of Warranties and Limitations of Liabilities Disclaimer of Warranties and Limitations

More information

Installation and Deployment

Installation and Deployment Help Documentation This document was auto-created from web content and is subject to change at any time. Copyright (c) 2016 SmarterTools Inc. Installation and Deployment SmarterStats

More information

Veritas Cluster Server Database Agent for Microsoft SQL Configuration Guide

Veritas Cluster Server Database Agent for Microsoft SQL Configuration Guide Windows 2000, Windows Server 2003 5.0 11293743 Veritas Cluster Server Database Agent for Microsoft SQL Configuration Guide Copyright

More information

Desktop Surveillance Help

Desktop Surveillance Help Table of Contents About.. 9 What s New.. 10 System Requirements.. 11 Updating from Desktop Surveillance 2.6 to Desktop Surveillance 3.2.. 13 Program Structure.. 14 Getting

More information

Historian SQL Server 2012 Installation Guide

Historian SQL Server 2012 EIO0000001701 04-10-2013 Historian SQL Server 2012 Installation Guide 04-10-2013 EIO0000001701.00 www.schneider-electric.com The information provided in this documentation contains

More information

Reporting for Contact Center Setup and Operations Guide. BCM Contact Center

Reporting for Contact Center Setup and Operations Guide BCM Contact Center Document Number: NN40040-302 Document Status: Standard Document Version: 04.00 Part Code: N0060637 Date: June 2006 Copyright 2005

More information

formerly Help Desk Authority 9.1.3 Upgrade Guide

formerly Help Desk Authority 9.1.3 Upgrade Guide 2 Contacting Quest Software Email: Mail: Web site: info@quest.com Quest Software, Inc. World Headquarters 5 Polaris Way Aliso Viejo, CA 92656 USA www.quest.com

More information

Telelogic DASHBOARD Installation Guide Release 3.6

Telelogic DASHBOARD Installation Guide Release 3.6 1 This edition applies to 3.6.0, Telelogic Dashboard and to all subsequent releases and modifications until otherwise indicated in new editions. Copyright

More information

Table of Contents. CHAPTER 1 About This Guide.. 9. CHAPTER 2 Introduction.. 11. CHAPTER 3 Database Backup and Restoration.. 15

Table of Contents CHAPTER 1 About This Guide............. 9 The Installation Guides.................... 10 CHAPTER 2 Introduction.............. 11 Required

More information

InventoryControl for use with QuoteWerks Quick Start Guide

InventoryControl for use with QuoteWerks Quick Start Guide Copyright 2013 Wasp Barcode Technologies 1400 10 th St. Plano, TX 75074 All Rights Reserved STATEMENTS IN THIS DOCUMENT REGARDING THIRD PARTY

More information

Quick Start Guide for Parallels Virtuozzo

PROPALMS VDI Version 2.1 Quick Start Guide for Parallels Virtuozzo Rev. 1.1 Published: JULY-2011 1999-2011 Propalms Ltd. All rights reserved. The information contained in this document represents the current

More information

About Recovery Manager for Active

Dell Recovery Manager for Active Directory 8.6.1 May 30, 2014 These release notes provide information about the Dell Recovery Manager for Active Directory release. About Resolved issues Known issues System

More information

Installing and Configuring WhatsUp Gold

Installing and Configuring WhatsUp Gold This guide provides information about installing and configuring WhatsUp Gold v14.2, including instructions on how to run the WhatsUp web interface through an Internet

More information

Topaz Installation Sheet

Topaz Installation Sheet P/N 460924001E ISS 08FEB12 Content Introduction.. 3 Recommended minimum requirements.. 3 Setup for Internet Explorer:.. 4 Topaz installation.. 10 Technical support.. 14 Copyright

More information

Quick Install Guide. Lumension Endpoint Management and Security Suite 7.1

Quick Install Guide Lumension Endpoint Management and Security Suite 7.1 Lumension Endpoint Management and Security Suite - 2 - Notices Version Information Lumension Endpoint Management and Security Suite

More information

GUARD1 PLUS SE Administrator's Manual

GUARD1 PLUS SE Administrator's Manual Version 4.4 30700 Bainbridge Road Solon, Ohio 44139 Phone 216-595-0890 Fax 216-595-0991 info@guard1.com www.guard1.com i 2010 TimeKeeping Systems, Inc. GUARD1 PLUS

More information

Nexio Connectus with Nexio G-Scribe

Nexio Connectus with Nexio G-Scribe 2.1.2 3/20/2014 Edition: A 2.1.2 Publication Information 2014 Imagine Communications. Proprietary and Confidential. Imagine Communications considers this document and

More information

Imaging Computing Server User Guide

Imaging Computing Server User Guide PerkinElmer, Viscount Centre II, University of Warwick Science Park, Millburn Hill Road, Coventry, CV4 7HS T +44 (0) 24 7669 2229 F +44 (0) 24 7669 0091 E cellularimaging@perkinelmer.com

More information

3 Setting up Databases on a Microsoft SQL 7.0 Server

3 Setting up Databases on a Microsoft SQL 7.0 Server Overview of the Installation Process To set up GoldMine properly, you must follow a sequence of steps to install GoldMine s program files, and the other

More information

Symantec AntiVirus Corporate Edition Patch Update

Symantec AntiVirus Corporate Edition Patch Update Symantec AntiVirus Corporate Edition Update Documentation version 10.0.1.1007 Copyright 2005 Symantec Corporation. All rights reserved. Symantec, the Symantec

More information

Portions of this product were created using LEADTOOLS 1991-2009 LEAD Technologies, Inc. ALL RIGHTS RESERVED.

Installation Guide Lenel OnGuard 2009 Installation Guide, product version 6.3. This guide is item number DOC-110, revision 1.038, May 2009 Copyright 1992-2009 Lenel Systems International, Inc. Information

More information

Bosch ReadykeyPRO Unlimited Installation Guide, product version 6.5. This guide is item number DOC-110-2-029, revision 2.029, May 2012.

Bosch ReadykeyPRO Unlimited Installation Guide, product version 6.5. This guide is item number DOC-110-2-029, revision 2.029, May 2012. Copyright 1995-2012 Lenel Systems International, Inc. Information

More information

WhatsUp Gold v16.3 Installation and Configuration Guide

WhatsUp Gold v16.3 Installation and Configuration Guide Contents Installing and Configuring WhatsUp Gold using WhatsUp Setup Installation Overview.. 1 Overview.. 1 Security considerations.. 2 Standard

More information

Quest ChangeAuditor 4.8

Quest ChangeAuditor 4.8 Migration Guide Copyright Quest Software, Inc. 2009. All rights reserved. This guide contains proprietary information protected by copyright. The software described in this guide

More information

Allworx OfficeSafe Operations Guide Release 6.0

Allworx OfficeSafe Operations Guide Release 6.0 No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechanical, photocopy,

More information

DataLogger. 2015 Kepware, Inc.

2015 Kepware, Inc. 2 DataLogger Table of Contents Table of Contents 2 DataLogger Help 4 Overview 4 Initial Setup Considerations 5 System Requirements 5 External Dependencies 5 SQL Authentication 6 Windows

More information

Omtool Server Monitor administrator guide

Apc ups serial number lookup warranty. Omtool Server Monitor administrator guide May 29, 2008 (4.0342-AA) Omtool, Ltd. 6 Riverside Drive Andover, MA 01810 Phone: +1/1 978 327 5700 Toll-free in the US: +1/1 800 886 7845 Fax: +1/1 978 659 1300

More information

Getting Started with ESXi Embedded

ESXi 4.1 Embedded vcenter Server 4.1 This document supports the version of each product listed and supports all subsequent versions until the document is replaced by a new edition. To check for more recent

More information

@ptitude Observer. Installation Manual. Part No. 32170700 Revision G

Part No. 32170700 Revision G Installation Manual Copyright 2012 by SKF Reliability Systems All rights reserved. Aurorum 30, 977 75 Lulea Sweden Telephone: +46 (0) 31 337 10 00, Fax: +46 (0) 920 134 40

More information

ArcGIS 9. Installation Guide: Workgroup for Microsoft SQL Server Express

ArcGIS 9 Installation Guide: Workgroup for Microsoft SQL Server Express Copyright 2006 ESRI All Rights Reserved. Printed in the United States of America. The information contained in this document is the

More information

Spector 360 Deployment Guide. Version 7.3 January 3, 2012

Spector 360 Deployment Guide Version 7.3 January 3, 2012 Table of Contents Deploy to All Computers.. 48 Step 1: Deploy the Servers.. 5 Recorder Requirements.. 52 Requirements.. 5 Control Center Server

More information

Sophos Enterprise Console server to server migration guide. Product version: 5.1 Document date: June 2012

Sophos Enterprise Console server to server migration guide Product : 5.1 Document date: June 2012 Contents 1 About this guide..3 2 Terminology..4 3 Assumptions..5 4 Prerequisite..6 5 What are the key

More information

Database Administration Guide

Database Administration Guide 013008 2008 Blackbaud, Inc. This publication, or any part thereof, may not be reproduced or transmitted in any form or by any means, electronic, or mechanical, including photocopying,

More information

Backup Assistant. User Guide. NEC NEC Unified Solutions, Inc. March 2008 NDA-30282, Revision 6

Backup Assistant User Guide NEC NEC Unified Solutions, Inc. March 2008 NDA-30282, Revision 6 Liability Disclaimer NEC Unified Solutions, Inc. reserves the right to change the specifications, functions,

More information

2014 Electrical Server Installation Guide

2014 Electrical Server Installation Guide TITLE: 2014 Electrical Server Installation Guide DATE: September 2013 SUBJECT: ABSTRACT: Installation guide for SolidWorks Electrical 2014 on the server Guide

More information

Remote Management System

RMS Copyright and Distribution Notice November 2009 Copyright 2009 ARTROMICK International, Inc. ALL RIGHTS RESERVED. Published 2009. Printed in the United States of America WARNING: ANY UNAUTHORIZED

More information

SC-T35/SC-T45/SC-T46/SC-T47 ViewSonic Device Manager User Guide

SC-T35/SC-T45/SC-T46/SC-T47 ViewSonic Device Manager User Guide Copyright and Trademark Statements 2014 ViewSonic Computer Corp. All rights reserved. This document contains proprietary information that

More information

User Guide - Exchange Database idataagent

Page 1 of 208 User Guide - Exchange Database idataagent TABLE OF CONTENTS OVERVIEW Introduction Key Features Add-On Components Customized Features for Your Exchange Version Terminology SYSTEM REQUIREMENTS

More information

Portions of this product were created using LEADTOOLS 1991-2010 LEAD Technologies, Inc. ALL RIGHTS RESERVED.

Installation Guide Lenel OnGuard 2010 Installation Guide, product version 6.4. This guide is item number DOC-110, revision 1.045, May 2010 Copyright 1995-2010 Lenel Systems International, Inc. Information

More information

CA Nimsoft Monitor Snap

CA Nimsoft Monitor Snap Configuration Guide for IIS Server Monitoring iis v1.5 series Legal Notices This online help system (the 'System') is for your informational purposes only and is subject to change

More information

Installation Guide: Delta Module Manager Launcher

Installation Guide: Delta Module Manager Launcher Overview.. 2 Delta Module Manager Launcher.. 2 Pre-Installation Considerations.. 3 Hardware Requirements.. 3 Software Requirements.. 3 Virtualisation..

More information

HP MediaSmart Server Software Upgrade from v.1 to v.3

HP MediaSmart Server Software Upgrade from v.1 to v.3 Table of Contents Upgrade Your Server Software to HP MediaSmart Server v.3 2 Before You Begin 3 What's New.. 3 Features That Will Change.. 4 Prepare

More information

NetWrix USB Blocker. Version 3.6 Administrator Guide

NetWrix USB Blocker Version 3.6 Administrator Guide Table of Contents 1. Introduction..3 1.1. What is NetWrix USB Blocker?..3 1.2. Product Architecture..3 2. Licensing..4 3. Operation Guide..5 3.1.

More information

Dell Statistica 13.0. Statistica Enterprise Installation Instructions

Dell Statistica 13.0 2015 Dell Inc. ALL RIGHTS RESERVED. This guide contains proprietary information protected by copyright. The software described in this guide is furnished under a software license or

More information

STIDistrict Server Replacement

STIDistrict Server Replacement Major Steps Defined This document addresses how to migrate data and applications from an existing STIDistrict (SQL) Server to a new machine. There will be 8 major steps:

More information

AXIS Camera Station Quick Installation Guide

AXIS Camera Station Quick Installation Guide Copyright Axis Communications AB April 2005 Rev. 3.5 Part Number 23997 1 Table of Contents Regulatory Information................. 3 AXIS Camera

More information

UNICORN 7.0. Administration and Technical Manual

UNICORN 7.0 Administration and Technical Manual Page intentionally left blank Table of Contents Table of Contents 1 Introduction.. 1.1 Administrator functions overview.. 1.2 Network terms and concepts..

More information

RedundancyMaster Help. 2014 Kepware Technologies

2014 Kepware Technologies 2 RedundancyMaster Help Table of Contents Table of Contents 2 Introduction 4 System Requirements 10 Accessing the Administration Menu 11 Setting Up Redundancy 11 Adding Redundancy

More information

Universal Management Service 2015

Universal Management Service 2015 UMS 2015 Help All rights reserved. No parts of this work may be reproduced in any form or by any means - graphic, electronic, or mechanical, including photocopying, recording,

More information

Quick Start - NetApp File Archiver

Page 1 of 19 Quick Start - NetApp File Archiver TABLE OF CONTENTS OVERVIEW Introduction Key Features Terminology SYSTEM REQUIREMENTS DEPLOYMENT Installation Method 1: Interactive Install Method 2: Install

More information

Managing Multi-Hypervisor Environments with vcenter Server

Managing Multi-Hypervisor Environments with vcenter Server vcenter Server 5.1 vcenter Multi-Hypervisor Manager 1.0 This document supports the version of each product listed and supports all subsequent

More information

Installation Guide. Version 1.5. May 2015 Edition 2002-2015 ICS Learning Group

Installation Guide Version 1.5 May 2015 Edition 2002-2015 ICS Learning Group 1 Disclaimer ICS Learning Group makes no representations or warranties with respect to the contents or use of this manual, and

More information

VEEAM ONE 8 RELEASE NOTES

VEEAM ONE 8 RELEASE NOTES This Release Notes document provides last-minute information about Veeam ONE 8 Update 2, including system requirements, installation instructions as well as relevant information

More information

Upgrade to Webtrends Analytics 8.7: Best Practices

Technical Best Practices 8.7 Software Upgrade Upgrade to Webtrends Analytics 8.7: Best Practices Version 3 Webtrends Analytics is a powerful application that must be installed on a dedicated computer.

More information

Matisse Installation Guide for MS Windows

Matisse Installation Guide for MS Windows July 2013 Matisse Installation Guide for MS Windows Copyright 2013 Matisse Software Inc. All Rights Reserved. This manual and the software described in it are

More information

NTP Software File Auditor for Windows Edition

NTP Software File Auditor for Windows Edition An NTP Software Installation Guide Abstract This guide provides a short introduction to installation and initial configuration of NTP Software File Auditor

More information

Install SQL Server 2014 Express Edition

How To Install SQL Server 2014 Express Edition Updated: 2/4/2016 2016 Shelby Systems, Inc. All Rights Reserved Other brand and product names are trademarks or registered trademarks of the respective holders.

More information

Sage Estimating. (formerly Sage Timberline Estimating) SQL Server Guide

Sage Estimating (formerly Sage Timberline Estimating) SQL Server Guide This is a publication of Sage Software, Inc. Document Number 20001S150301112ER 10/2012 2012 Sage Software, Inc. All rights reserved.

More information

Exclaimer Mail Archiver

Deployment Guide - Outlook Add-In www.exclaimer.com Contents About This Guide.. 3 System Requirements.. 4 Software.. 4 Installation Files.. 5 Deployment Preparation.. 6 Installing the Add-In Manually..

More information

Hillstone StoneOS User Manual Hillstone Unified Intelligence Firewall Installation Manual

Hillstone StoneOS User Manual Hillstone Unified Intelligence Firewall Installation Manual www.hillstonenet.com Preface Conventions Content This document follows the conventions below: CLI Tip: provides

More information

Integrated Virtual Debugger for Visual Studio Developer s Guide VMware Workstation 8.0

Integrated Virtual Debugger for Visual Studio Developer s Guide VMware Workstation 8.0 This document supports the version of each product listed and supports all subsequent versions until the document

More information

Sharp Remote Device Manager (SRDM) Server Software Setup Guide

Sharp Remote Device Manager (SRDM) Server Software Setup Guide This Guide explains how to install the software which is required in order to use Sharp Remote Device Manager (SRDM). SRDM is a web-based

More information

ThinPoint Quick Start Guide

ThinPoint Quick Start Guide 2 ThinPoint Quick Start Guide Table of Contents Part 1 Introduction 3 Part 2 ThinPoint Windows Host Installation 3 1 Compatibility.. list 3 2 Pre-requisites.. 3 3 Installation..

More information

FAS Asset Accounting FAS CIP Accounting FAS Asset Inventory SQL Server Installation & Administration Guide Version 2011.1

FAS Asset Accounting FAS CIP Accounting FAS Asset Inventory SQL Server Installation & Administration Guide Version 2011.1 2011 Sage Software, Inc. All rights reserved. Published by Sage 2325 Dulles Corner

More information

Guide to Installing BBL Crystal MIND on Windows 7

Guide to Installing BBL Crystal MIND on Windows 7 Introduction The BBL Crystal MIND software can not be directly installed on the Microsoft Windows 7 platform, however it can be installed and run via XP

More information

Pcounter Web Report 3.x Installation Guide - v2014-11-30. Pcounter Web Report Installation Guide Version 3.4

Pcounter Web Report 3.x Installation Guide - v2014-11-30 Pcounter Web Report Installation Guide Version 3.4 Table of Contents Table of Contents.. 2 Installation Overview.. 3 Installation Prerequisites

More information

NETWRIX WINDOWS SERVER CHANGE REPORTER

NETWRIX WINDOWS SERVER CHANGE REPORTER INSTALLATION AND CONFIGURATION GUIDE Product Version: 4.0 March 2013. Legal Notice The information in this publication is furnished for information use only, and

More information

Quick Start - Virtual Server idataagent (VMware)

Page 1 of 24 Quick Start - Virtual Server idataagent (VMware) TABLE OF CONTENTS OVERVIEW Introduction Key Features Complete Virtual Machine Protection Granular Recovery of Virtual Machine Data Minimal

More information

How can I retrieve raw time-series data from a Proficy Historian/iHistorian?

Ideally, I would ask for data for a particular tag between two dates.

Michael HarenMichael Haren

4 Answers

There are several different sampling modes you can experiment with.

  • Raw
  • Interpolated
  • Lab
  • Trend
  • Calculated

These modes are available using all of the following APIs.

Ge Proficy Historian Latest Version

  • User API (ihuapi.dll)
  • SDK (ihsdk.dll)
  • OLEDB (iholedb.dll)
  • Client Acess API (Proficy.Historian.ClientAccess.API)

Of these the trend sampling mode is probably what you want since it is specifically designed for charting/trending. Though, lab and interpolated may be useful as well.

Read the electronic book for more information on each sampling mode. On my machine it is stored as C:Program FilesGE FanucProficy HistorianDocsiHistorian.chm and I have version 3.5 installed. Pay particular attention to the following sections.

  • Using the Historian OLE DB Provider
  • Advanced Topics Retrieval

Here is how you can construct an OLEDB to do trend sampling.

Showing the equivalent methods using the User API and the SDK are complex (more so with the User API) since they require a lot of plumbing in the code to get setup. The Client Access API is newer and uses WCF behind the scenes.

By the way, there are a few limitations with the OLEDB method though.

  • Despite what the documentation says I have never been able to get native query parameters to work. That is a showstopper if you want to use it with SQL Server Reporting Services for example.
  • You cannot write samples into the archive or in any way make changes to the Historian configuration including adding/changing tags, writing messages, etc.
  • It can be a little slow in some cases.
  • It has no provision for crosstabbing multiple tagnames into the columns and then carrying forward samples so that a value exists for each timestamp and tag combination. The trend sampling mode gets you halfway there, but still does not crosstab and does not actually load raw samples. Then again the User API and SDK cannot do this either.
Brian GideonBrian Gideon

Ge Proficy Historian Training

A coworker of mine put this together:

In web.config:

In the data layer:

Update:

This worked well but we ran into an issue with tags that don't update very often. If the tag didn't update near the start or end of the requested startDate and endDate, the trends would look bad. Worse, still were cases where there were no explicit points during the window requested--we'd get no data back.

I resolved this by making three queries:

  1. The previous value before the start-date
  2. The points between startDate and endDate
  3. The next value after the endDate

This is a potentially inefficient way to do it but It Works:

And yes, I know, those queries should be parameterized.

Michael HarenMichael Haren

Michael--in IP21 there is an 'Interpolated' table, as well as the 'actual' data point table. Does Proficy have that as well?

reallyJimreallyJim

We wrote a wrapper DLL that looked like this like this:

Some notes are that iFIX will check if the DLL is loaded on startup so you need to do things like dynamically load/unload the DLL so that other applications don't crash. We did this by deleting/adding registry keys on the fly.

Another one is if you poll 10,000 samples and 1 of the samples are corrupted it will drop all 10,000 samples. You need to implement a bad data handler that will start at either side of the bad data and increment in steps to get all data either side of the bad sample.

There are several C header files that contain all of the error codes and the function header for the DLL.

rollsrolls

Not the answer you're looking for? Browse other questions tagged c#oledbproficyhistorian or ask your own question.