Factry Historian
v6
v6 4 7 released on 17/07/2024 changes improved error messages for user login failures bug fixes resolved issue where a raw calculation did not include points with the same timestamp but different tags users with empty passwords are not allowed to login privileges for new organizations are now correctly loaded for the reader user group v6 4 6 released on 04/07/2024 bug fixes fixed check service installed installation step added missing excel column filters on the exported measurement list fixed integer out of range error in periodic event views v6 4 5 released on 25/06/2024 bug fixes trim whitespace from the license token input fixed periodic property timestamps being null instead of empty array v6 4 4 released on 19/06/2024 bug fixes fixed bug where multiple event workers could be started added check for result type of calculation script fixed point status 'badfactryinvaliddatafordatatype' not being reflected in the measurement quality fixed bug where confirm dialog is hidden when deleting manual entry in event overview added error logging to check service installed installation step v6 4 3 released on 05/06/2024 bug fixes fixed bug where an upgrade to v6 3 appends a 1 to the name regardless of the uniqueness under an asset fixed privileges for the reader user for newly created influx v1 databases add missing working directory to the systemd service file v6 4 2 released on 22/05/2024 changes added min, max and mode as allowed aggregations again for booleans and mode for strings bug fixes fixed manual creation of events with a parent configured switching to another organization on the asset tree page caused the user interface to break points with quality badfactryinvaliddatafordatatype are now stored as measurement quality the user group mapping setting on the microsoft authentication provider was ignored external databases had to be unique across all organizations fixed event re evaluation bug if the deleted event had a sub event and that sub event had a sub event itself v6 4 1 released on 29/04/2024 bug fixes added missing privileges for reader user group enforce unique postgres user for organization fixed bug where a raw calculation might query the time series database more than necessary fixed bug while trying to overwrite new historian binary fixed event staying stuck in incomplete state even if all properties are filled escape html properly in dropdowns with search fixed bug with asset tree sometimes not loading v6 4 0 released on 10/04/2024 new features automatic collector upgrades collectors capable of supporting automatic updates can now seamlessly upgrade themselves updates are retrieved directly from the factry portal or can be manually uploaded a new status indicator on the collector list identifies which collectors are eligible for automatic updates persistent tasks key operational tasks, including recalculations and parquet exports, now feature persistence these tasks are automatically saved and will resume from their last state if the factry historian restarts, ensuring no loss of progress enhancements historian installation is now available directly from the binary expanded statistics collection to also include the following read/write count and read/write bytes information for mounted disks time series database (per configured database) version, status, database type and name postgres version, database size and name grafana version, commit hash and status minor improvements to measurement filtering introduced a default value configuration option for certain event property detection modes organizations now benefit from a default reader user group and user which can be used for authenticating the factry historian grafana data source enhanced frontend validation for aggregation selection, only valid aggregations depending on the input measurement data type are available improved usability bulk editing of periodic properties for manual entry forms introduced a new graph view for visualizing manual entry periodic properties added a direct shortcut to edit manual entry forms from their view, improving user workflow enhanced the visibility of selected event details during manual entry creation simplified group management within the manual entry form expanded the dependency framework to include forwarders and manual entry forms, allowing you to quickly find out for example in which manual entry forms and/or forwarders an asset is referenced v6 3 11 released on 10/04/2024 bug fixes fixed bug loading measurements for the asset properties manual entry form if multiple asset properties are configured with the same measurement fixed external databases not being filtered by organization v6 3 10 released on 3/04/2024 bug fixes fixed bug where raw recalculations don't advance if data is not written via the historian api v6 3 9 released on 10/03/2024 bug fixes fixed bug where a raw recalculation might stop if the input measurement has data with bad quality v6 3 8 released on 28/02/2024 bug fixes updating event property data type did not work for pending events fixed parsing of empty periodic property values fixed error when creating a manual entry with limited privileges v6 3 7 released on 19/02/2024 bug fixes fixed bug where raw recalculation finishes too soon v6 3 6 released on 13/02/2024 bug fixes fixed bug where raw calculation advances beyond available data v6 3 5 released on 06/02/2024 bug fixes fixed duplicate key error when migrating database reevaluate event configuration misses first event if start of reevaluation is equal to start of the first event within the reevaluation period context timestamp is not available when testing calculations scripts v6 3 4 released on 30/01/2024 bug fixes fixed manual entry form for events not displaying correct value in some cases fixed database field not being editable after cloning a measurement asset tree now selects the alphabetically first root asset instead instead of any asset changes prefill display name field when configuring properties for the manual entry form for events v6 3 3 released on 19/01/2024 bug fixes fixed bug where a recalculation on a raw calculation might finish before all work is done v6 3 2 released on 16/01/2024 bug fixes fixed a bug in asset property manual entry forms related to empty groups fixed a visual bug in measurement and calculation detail views where the 'referenced by' count would reset when updating v6 3 1 released on 12/01/2024 bug fixes fixed issue with manual entry forms not being displayed properly allow decimal values input for engineering specifications fixed ui breaking when switching an existing calculation to type 'raw' v6 3 0 released on 10/01/2024 new features manual entry enhancements expansion of manual entry forms to include periodic event properties addition of asset property data entry in manual forms, supporting time series data entry via asset tree measurement discovery enhanced collectors to discover measurements automatic onboarding of discovered measurements integration of a default database field in collectors for automatic measurement onboarding cloud connectivity (experimental) implementation of sinks for streaming points and events to mqtt (generic and sparkplugb) creation of forwarders to select specific points and events for streaming introduction of measurement parquet export feature scheduling capability for parquet exports querying of time series data in arrow and parquet formats enhancements improved performance of calculations and event processing optional value mapping configuration for asset property configurations with manual detection mode ability to set units of measurement (uom) on event type properties added functionality to clone manual entry forms bulk editing feature for manual entry forms modal to display measurement utilization (e g , in calculations) filter on asset and event type in manual entry forms introduction of an internal collector for manual data entry measurements enhanced audit log filter improved security for sensitive information in settings capability to enter nil values in manual entry forms expanded worker pool task overview with additional information enable disable experimental features per user v6 2 5 released on 10/01/2024 bug fixes fixed loading of calculation context on startup v6 2 4 released on 29/11/2023 bug fixes sampled calculations might break if there are too many points in the calculation period sampled calculations only used default values if there was no data for all input measurements v6 2 3 released on 8/11/2023 bug fixes validate license after fetching it from the portal v6 2 2 released on 30/10/2023 bug fixes fixed deletion and re evaluation of events fixed measurement data preview include input measurements toggle v6 2 1 released on 06/10/2023 bug fixes fixed measurement preview for bool and string input measurements changes capitalized and renamed variables in calculation context v6 2 0 released on 01/10/2023 new features external database connections added integration with external databases such as postgres, oracle, mysql, sqlite and sap (hdb and asa) event module integration external databases can now serve as a detection mode for event properties to utilize this feature, a sql query is required comprehensive examples can be found in our documentation worker pools added worker pools which enable constrained execution of concurrent tasks worker pools are designated for specific types or groups of tasks, each with individual configurations currently, only recalculation tasks utilize this feature, with additional task types to be included in future releases tasks executed by a worker pool are visible under configuration > tasks users can monitor task progress, view details, and manage tasks directly this includes options to pause, resume, or cancel most tasks calculation context added a stateful context for calculations, which retains the last result and timestamp local context variables used in our custom local tengo library can be added, modified and deleted measurement labels added the ability to add labels to measurements and calculations added filtering options to sort measurements and calculations by labels enhancements added a table view for measurement data previews added functionality to preview input measurement data within data previews for calculations added support for array data types for calculation input measurements enabled calculations to be restarted from a specific timestamp added an option to set a default value for input measurements of sampled calculations when "evaluate insufficient data" is enabled added "close after" as an option to event property configurations v6 1 5 released on 06/09/2023 bug fixes fixed bulk deletion of events fixed an error where manual entry form overwrites the manual entry from from another organization v6 1 4 released on 08/08/2023 bug fixes fixed possible panic in sampled calculation when referencing same measurement multiple times as input measurement sampled calculations will not advance beyond last valid data of all input measurements v6 1 3 released on 07/08/2023 bug fixes fixed prefilling of value in property input field of manual entry forms v6 1 2 released on 03/08/2023 bug fixes fixed decimal precision in property input field of manual entry forms v6 1 1 released on 20/07/2023 bug fixes fixed bug making editing a user not possible v6 1 0 released on 10/07/2023 features manual event entry start/stop events inside manual entry forms edit the start/stop time of an event inside manual entry forms delete an event from inside the manual entry form merge/split events from inside the manual entry form changes added the option to delete a collector added license expiration warning added automatic fetching of license changes properties of events configured with the same display name and in the same group in a manual entry form will be displayed on the same line added rate limiter to the logger v6 0 4 released on 09/06/2023 bug fixes swagger api is now available without trailing slash fixed a bug where it wasn't possible to update a measurement's failover settings if a collector wasn't in 'initial' status changes removed select a provider placeholder from login form added datatype field to getmeasurements endpoint for collectors to use v6 0 3 released on 10/05/2023 bug fixes fixed a bug where you can't remove a root organization group from a user fixed incorrect displaying of periodic event properties when there is a property without data changes added support to use influx2 as internal database for statistics and logs events without a parent are now closed if there is a later parent event available save system statistics of the historian to the internal database added system load and disk space usage of mounted disks to the historian system statistics v6 0 2 released on 28/04/2023 bug fixes fixed a wrong translation in the modal for the reevaluation of events added missing views and functions to the organization schemas fixed a frontend bug breaking some pages when hard reloading changes added organization info to the client portal statistics improved performance of calculations by a factor of 5 improved performance of the calculation of event properties by reducing the amount of required influx queries added a refresh button for the logs v6 0 1 released on 18/04/2023 bug fixes fixed submit button for calculations not working in some cases evaluate insufficient data didn't work if input measurement had no data in the time range fixed user group mapping for groups in the root organization only show relevant properties when setting up a manual entry form fixed raw calculation test button fixed sampled calculation test for aggregation 'count' fixed the organization settings cache fixed the event property worker not updating parent event after updating the event configuration changes display time series database uuid show user in manual entry history refined validation of objects in the api improved search measurement component improved search parent event configuration component v6 0 0 released on 31/03/2023 features organizations added organizations to allow easier deployment of multi site factry historian's authentication & authorization added the following new authentication providers microsoft ldap google added configurable user group mapping for microsoft and ldap reworked the users and user groups management reworked privileges and better enforcement of correct privileges added revokable user session tokens and added api tokens (used by collectors) manual entry of event properties added configurable forms for manual entry of event properties grafana custom data source added support for our custom grafana data source changes time series databases can be soft deleted calculations start in status 'paused' added more calculation examples allow changing of the collector on a measurement 100% more swagger (added swagger api documentation) overhauled the configuration menu layout added duration column to event views measurement search regex support added option to split events event processor performance improvements