SIEGate v1.8.293

This is the official release for SIEGate v1.8.293

This is version 1.8.293 of the SIEGate, released on December 20, 2023

FYI - Windows installers for SIEGate v1.8.293 prior to 4/9/2024 were suspectable to CVE-2024-24810. The installer download below has been updated to compensate for this vulnerability. Note that since this only affected the installer, the SIEGate version remains the same. If you have an installer (i.e., the SIEGateSetup.msi file) cached on your system, it is recommended to replace the file from the updated download below.

This is an optional minor point release of SIEGate v1.8 but contains many useful updates, see details below.

System now targets .NET 4.8, which is a prerequisite before installation

NOTE: If you are upgrading from a prior version of the SIEGate, 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.

Minor update from prior release of v1.8.291: Added fix for an issue with data frame parsing before reception of config frame resulting from a prior update to improve serialization operations for ID codes.

Updates Since 1.8.141 version released in March 2022

• This build adds support for Azure AD authentication (enable in appsettings.json config file)
  • Manager and console applications will prompt for Azure AD credentials as needed
• Updated reverse STTP connections to support TLS connections
• Optimized user group lookups on AD to speed auth operations on app starts
• Mirror mode setting in manager config now defaults to false
• Installer now only optionally installs eDNA components upon request
• Improved manager startup to auto-detect database mismatch with service
• Added a config-out-sync statistic to allow monitoring of remote config changes
• Improved CSV adapter operations when using down sampling settings
• Improved statistic generation to prevent and remove duplicate statistics
• Added option to allow desired config frame version to be specific in connection string
• Updated MPFP to always request latest config frame for target protocol version
• Fixed HistorianMetadata SQL views when FramesPerSecond is set to zero
• Improved operation of clock sync adapter which syncs system clock to target measurements
• Updated UI displays to show virtual devices when there are associated measurements
• Improved operation of custom installation actions to reduce nuisance messages
• Improved good / bad UI color feedback to show suspect time as bad
• NoInetFixUtil now only auto-disables auto updates when system is not connected to Internet
• Optimized operation of sequence and power calcualtions
• Added DyanmicFilter adapter to allow for modifications of incoming data, e.g., digital bit flip
• Updated OSI-PI output adapter with new settings, e.g., only archive on change
• Fixed phasor attribute tree displays of binary and hex values.
• Updated UI's to include system statistics, including estimated local clock deviation
• Added lead/lag time global adjustment options from home screen

Asset Filename	SHA256 Hash
SIEGate.Binaries.zip	653FE74040C830B1E369A4E5BC63940399A3BFBB56FE64D1F6122B9BE79D3BC9
SIEGate.Installs.zip	3781A0A53CE94F6DE02F2F098902BC2147485FFCE8334DB38466A5CB2040F664
SIEGate.Scripts.zip	BD9D4557DB1879A24C85D0EC4637BD082796458479B76E0ADCC4C63993D5025C

SIEGate v1.8.141

This is the official release for SIEGate v1.8.141

This is version 1.8.141 of the SIEGate, released on March 30, 2022

This is an optional minor point release of SIEGate v1.8, see updates below for details.

NOTE: If you are upgrading from a prior version of the SIEGate, older than v1.8, 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.

PMU Connection Tester Update

An update to PMU Connection Tester, v4.7.1, is now available as well:
https://github.com/GridProtectionAlliance/PMUConnectionTester/releases

Updates Since 1.8.113 version released in Nov 2021

• Updated SerialClient to Disconnect and Dispose SerialPort on class Dispose (fixes rare unhandled exception on service shutdown)
• Added UpdateExistingTagCompressionState parameter to PI Adapter to control if tag compression attribute should be updated on existing tags when UseCompression parameter is enabled
• Added time reasonability parameters to PI Adapter
• Added SkipDigitalAlternateTagSync operation with PI Adapter Tag Sync
• Added Gzip export option to GEP data extractor tool
• Updated DeviceStats adapter SQL
• Added configuration timeout parameters to DeviceStats adapter
• Improved phasor protocol adapter for manual measurement key lookups
• Updated phasor protocol to better handle auto-repeats with spanned CFG3 frames
• Fixed phasor protocol CFG3 Guid attribute display
• Simplified IEEE C37.118 concentrator use of Device model (no local proxy settings required)
• Fixed encoding issues with ValidateAssemblyBindings
• Fixed issue with simulated timestamp ordering during file-based replay
• Fixed restoration of file-based auto-repeat playback checkbox when deserializing a saved connection file

Asset Filename	SHA256 Hash
SIEGate.Binaries.zip	9B42028C4BA012B6665A3C906D7BFD17DA52D296381F972E5294F04F2FB969FF
SIEGate.Installs.zip	70341A5FF59A6261A874DDF5E84EED90CB8625369F5498C0586EEB82BB9AAAE5
SIEGate.Scripts.zip	CA91E1686048089B134DADEBCD472AF5173BD3E4EAFF79C205182A5B49E11407

SIEGate v1.8.113

This is the official release for SIEGate v1.8.113

This is version 1.8.113 of the SIEGate, released on November 18, 2021

NOTE: If you are upgrading from a prior version of the SIEGate, older than v1.8, 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.

Updates Since v1.8.80 Released in September:

• Improvements for parsing / generating spanned IEEE C37.118-2011 Configuration 3 Frames
• Fixes for STTP Reverse Proxy subscribing server auto-reconnection
• Optimizations to PDC initialization for non-historian associated devices
• CSU updates to adjust default value of max thread pool values to reduce context switch issues on larger machines
• Added option to allow disconnection event for file-based inputs when end-of-file is encountered
• Improved Grafana metadata select operations for variable queries
• Added slice-based expression Eval function to GSF Grafana functions
• Improved access locking around legacy OH1.0 metadata files
• Added option to OSI-PI output adapter to only synchronize the AlternateTag field
• Fixed manager statistic overflow issues related to average latency calculations
• Improved synchrophasor phase guessing to include high confidence options
• Updated phasor measurement mapper data stream monitor to allow restarts for passive connections
• Improved operation of the GEP Data Extraction tool
• Added extra security to loading tag template files with calculation operations
• Improved SynchronizeLocalClock adapter device time validation operations
• Updated usages of CreatePointTag to apply analog and digital label parameters where applicable
• Added SEL PDC Import tool to installation
• Added APP DFR Import tool to installation
• Improved default tag-naming expressions when applied from UpdateTagNames tool:

{CompanyAcronym}_{DeviceAcronym}[?{SignalType.Source}=Phasor[:eval{'{PhasorLabel}'.Trim().ToUpper().Replace(' ','_')}_eval{'{SignalType.Abbreviation}'.Substring(0,1)}eval{'{Phase}'=='+'?'1':('{Phase}'=='-'?'2':'{Phase}')}[?{BaseKV}>0[_{BaseKV}]][?{SignalType.Suffix}=PA[.ANG]][?{SignalType.Suffix}=PM[.MAG]]]][?{SignalType.Acronym}=ALOG[:eval{('{Label}'.Trim().Length>0?'{Label}'.Trim().ToUpper().Replace(' ','_'):'ALOG'+((int){SignalIndex}).ToString().PadLeft(2,(char)48))}]][?{SignalType.Source}!=Phasor[?{SignalType.Acronym}!=ALOG[:{SignalType.Acronym}[?{SignalIndex}!=-1[eval{((int){SignalIndex}).ToString().PadLeft(2,(char)48)}]]]]]

See latest updates since previous release.

Downloading Latest PMU Connection Tester Recommended

Latest PMU Connection Tester Release

File Hashes (SHA256)

SIEGate.Binaries.zip => C45CE7383984C3AA66F17398F173CD633A57D8B23069FCC5E401BD05321ECF71
SIEGate.Installs.zip => 5E2ED0532EA9E1AF3FEEB8145D5C4B87FE36710FC5E02A95FFB68BEA85F82176
SIEGate.Scripts.zip => CD50DB8064B510952EA9BED9F3C40360772E1C8259CA9E88CB5EB0DB5C8BCA9A

SIEGate v1.8.80

This is the official release for SIEGate v1.8.80

This is version 1.8.80 of the SIEGate, released on September 9, 2021

NOTE: If you are upgrading from a prior version of the SIEGate (only needed for versions older than v1.8), 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.

Minor Updates over v1.8 released in May:

• Improved phasor guessing, including detecting phasors with “P” suffix as a positive sequence
• Added new flags to improve "listen only" connection options, e.g., a serial listening mode
• Improved local clock synchronization adapter, which can sync local clock to incoming data times
• Added internal setting to incoming phasor connections to allow for more controlled external STTP exchange
• Improved embedded SQL script for DeviceStatsAdapter (includes new views and expanded field lengths)

See full release notes since last release.

SIEGate v1.8

This is the official release for SIEGate v1.8

This is version 1.8.39 of the SIEGate, released on May 15, 2021

NOTE: If you are upgrading from a prior version of the SIEGate, 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.

New Tools / Features:

• AdapterExplorer Tool - analyzes the configuration of a Time-Series Library system validating inputs, outputs and current values
• SEL PDC Importer Tool - directly imports SEL 3373 or 3573 PDC configuration files
• Bulk Sequence Calculator Adapter - creates and calculate sequence values (+/-/0), in bulk, based on current system configuration
• New system level statistics in Manager application with global lead/lag time adjustment option

Major Updates:

• Added full support for IEEE C37.118 Std2011 optional Configuration Frame 3
• Added tag removal options for OSIsoft PI adapter metadata synchronizations
• Improved phase guess operations for synchrophasor device wizard
• Updated DNP3 adapters to latest OpenDNP3 code base with SSL support
• Added "SystemName" for system level deployment level identification provided at install time
• Added SNMP reporting for system statistics
• Improved operation with PostgeSQL schema

Notable Updates to SIEGate for version 1.8

• Added adapter explorer tool from GSF to SIEGate installation
• Added auto-sync ability for service / manager database configuration mismatch.
• Added code to correct any non-unique SQL Server Device unique IDs before database migration
• Added new dependent DLLs to installer for updated PostgreSQL database assembly
• Fixed installer deployment names for Npgsql dependencies
• Fixed PostgreSQL operation for assigning existing database
• Setting SIEGate Manager config as permanent
• Updated all database connection tests and failure messages to be consistent
• Updated installer to add Utilities folder with CLI shortcuts / also now remembers last install path.
• Updated installer to retrieve last service account during installation.
• Updated Postgres assembly version to use 4.0.11
• Updated SIEGate setup to pre-compile (NGEN) SIEGate Manager application

See full release notes since last release.

Note that this release is a minor update to version 1.8.36 that was released on May 7, 2021. Updates to version 1.8.39 include: improved system CPU estimation and config file now set to allow for very large arrays for large deployments.

SIEGate v1.7

Official stable release of version 1.7 of SIEGate (v1.7.4).

NOTE: if you are upgrading from a prior version of SIEGate, 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.

See full release notes since last release.

Note: PMU Connection Tester is installed separately:
https://github.com/GridProtectionAlliance/PMUConnectionTester/releases

New Updates and Improvements

• This version includes the BETA version of STTP: https://github.com/sttp
• Added Modbus Protocol to SQL scripts.
• Fixed up protocols in initial data set scripts.
• Fixed race condition between HandleConnectOnDemandAdapters and adapter initialization.
• Fix DataPublisher subscribe requests to propagate input measurement changes to the routing tables.
• Fixed event wiring in AllAdaptersCollection.
• Fixed casing on protocol definition for DNP3.
• Fixed protocol ID of the test device in the sample data set.
• Fixed NULL comparisons in SQL trigger for tracking changes to Device records.
• Updated the schema version of the databases to reflect the change to the device update trigger.
• Modified order of operations in DataPublisher.HandleSubscribeRequest to fix the issue of subscribers not receiving cached measurements upon subscription.
• Added ManageCertificate command to ServiceHostBase.
• Updated SerializedSchema.bin using refactored Schema class.
• Added code to detach from the StatisticsEngine.Calculated event in DataSubscriber.cs.
• Fixed parameter parsing for PublishInterval in unsynchronized data subscriber
• Added ping console command to servicehostbase.
• Updated ping command to split server setting to remove the port.
• Added code to handle connect on demand scenarios for DataSubscriber.
• Fixed temporal support in DataSubscriber.
• Updated gateway style statistics to fall-back on reflection in source object in case properties are available.
• Modified the sentinel value of objects derived from the AnalogValueBase and DigitalValueBase classes.
• Added validation to the routine that updates the connection string after the user updates a connection string parameter.
• Fixed design-time errors in PagedViewModelBase.
• Updated the status flag reference in the RealTimeMeasurementUserControl to match the status flag reference in InputStatusMonitorUserControl.
• Added IEEE C37.118.2 tab to the status flag reference.
• Fixed input wizard to apply the selected PDC vendor device ID to the concentrator on save.
• Added validation for the chart refresh interval to ensure that the Manger doesn't crash when the value is misconfigured.
• Fixed Latitude and Longitude fields so that trailing zeros don't cause validation errors on the Device page.
• Added line-to-line option under Phase to the Manage Phasor page of the Manager.
• Fixed up startup operation that fills in missing protocols.
• Removed stats from device outputs - although statistics may be associated with device, it will not be the adapter producing them...
• Added more messaging around ToogleBadData testing function and restricted command to admins and editors.
• Updated automated output measurement creation for power calculations to use HistorianID from associated voltage.
• Updated default lag-time of PowerMultiCalculatorAdapter to 5 seconds.
• Fixed the metadata import adapter to use the parent acronym when using source prefix to name child devices.

SIEGate v1.6.143

SIEGate release with Alpha STTP protocol option.

SIEGate v1.6

Official stable release of version 1.6 of SIEGate (v1.6.5).

NOTE: if you are upgrading from a prior version of SIEGate, 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.

See full release notes since last release.

Normally all you need to download is the SIEGate.Installs.zip. The SIEGate.Binaries.zip includes optional adapters that are not installed by default. SIEGate.Scripts.zip includes database scripts, if useful for custom deployments.

Note: the PMU Connection Tester is no longer automatically included with the installer package and will need to be installed separately:

https://github.com/GridProtectionAlliance/PMUConnectionTester/releases

New Features and Improvements

• Fully overhauled system security
• Added ability to control TCP Nagle algorithm through configuration and applied better defaults when applicable
• Added quiet / resume console commands, with q and r alias shortcuts, to reduce noise during interaction
• Improved sub-second time handling
• Improved startup time of applications without Internet access by allowing disabling of generate publisher evidence in the NoInetFixUtil
• Improved sub-second time handling
• Added new GSF time-series Filter Adapters and management 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
• Modified the latest values cache in DynamicCalculator to be fed by the concentration engine to resolve usability issues
• 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

SIEGate v1.5

Official stable release of version 1.5 of SIEGate (v1.5.2).

See full change log since last release.

Note: the PMU Connection Tester is no longer automatically included with the installer package and will need to be installed separately:

https://github.com/GridProtectionAlliance/PMUConnectionTester/releases

New Features and Improvements

• GSF.TimeSeries.UI.WPF: Modified the Measurement Groups Page to automatically issue a ReloadConfig command to update the security context in SIEGate's data publisher so that group based changes get automatically applied to data subscribers.
• GrafanaAdapters: Added full set of aggregation and operational functions that operate on a per-series or per-set for all data sources that implement Grafana interfaces. See documentation.
• LogFileViewer: Added new enhanced general logging capabilities along with a new application, Log File Viewer, that is used to analyze logs.
• PowerCalculations: Added calculators for wrapping angle difference and line impedance with resistance, reactance, conductance and susceptance results - includes both rectangular and polar based outputs.
• PowerCalculations: Updated average frequency calculator to (1) exclude NaN values from average results, (2) allow definable unreasonable thresholds, (3) improve flat-line value detection to throw out repeating values, and (4) added flag to AverageFrequency calculator to allow unreasonable results, e.g., zero, to be reported as NaN.
• GSF.PhasorProtocols.UI: Updated OutputStream data model to accommodate auto-assignment of "auto public config frame flag" based on current channel definitions
• GSF.TimeSeries: Added up-time statistics for system, subscriber, publisher, input streams and output streams.
• GSF.TimeSeries: Added a new enhanced version of the time-series special compression algorithm, automatically enabled for new connections, used with the Gateway Exchange Protocol that uses much less bandwidth. Add ; compression=true to connection string of existing GEP subscriptions to enable.
• GSF.TimeSeries: Created a lookup cache for the main adapter meta-data using dictionary based lookups. This improved load times for input adapters on large systems (e.g., from 160 seconds to less than 1 second in some cases).
• GSF.TimeSeries: Updated measurement definitions to carry meta-data as part of measurement key with an internal reference inside measurement implementations to reduce total memory footprint requirements for new measurements.
• GSF.Core: Added a static timer class to allow many hundreds of scheduled events that run at the same interval to be associated with a single wait event instead of creating a new timer for each event (e.g., as hundreds of devices needing to check statistics every second) - this alleviates thread pool exhaustion that can occur when hundreds of timer events get executed at the same time.

Important Fixes

• PhasorProtocolAdapters: Fixed issue in custom IEEE C37.118 concentrator output streams where phasors were being reordered if a cell had 10 or more phasors.
• PhasorProtocolAdapters: Updated IEEE C37.118 concentrator to allow an explicit config frame 1 to be returned when requested instead of defaulting to config frame 2 - this corrects issues with SEL RTAC devices connecting to openPDC.
• PhasorProtocolAdapters: Corrected issue for output stream mappings when using PMU source device acronyms that are longer than 16 characters.
• DataSubscriber: Updated measurements received with GEP to apply any linear adjustments defined in the local configuration.
• GSF.Core: Added code to ensure that log files won't become deadlocked if an error occurs during rollover.
• GSF.TimeSeries: Updated DataSubscriber meta-data synchronization to exclude calculation and alarm signals from the device measurement removal processing such that if a local subscription creates new calculations associated with a subscribed device, the locally created measurements will not get automatically removed at the next synchronization.

SIEGate v1.4

Note: This is not the latest version.

Official stable release of version 1.4 of SIEGate (v1.4.1).

See full change log since last release.

New Features and Improvements

• New web interfaces to support Grafana dashboards
• Support for PostgreSQL configuration databases
• Bulk power calculation adapter improvements including a more functional AdjustmentStrategy parameter for line-to-line and line-to-neutral adjustments
• New dynamic e-mail responder adapter that will send an e-mail based on a custom expression
• Simplified installation deployments signed with extended validation certificate

Important Fixes

• Improved performance of secure implementations of Gateway Exchange Protocol for access control list lookups in service and manager implementations
• Better phasor reduction management in manager, output streams and GEP meta-data synchronization (e.g., reducing output stream to only include positive sequence phasors)
• Fixed issues in openHistorian 1.0 data and statistic archive deployments with potential race conditions between rollovers and reading data to prevent data access issues
• Outage logs now properly serialize stop timestamps in UTC ensuring proper data gap recovery operations
• NT SERVICE accounts are now assigned needed rights in installer to restart associated host service allowing restart buttons to properly function
• Fixed issues related to creating and using a custom abstract synchrophasor configurations

Remote Console Access for Users with Viewer Roles

A new command has been added to the remote console to allow messages to be filtered down to desired results, see Filter command syntax below. In order for users with view role access to access the remote console, the filter command will need to be added to the included security resources in the main configuration file.

The simplest way to add this command is to run the XML Configuration Editor application that can be found on the start menu and add the Filter command before the Settings command in the IncludedResources configuration key in the securityProvider section of the configuration settings:

<securityProvider>
    <add name="IncludedResources" value="UpdateSettings,UpdateConfigFile=Special; Filter,Settings,Schedules,Help,Status,Version,Time,User,Health,List,Invoke,ListCommands=*; Processes,Start,ReloadCryptoCache,ReloadSettings,ResetHealthMonitor,Connect,Disconnect,Initialize,ReloadConfig,Authenticate,RefreshRoutes,TemporalSupport,LogEvent=Administrator,Editor; *=Administrator"
        description="Semicolon delimited list of resources to be secured along with role names." encrypted="false" />
</securityProvider>

Filter Command Syntax

Filters status messages coming from the service.

   Usage:
       Filter [ { -List |
                  -Include <FilterDefinition> |
                  -Exclude <FilterDefinition> |
                  -Remove <ID> } ... ]

       Filter -?

       FilterDefinition ::= Type { Alarm | Warning | Information } |
                            Message <FilterSpec> |
                            Regex <FilterSpec>

   Options:
       -List        Displays a list of the client's active filters
       -Include     Defines a filter matching messages to be displayed
       -Exclude     Defines a filter matching messages to be suppressed
       -Remove      Removes a filter