@ritchiecarroll ritchiecarroll released this Jan 1, 2018 · 350 commits to master since this release

Assets 4

Official stable release of version 2.4 of the openHistorian (v2.4.30).

NOTE: if you are upgrading from a prior version of the openHistorian, you must migrate your existing configuration to use the latest database schema when the Configuration Setup Utility is run after the installation completes - this version includes schema updates.

This version of the openHistorian allows Grafana to be seamlessly integrated such that the openHistorian primary web site can act as a reverse proxy to an instance of Grafana accessible from the main web URL, e.g.: http://localhost:8180/grafana/. When configured in this mode, the openHistorian will auto-launch the grafana-server executable and act as a front-end server for Grafana. Additionally, the openHistorian will maintain user security synchronization such that a user with an Administrator role in openHistorian will also have an Admin role in Grafana, or if a user has an Editor role in openHistorian they will have an Editor role in Grafana, and so on.

Deployments of the openHistorian with hosted Grafana integration include pre-configured data sources for the primary data and statistics archives named OHDATA and OHSTAT respectively. The latest versions of the openHistorian and OSIsoft-PI Grafana data source are included, as well as a default System Status dashboard

New Features and Improvements

  • Improved web based authentication
  • Fully overhauled system security
  • Modbus device connections
  • COMTRADE data file importer
  • Improved sub-second time handling
  • Included GSF time-series Filter Adapter management
  • Added panning support for Trend Measurements screen
  • Added new Grafana functions and capabilities (see full list)
  • Better pre-compilation options of Razor web pages at service start
  • Provided CSV export options to daily quality reporting
  • Added "useSourcePrefixNames" boolean connection string parameter to DataSubscriber to allow override ability on subscription prefixes applied to devices names
  • Included new GSF adapter to allow selection of a "best" value based on configuration options

Important Fixes

  • Updated POSIX based installations to default to Basic authentication
  • Modified the latest values cache in DynamicCalculator to be fed by the concentration engine to resolve usability issues
  • Updated Grafana annotation queries to always operate at full resolution so that no alarms will be missed
  • Fixed memory leak in MultiProtocolFrameParser when replay start time and stop time is specified
  • Fixed logic error in AverageFrequency calculator when reporting unreasonable results as NaN
  • Fixed SQL syntax for updated Phasor synchronization in DataSubscriber
  • Updated LDAP security provider to allow UserData.IsDefined to be assumed to be true if no cached user can be found to allow authentication to be attempted
  • Added a safety check around target cache acquisition for cases where cache may have been disposed
  • Handled edge case in SIDToAccountName to resolve errors with null input
  • Removed references and dependencies on to Thread.CurrentPrincipal throughout system as part of security overhaul
  • Corrected access control issues on shared Modbus configuration screen

Migrating to openHistorian 2.0 in other GPA Products

It is recommended to install a stand-alone instance of the openHistorian 2.0 and subscribe to other data sources, e.g., using GEP, to get data in the openHistorian. However, using the openHistorian.Binaries.zip download that can be found here, you can extract the needed openHistorian 2.0 assemblies needed to upgrade any openHistorian 1.0 instance running in a GPA product built using the GSF Time-Series Library, e.g., the common PPA openHistorian 1.0 instance running in an openPDC. You can also migrate existing openHistorian 1.0 .D data files into openHistorian 2.0 .D2 data files using the Archive Upgrade Utility that comes installed with the openHistorian.

To start using the openHistorian 2.0 within an existing GSF Time-Series Library based application, begin by following these steps.

Known Issues

The built-in System Status dashboard "Active Input Connections" single-stat panel reports an invalid value for system with multiple direct connections or GEP based inputs, change the metric query to the following to produce a correct count:

SliceCount(10, Exclude(0, 0, FILTER ActiveMeasurements WHERE PointTag LIKE '%!PMU:ST4'))

To change the query you may need to first make the page “editable”. To do so, click the “gear” icon at the top of the page and select “Make Editable”, save the dashboard, then refresh the page. Now when you click on the panel titled “Active Input Connections” you can click “Edit” and paste in the corrected metric query above.


This release has been updated, note the following changes since v2.4.22:

  • Fixed references for TrendMeasurements view to correct zoom out and pan
  • Updated Grafana deployment to 4.6.3
  • Reduced web file deployment footprint