Factry Historian
v7
v7 3 5 released on 24/09/2025 bug fixes fixed incorrect file permissions for the historian environment file at installation resolved an issue where a scheduled event could hang if the dtstart was in the future v7 3 4 released on 22/09/2025 bug fixes fixed an issue where deleted timeseries data wasn't properly removed from the timeseries cache resolved a problem with duplicate assets appearing when using "create missing parents" feature in excel asset import fixed sampled calculations not progressing properly during extended periods without "good" data added missing get endpoint for retrieving task details via /get/\ taskuuid enhanced excel import by including sheet name in row error messages when importing assets and properties fixed database locking issue where the original database remained locked after a failed migration improved performance when testing rrules with a dtstart date far in the past added missing audit triggers for authentication provider changes corrected privilege loading issue when creating reader users fixed data preview functionality for input measurements with non standard duration format in interval setting v7 3 3 released on 27/08/2025 bug fixes fixed an issue where a recalculation would panic if the historian is restarted during an active recalculation improved performance for sending logs to the time series database by implementing batch writes fixed external database integration to correctly display numeric and decimal datatypes in the ui fixed task state not saving correctly, with "started on" timestamps being saved as zero time v7 3 2 released on 06/08/2025 bug fixes fixed possible data race issues during asset (property) prototype deletion improved handling of calculation inputs when updating a measurement prototype correctly handle the user having multiple tabs open for multiple organizations fix manual entry event properties being reset for open/pending events v7 3 1 released on 04/07/2025 bug fixes deleted users where not taken into account when checking for case sensitivity conflicts resolved an issue where intervalms and offsetms would be undefined in the calculation context after issuing a recalculation v7 3 0 released on 27/06/2025 deprecation warning the integration with grafana for automatic influx datasource creation is now marked for deprecation, in favor of using the factry historian datasource plugin for grafana the integration will be removed in a future release breaking changes case insensitive usernames usernames are now treated as case insensitive for example, if a user already exists as johndoe , attempting to create johndoe will be considered a duplicate and will be rejected features time weighted average aggregation for influxdb v1 x added support for calculating time weighted average aggregations on measurements in influxdb v1 x databases mqtt and sparkplugb sink enhancements enabled buffering of outgoing messages in both mqtt and sparkplugb sinks to improve delivery reliability under intermittent network conditions introduced a new maxmetricspermessage setting for sparkplugb sinks, allowing to the number of metrics sent per message to be capped event type enhancements configurable parent for event types added an option to assign a parent to an event type, which streamlines hierarchical queries when using our custom grafana data source cascade delete for event types when deleting an event type, users can now choose to automatically delete all associated event configurations and properties previously, these had to be deleted manually before the event type itself could be deleted event overview enhancements status filter users can now filter events by their status (e g , open, closed) include child assets a new “include child assets” toggle enables including events from child assets when filtering by asset expanded audit log filters audit logs now support additional filters by log type and by user, making it easier to locate specific entries excel import/export for assets and asset properties added the ability to import and export assets and asset properties via excel, facilitating bulk management and updates minor changes automatic event closure & re evaluation existing events are now automatically closed when their corresponding event configuration is deleted a new configuration option for manual entry forms of type events allows the event to be automatically re evaluated if the property is overwritten after the event was already completed mode aggregation in timeseries memory cache the timeseries memory cache now supports the mode aggregation, improving performance for queries that use this aggregation mode measurement labels on asset property prototypes measurement labels are now available on asset property prototypes of type new calculation improved sql query preview the sql query tester now limits the number of rows returned in the preview and displays the total row count available task deletion from task overview users can now delete tasks directly from the task overview, removing completed, canceled, or failed tasks in one step support array datatypes in sparkplugb forwarders sparkplugb forwarders can now correctly forward points with array datatypes v7 2 8 released on 26/06/2025 bug fixes resolved an issue where a collector could no longer process its buffer because it contained points for measurements that had just been deleted v7 2 7 released on 16/06/2025 bug fixes resolved an issue preventing already completed tasks from loading on startup update stale collector cache entries when a new collector is registered improved error handling for influxdb v1 12 x fixed potential failures when retrieving sample values for calculations now marks events as “processed” only after all manual entries are complete corrected graph rendering in the manual entry form for periodic properties restored the ability to rename a time series database to a name previously used by a deleted database ensured event properties display correctly in the merge events modal fixed asset property selection in data reference workflows applied organization filtering correctly to forwarders updated the organizations overview to show all organizations, not just those where the admin user is a member changes a max buffer disk space setting of 0 now disables the limit entirely v7 2 6 released on 06/05/2025 bug fixes fixed labels needing to be unique across all organizations resolve inconsistencies in asset and event configuration creation from prototypes fixed point with status bad interfering with raw calculations correctly assign factry historian reader privileges on creation features add “measurement data deletion” filter in tasks overview enable “historian advanced” event property filler for prototypes v7 2 5 released on 08/04/2025 bug fixes fixed a issue where users without privileges to the root organization where not allowed to instantiate a prototype resolved an issue in the timeseries cache aggregated queries would modify the timestamps of the points v7 2 4 released on 02/04/2025 bug fixes added missing event functions to organization schemas fixed an issue with using offsets in influx queries where the limit value was used instead of offset implemented automatic logout for users without privileges resolved an edge case with eviction in the time series cache resolved an issue in the time series cache where points duplicated points could be added v7 2 3 released on 24/03/2025 bug fixes fixed a potential panic issue in the historian advanced property filler resolved a validation issue with the historian advanced property filler v7 2 2 released on 10/03/2025 bug fixes resolved a potential deadlock that could occur when recalculating a calculation multiple times simultaneously fixed an issue in the calculations engine and timeseries cache that caused incorrect behavior when handling irregular calculation intervals (e g , 1m43s instead of the standard 5m) v7 2 1 released on 28/02/2025 bug fixes fixed an issue where the parent uuid for child event configurations was not reset when deleting a parent event configuration fixed frontend bug when on assets without metadata added cleanup function for collector health history fixed an issue on upgrading to 7 2 0 where the event views where not automatically updated v7 2 0 released on 19/02/2025 mqtt forwarding introduced user defined templates to format mqtt payloads (e g , json, xml) in forwarders these templates simplify integration with unified namespace architectures and reduce the need for additional downstream data transformations see the full documentation here dimension events added functionality to map time series data against physical distance or any other dimension and align timestamped measurements with a physical signal, such as meters traveled on a production line this conversion allows you to view production data not just by time, but also by distance ideal for continuous production processes such as extrusion or steel processing external database event generation added support for generating events directly from external database queries this allows automatic event creation from batch management systems, lims, or other third party databases, reducing reliance on manual configurations parquet export optimized parquet data export by bundling multiple measurements into fewer, larger parquet blocks this improvement minimizes the number of files generated while enhancing compression efficiency for better storage and retrieval performance license rework updated the way licensing is done to allow for more flexibly licensing options this includes the ability to license the historian per organization this allows for more flexible licensing options and better control over the historian's usage there is now also a trial license option available to test factry historian before committing to a license ui/ux improvements small changes to the login screen changed all datetime range inputs to use 2 separate date pickers more inputs referencing other objects now link to the referenced object changed help under inputs to be tooltips next to the label saving vertical space small improvements for the prototypes ui other enhancements added a measurement data deletion task allow more aggregations on non numeric datatypes users can now generate api tokens for themselves external database event property detection mode can now access metadata in the script added option to delete prototype instances when deleting a prototype v7 1 10 released on 11/02/2025 bug fixes fixed timeseries queries for multiple measurements when using group by on multiple tags and a tag filter ignore partial writes due to retention policy in influxdb when writing logs and statistics do not log grpc errors for unimplemented methods v7 1 9 released on 29/01/2025 bug fixes disable grpc streaming support to prevent potential data loss caused by the inability to handle influxdb errors synchronously v7 1 8 released on 22/01/2025 bug fixes fixed issue in response of queries with aggregations to the time series cache and influx2 regarding timestamps in the response aggregation queries with a period will now always return the timestamp of the beginning of the period, queries without a period will also return the timestamp of the beginning of the period except for the aggregations first , last , min and max resolved an issue where deletion of failover collector would not delete the corresponding failover configuration do not return the value x fields in responses of queries on boolean and string array data types added mapping for certain influx 1 x errors to differentiate between partial writes and other errors resolved an issue where the interval for sampled or simulation calculations could be set to 0 v7 1 7 released on 8/01/2025 bug fixes fixed an issue where consecutive recalculations could block the calculation collector v7 1 6 released on 23/12/2024 bug fixes fixed parsing of numeric values for boolean measurements fixed a potential crash when calculations start with a future timestamp resolved an issue where event types and event properties could be deleted even if they were in use v7 1 5 released on 12/12/2024 bug fixes fixes bug in migration when there are event types with the same name in different organizations v7 1 4 released on 26/11/2024 bug fixes resolved a potential panic issue when resuming a recalculation task corrected a bug in the timeseries cache that caused incorrect filtering of points when aggregations were applied v7 1 3 released on 04/11/2024 bug fixes fixed event detail not working if a simple event property value was deleted v7 1 2 released on 31/10/2024 bug fixes resolved compatibility issues between the historian binary and specific glibc versions corrected daylight saving time handling in the manual entry form fixed the reversion of periodic manual entry values v7 1 1 released on 28/10/2024 bug fixes resolved an issue where the time series cache returned incorrect timestamps for sampled calculation inputs when the input's aggregation interval was larger than the calculation's interval fixed the event processor not starting for assets created from a prototype corrected the inability to set metadata when creating a prototype from an asset addressed the issue of setting the parent of an asset being created from a prototype when using the 'submit and new' button v7 1 0 released on 22/10/2024 time series cache an in memory cache for time series data has been introduced to significantly enhance the speed of calculations and event processing for more information, refer to time series cache calculation enhancements enabled if97 functions for use within calculations added the capability to access metadata in calculations optimized script execution to reduce overhead when applying the same script across multiple points, resulting in improved performance prototypes added the option to create a prototype from an existing asset ux/ui improvements added "assets" as a separate menu item for improved accessibility relocated "prototypes" to the assets page to consolidate related functions enhanced the tree structure for assets and prototypes, improving clarity and navigation added functionality to delete an asset along with all its child elements, simplifying asset management introduced a filter to show/hide properties and event configurations within the assets and prototypes tree, allowing for a more focused view other enhancements implemented grpc streaming endpoints for collectors, enhancing data collection efficiency made sslmode for postgresql connections configurable to support various security requirements expanded the measurement filter to include datatype filtering achieved significant improvements in event query performance v7 0 5 released on 15/10/2024 bug fixes resolved an issue where the calculation collector failed to resume correctly after being paused fixed an issue where event properties with preview enabled did not update correctly for open events v7 0 4 released on 01/10/2024 bug fixes fixed a bug where processed events are not updated when there are open events and the batch size is set to 1 v7 0 3 released on 25/09/2024 bug fixes corrected an issue where engineering specs managed by a calculation prototype were not always updated correctly resolved a problem where users with read only privileges for measurements could not export them to excel fixed an integer out of range error within the periodic event views addressed a ui bug that displayed the incorrect name of the asset property in the update asset from prototype form fixed a bug where dependencies for asset prototypes were not correctly updated after deleting an asset property resolved an issue where a prototyped calculation could not be used as input in another prototyped calculation changes enable administrators to configure specific settings for the event processor updating an asset from a prototype will now attempt to link existing asset properties, event properties, and event configurations to their respective prototypes it is now prohibited to delete an asset property prototype if it is used in a calculation, event property, or event configuration prototype v7 0 2 released on 11/09/2024 bug fixes fixed in the navigation of the asset tree corrected the translation of the recalculation notifications fixed a bug where the asset parent would be reset when creating an asset from a prototype fixed a bug where values were reset upon click "sync resolved data" in the prototype form v7 0 1 released on 29/08/2024 bug fixes fixed a bug where the setup wizard was not correctly displayed fixed an issue with the event filter not working correctly in the manual entry forms changes add a rest endpoint to get a single task v7 0 0 released on 28/08/2024 new features prototypes we have introduced the ability to create prototypes for assets, asset properties, and events prototypes allow for rapid creation of new assets, asset properties, and events with predefined settings these assets, generated from a prototype, can be managed collectively, streamlining the management of large quantities of similar assets, along with their properties and events enhancements calculation improvements added a refresh button to update calculation context values calculation inputs can now include both asset properties and measurements added support for aggregations on array datatypes, including first , last , and count updated the recalculation modal to differentiate between restarting a calculation and re evaluating a period performance improvements enhanced performance for bulk measurement updates and event processing through batched updates asset and property management introduced a datatype and description field for asset properties, ensuring that the associated measurement matches the asset property’s datatype collector enhancements modified token invalidation to occur 24 hours after generating a new one, instead of immediately added detailed collector connection information provided preliminary support for updating the collector state directly from the historian implemented support for migrating collector settings user interface and experience improved consistency and alignment of buttons across forms and modals enhanced the measurement data preview feature improved clarity in login error messages added an option in event manual entry forms to remember the last entered manual entry timestamp, rather than defaulting to the current time audit log management added a setting to periodically remove old audit logs (disabled by default) measurement improvements introduced a new measurement filter for datatypes limit changing of the measurement datatype to not conflict with references deprecations and removals the following deprecated endpoints and parameters have been removed calculation recalculation removed post /calculation/\ calculationuuid/recalculate in favor of post /calculations/\ calculationuuid/recalculate calculation testing and validation removed post /calculation/test in favor of post /calculations/test removed post /calculation/validate in favor of post /calculations/validate worker pools and tasks removed get /worker pools/tasks in favor of get /tasks removed get /worker pools/\ workerpooluuid/tasks in favor of get /tasks removed get /worker pools/\ workerpooluuid/tasks/\ subject/pause in favor of get /tasks/\ taskuuid/pause removed get /worker pools/\ workerpooluuid/tasks/\ subject/resume in favor of get /tasks/\ taskuuid/resume removed get /worker pools/\ workerpooluuid/tasks/\ subject/cancel in favor of get /tasks/\ taskuuid/cancel events query removed post /events/query in favor of get /events measurement filters removed withbadquality field in favor of a more generic quality field removed databaseuuid field in favor of databaseuuids asset filters removed parentuuid field in favor of parentuuids