Version Information

Breaking Changes

TSM-3808 WebTSM Services: Wrong Type for Some Parameters

The parameters "attribute", "orderBy" and "field" of the endpoint

CODE

/repositories/{repository}/timeseries

were configured as parameters of the type "String". As a result clients that were automatically generated from the YAML file could not pass a list of values to a corresponding request. This has been fixed and the relevant parameters have been changed and are now configured to be arrays for items of the type "String".

Likewise the parameters "calculationIntervalMultiplier" and "intervalMultiplier" of the endpoint

CODE

/repositories/{repository}/calculations

were found to be configured as "String" when they should have been configured as "Integer". These have been corrected.

Features

TSM-2513 Master Data Administration: Remove Clipboard Buttons

Buttons relating to the clipboard feature have been removed from the Time Series Search window when opening it via the ribbon menu item "Master Data Administration", as there is no clipboard functionality in this context.

TSM-3025 Change Return Value Data Type of TSAA Function to "Data"

The function TSAA used to return a value of type "Double" which was incompatible with the expected input parameters of other functions. The data type of the TSAA function return value has now been changed to "Data". As a result it is now possible to use the TSAA function in combination with other functions.

Example

CODE

Peak(TSAA("kW", "TRUE", "Test_Attribute|Test1"))

In this example the time series data returned by the TSAA function is directly used as the input value for the Peak function.

TSM-3250 WebTSM Services: Disable Owner Check for Authorization Management

Until this version it was only possible to change or delete an authorization rule for a given repository if the user had ownership of the relevant rule. Respectively it was also necessary to be the owner of any rule in order to add new rules.

A new setting for the HAKOM.Config has been introduced in order to make management of authorization rules more comfortable:

XML

<HAKOMConfiguration>
    <products>
        <WebTSMServices>
            <Authorization>
                <DisableOwnerCheck>true</DisableOwnerCheck> <!-- Default: false -->
            </Authorization>
        </WebTSMServices>
    </products>
</HAKOMConfiguration>

With the setting configured as "true" the WebTSM Services will not check for ownership of rules when a user tries to add, change or delete authorization rules. Since this configuration effectively gives admin rights to all users, caution is advised when enabling the setting. By default the setting is configured as "false".

This change provides the following benefits:

Easy initial setup of authorization rules
Authorization rules with owner "Unknown" can be changed via the WebTSM Services; no specific database scripts are necessary
Fail-safe in case of accidentally locking out the owner of a rule
Easy cleanup of any rules, including rules with invalid ownership claims

TSM-3412 WebTSM Services: Replace Double.NaN and Double.Infinity with 0 for Serialisation

Due to limitations of the JSON specification, it is not possible to serialise Double.NaN and Double.Infinity values via System.JSON. These values have therefore been replaced with 0.
Example: A division by 0 now returns 0 instead of Double.NaN in the JSON response.

TSM-3833 WebTSM Services: Grafana Extension - Search Function with Logical “OR” Implemented

When searching for several time series via a list of time series names, the individual search parameters are linked with a logical "OR".

Example

CODE

{"timeseriesNames": ["MyTimeSeries1", "MyTimeSeries2"]}

TSM-3890 Data Interface Now Included in the Standard Installation Package

The HAKOM Data Interface is now part of the standard installation package of HAKOM TSM and located in this directory: HAKOM TSM Standard_x.x.x.x\Data Interface

For information about the Data Interface configuration please refer to the documentation here: Data Interface Configuration

A user documentation may be found here: Data Interface User Guide

TSM-3892 WebTSM Services: Grafana Extension Now Included in the Standard Installation Package

The Grafana extension is now included in the standard installation package of HAKOM TSM and located in this directory: HAKOM TSM Standard_x.x.x.x\WebTSM Services\Extensions

For more information on the installation process, please refer to this page: Grafana

The API reference and the user guide are available here: API Reference and User Guide

TSM-3894 Performance Improvements for SOAP Services

Through parallelisation we were able to achieve performance improvements for our SOAP services when reading or saving time series data.

TSM-3992 WebTSM Services: Implement Schema for MetaInfo

Automatically generated clients provided only an undefined object for "GetTimeSeriesMetaInfoByID" and "GetTimeSeriesMetaInfoByName". A schema has been created and now it is possible to comfortably access these properties. This change affects the following endpoints:

CODE

/repositories/{repository}/timeseries/{ID}/metainfo
/repositories/{repository}/timeseries/{name}/metainfo

TSM-4207 Improve Performance When Loading Historical Data and Quotations

By making changes to how data is retrieved from the database in some circumstances, a dramatic increase in performance has been achieved.

Fixed Bugs

TSM-2853 WebTSM Services: "Now Listening On" No Longer Contains the Entire URL

When starting the WebTSM Services via console the output for "Now listening on" used to display the entire URL of the service. Due to technical reasons a fix is not possible. Instead an additional message is now displayed and logged which provides the entire URL of the service:

POWERSHELL

The application is available under: [WebTSM Services URL]

TSM-3592 Attributes: Incorrect Behaviour When Table "Attributes" Is Sorted

If the table "Attributes" in the TSM App is sorted by "Name", "Description" or "Data type" an error message appears when trying to create several attributes with the same name. Nevertheless the attribute appears in the list of attributes afterwards. This misbehavior has been fixed.

TSM-3697 Batch File "CreateDB_initial_3_8_0_to_latest.cmd" Fails When Database Name Contains a Space Character

The script "CreateDB_initial_3_8_0_to_latest.cmd" which can be used to create MS SQL Server databases, failed when the provided name for the database contained a space character. This bug has been fixed and it is now possible to use database names which contain spaces.

TSM-3719 WebTSM Services: Wrong Aggregation Method for Time Series With Different Time Zones

In certain cases WebTSM Services selected the wrong aggregation method when aggregating data from multiple time series, that were configured with different time zones, by an ad-hoc formula via the endpoint

CODE

/repositories/{repository}/calculations

This bug has been fixed and the correct aggregation method will now be applied.

TSM-3769 WebTSM Services: Missing Properties for /timeseries

The properties "Attributes" and "MetaInfo" for the endpoint

CODE

/repositories/{repository}/timeseries

were missing in the YAML schema. As a result it was not possible for automatically generated clients to use these two properties. The schema has been extended to include both properties.

Please note, that the properties will only be filled if the corresponding parameters "includeAttributes" or "includeMetaInfos" are set to true.

TSM-3809 Permission Checks Not Functional in Certain Cases

Since changing the default names of some central system objects the corresponding permission checks did not work as intended in some cases. The bug has been fixed and all permission restrictions are now respected.

TSM-3819 Error When Time Series with Assigned Attributes Are Copied and Saved

An error occurred when trying to save a time series that was copied from a time series with assigned attributes with the option to keep the assigned attributes for the copied time series. This bug has been fixed.

TSM-3820 WebTSM Services: Quotation Returned as "Null" In Some Cases

When searching for a non-quotation time series with one or both of the parameters "includeMetaInfo" and "includeAttributes" set to "true", the response returned a "null" value for the field "quotation". This behaviour affected the following request:

CODE

GET /repositories/{repository}/timeseries/

The field "quotation" should not be nullable so the behaviour has been corrected. The response will now return "false" in these cases.

TSM-3832 Error When Reading Quotations with exactQuotation=False

A performance improvement in a previous version caused an error in certain cases, when reading quotation time series with the flag "exactQuotation" set to "false". This error has been fixed.

TSM-3896 Incorrect Behaviour When Adding/Deleting Time Ranges in TSM Templates with Only One Line

A new HAKOM.Config setting introduced in version 3.9.1 provides the possibility to configure the behaviour of Excel formulas when extending or reducing the time ranges contained in TSM templates (see TSM-3754).

It was wrongly assumed that this behaviour cannot be controlled if the time range is only a single line.

In fact, this was a bug that has been corrected and the behaviour when adding and deleting time ranges now works even if the time range is only one single line.

TSM-3949 Error When Saving Data with an Irregular Interval

An error was thrown in certain cases when saving data with "From" dates that don't match the interval of the time series. This bug has been fixed.

TSM-4062 WebTSM Services: Time Series Collections Sum By Quotation Not Working

The method for aggregation based on attributes using time series collections for quotation time series and a specific quotation date has been implemented now.

CODE

/repositories/{repository}/timeseriescollections/data/sum

TSM-4078 Error When Searching Time Series by Attribute Values

Under certain conditions, a performance improvement implemented in an earlier version led to incorrect results when searching for time series by attribute values or when performing certain aggregations based on attribute values on SQL Server databases. The error was corrected via a correction made to the database with the result that both the time series search and the relevant aggregations now provide the expected results.

TSM-4122 WebTSM Services: Time Series Collections By Attributes Not Working

Reading attributes from several time series returned the status code 500.

CODE

/repositories/{repository}/timeseriescollections/attributes/{attributeID}

This bug has been fixed.

TSM-4164 EvalComponent Functions Return "NoValue" Instead of "Missing" Flag for the Return Value

For some EvalComponent functions, the result was incorrectly returned with the flag "NoValue" if only values with the flag "Missing" were available for the execution of the function. This error has been fixed and the return value of the affected functions now carries the correct flag "Missing". This change has also fixed subsequent errors for cases where the return value of these functions was included in further calculations.

The following EvalComponent functions were affected and have been corrected:

ValidIntegral
ValidMax
ValidMin
ValidAvg
ValidAvgLeadLag

TSM-4283 Time Series Master Data Import: First Run Slow in Some Cases

The first import process of time series master data showed a slow performance in certain cases. The cause has been identified and the problem was fixed, now all master data import runs feature the usual fast performance.

TSM-4278 TSM App: No Error Message for Faulty Date in First Line of TSM Template

When saving time series data via a TSM template that had a wrongly formatted date in the very first line, no error message was shown and the process was marked as successful even though no data was saved. This bug has been fixed and an error message will now be displayed for dates with an incorrect format.

Deprecation Notice

Version History

v3.9.1

Important Changes

TSM-3328: Existing HAKOM.Config files need to be adjusted

Features

TSM-2286 Master Data: Default Table Should Be "Attributes"
TSM-2590 TSM App: Allow Hiding of Advanced Parameters
TSM-2731 WebTSM Services: Live and Ready Health Checks
TSM-3002 WebTSM Services: Configurable Details in Error Messages
TSM-3079 WebTSM Services: Environment Variables for Dockerized Deployments
TSM-3177 WebTSM Services: Authorization Caching
TSM-3233 WebTSM Services: Add StartOfDay and StartOfYear Parameters To Calculations
TSM-3277 WebTSM Services: GET Method for repositories/{repository}/timeseriescollections/attributes/{attributeID}
TSM-3300 Rename ZAMS Plug-In to Time Series Plug-in
TSM-3315 Improve Performance When Loading Historical Data and Quotations
TSM-3328 WebTSM Services: Improve the Way Logging is Configured
TSM-3562 Performance Improvement for Time Series Search
TSM-3614 Remove References to ZAMS
TSM-3621 WebTSM Services: Time Zone Transformation
TSM-3631 WebTSM Services: Improved Error Message When Attempting to Write Data onto A Formula Time Series
TSM-3638 TSM App: Add Warning Message When Attempting to Load a Simple Time Series With Quotation Date
TSM-2895 Upgrade PostgreSQL Support
TSM-3343 PostgreSQL: Script to Create Initial Database
TSM-2984 PostgreSQL: Scripts for Linux
TSM-3155 PostgreSQL: Changes in configuration.ini
TSM-3711 WebTSM Services: Extend the Time Series Data Format "TimeStamp" to Include Time Zone
TSM-3760 Improved Update Script for PROTOCOL Tables on MS SQL Server
TSM-3761 Configurable Behaviour When Adding and Deleting Time Periods in TSM Templates

Fixed Bugs

TSM-2784 WebTSM Services: /repositories/{repository}/timeseries?interval=No Returns All Time Series
TSM-2823 WebTSM Services: Error Message for Missing URL in HAKOM.Config Was Not Logged
TSM-3319 Automation Plug-In: Default Values for HAKOM.config
TSM-3639 Error Message If Enums in the Request Body Were Passed as Strings
TSM-3650 Correction in Script connect_SYSTEM.sql
TSM-3653 TSM App: Empty Line Is Added by Mistake
TSM-3657 WebTSM Services: Wrong Format for MetaInfo
TSM-3672 WebTSM Services: Internal Server Errors Are Not Logged
TSM-3758 OutOfMemory Exception When Loading Formula Time Series

v3.9.0

Important Changes

This first 3.9 release includes some changes to the database structure underlying HAKOM products to improve both usability and performance. In addition, the structure of the documentation has changed significantly.

Features

TSM-2697 TSM Visuals: Support for Port Range
TSM-2755 Switch To .NET 5
TSM-2758 Remove Obsolete Sum Methods From Formula Time Series
TSM-2866 WebTSM Services: Remove Endpoint /configuration
TSM-2905 Oracle Unmanaged Driver No Longer Supported
TSM-2992 WebTSM Services: Remove Obsolete Query Parameters "dateFormat" And "format"
TSM-3118 Improve Performance of Working With Attributes
TSM-3153 WebTSM Services: Remove Parameters "dateFormat" And "format" From POST /.../calculations Request Body
TSM-3265 New Fields for Audit, Compressed and Quotation Time Series
TSM-3266 WebTSM Services: Remove Endpoints "/users" And "/roles"
TSM-3340 Improved Performance When Reading/Writing Time Series Data
TSM-3341 Improve Performance of Accessing HAKOM.Config
TSM-3348 WebTSM Services: Remove Obsolete Parameters "type>" And "type<"
TSM-3373 WebTSM Services: Remove Obsolete Parameters "Limit" And "Offset"
TSM-3375 Overhaul of the Open Api Schemes
TSM-3378 WebTSM Services: Remove Obsolete API Versions
TSM-3473 CSV Import: Checksum Line Causes Failed Import
TSM-3482 Changes to the Master Data Plug-In for Audit, Compressed and Quotation Time Series
TSM-3483 TSM App: Changes to the GUI for Audit, Compressed and Quotation Time Series
TSM-3532 Time Zone Parameter for Calculations

Fixed Bugs

TSM-3398 Data Interface Console: Error Messages for Missing Time Series Despite Setting <IgnoreMissingTimeSeries>
TSM-3454 Properties Are Case Sensitive
TSM-3453 Renaming Time Series Creates Duplicate
TSM-3407 Error When Hosting WebTSM Services on Azure
TSM-3488 CSV Import: Import Files Are Mistakenly Moved to Error Directory
TSM-3497 CSV Import: Specific Warning in Case of Incorrect Values in the Import File

Deprecation Notice

Version 3.9.0 is the first 3.9 release. This means that it may include incompatible changes to any version prior to 3.8.7.

The previous release (version 3.8.7) remains active as a long-term supported version.

v3.8.7

Important Changes

TSM-2735 Adaptations to the Default Deployment Package
TSM-2756 Update To .NET Core 3.1

New Features

TSM-2544 ZAMS Plug-in: Hide Section "Master Data Export/Import"
TSM-2562 Increase Performance of Master Data Export
TSM-2613 TSM+: Extension of the Menu Bar with "Refresh" And "Save
TSM-2691 ZAMS Plug-in: "Node Aggregate" Section Should Only Be Displayed If Nodes Are Available
TSM-3032 Start of Day Should Be Accounted for in Formula Time Series
TSM-3021 Improve Performance when Reading Historical Time Series Data with Exact Date.
TSM-2998 Searching for Time Series By "Name" and "Description" Faster When Using SQL Server
TSM-2680 Parallelize Master Data Import
TSM-2735 Adaptations to the Default Deployment Package
TSM-3098 Support for TimescaleDB under PostgreSQL
TSM-3174 Support for PostgreSQL 13
TSM-3008 Faster Time Series Search When Using includeAttributes
TSM-3074 Improved Performance of JSON Serialization and Deserialization for .NET Core
TSM-3099 New Endpoints /dateformats and /timeseriesdataformats
TSM-3167 Support for HTTP Compression
TSM-3091 Generating a .NET C# Client Using NSwag
TSM-3157 Performance Logging
TSM-2757 EvalComponents: Mark Sum(ID) as Obsolete

Fixed Bugs

TSM-1977 Roll out Shows the Default Settings at Each Call
TSM-2474 Inconsistent Display of Predecessors/Successors in Formula Time Series
TSM-2699 Errors When Saving on Spontaneous Time Series While Using Specific Oracle Databases
TSM-2702 Node Attribute Cannot Be Deleted
TSM-2719 Error after Right Click in Excel
TSM-2767 Calculation Interval Starts on From-date
TSM-2795 Error Reading Modified Quotation Data with the "not exact" Option
TSM-2564 Rename Properties to Category in Master Data Import/Export Plug-In
TSM-2809 Infinite Last Value for Spontaneous Archive Time Series and Quotation Time Series
TSM-3290 Data Validation Server: Error When Multiple Processes Access a File at the Same Time
TSM-3291 Data Validation Server: Hidden Worksheets Are Not Processed
TSM-2738 Several Hakom.Config Entries Are Not Considered
TSM-3258 Data Is Stored Improperly If StartOfDay and StartOfYear Are Not Correct in the Time Series Definition
TSM-3283 Missing Flag Handling
TSM-3317 Interval and Unit Should Not Always Be Required
TSM-2807 Error During Authentication with Disabled Integrated Identity Provider
TSM-2822 Exception with Several Hundred Concurrent Database Connections under PostgreSQL
TSM-2747 Data Interface Console: MSCONS Import Missing

Deprecation Notice

TSM-2757 EvalComponents: Mark Sum(ID) as Obsolete

v3.8.6

New Features

FW-2758 Warnings for SQL Server Initial Scripts for Version 3.8.0 Should Be Prevented
FW-2761 Update of Third Party Libraries
FW-2762 Update .NET Framework and .NET Core
FW-2792 Performance Improvements for Time Series Search by Attributes
FW-2810 Performance Improvements for Time Series Search by Name
FW-2827 Signed Data Interface Console
FW-2836 Remove Obsolete Package 'TIMESERIES34'
TSM-2331 'IF' Formula Should Use Flag of the Value
TSM-2554 Master Data Import Should Ignore Unnecessary Spaces in Formulas
TSM-2481 Correct Population of the List 'Node Aggregate' on TSM Interface
FW-2481 Logging in JSON Format
FW-1776 Performance Optimization for Pagination
FW-2312 Ability to Query Modifications for Formula Time Series
FW-2447 Support of Epoch Seconds and Epoch Milliseconds for Mediatype Parameter "dateFormat"
FW-2767 Move Query Parameter "format" And "dateFormat" To Media Type
FW-2791 Individual Sorting for Time Series Search Results
FW-2864 Correlation-ID for WebTSM Service Requests
FW-2921 Select Aggregation and DefaultQuotationBehavior

Fixed Bugs

FW-2658 Requesting Time Series Data within Period Which Does Not Match Multiple of the Time Series Interval May Lead to Misinterpretation
TSM-2475 TSM Visuals: Error If <VisplorePortOfClient> And <VisPloreLightPort> Have the Same Value
TSM-2651 Error Message for Unnamed Templates in HAKOM.Config
TSM-2528 Incorrect Behavior When Importing Master Data with a Non-existent Node
TSM-2602 Error Message When Trying to Open the TSM Interface in TSM+ Without an Open Workbook
TSM-2610 Aggregation "Max" Is Not Recognized
TSM-2617 Error During Initial Attribute Assignment for Databases Deployed via Docker
TSM-2621 Problems with Performance of Diagrams Containing a Large Number of Data Points
TSM-2623 Invalid AssemblyCache Path Results in Error Message
FW-2680 Saving of Time Series Data with Aggregation "At the Moment" Never Finishes
FW-2700 Exception When Trying to save Empty Data Section
FW-2714 Incorrect Response Status If Time Series Data Cannot Be Deserialized
FW-2793 Improve Performance of Request GET repositories/{repository}/attributes/{id|name}
FW-2838 Database Exception When Missing Required Field on POST /auth/providers/hakom/users Request
FW-2840 Deleting a User That Does Not Exist Throws an Error Message
FW-2872 Wrong Status Code in Response If Serialization Limit Is Reached
FW-2868 Slow Performance of WebTSM Services When Reading Time Series with Attributes
FW-2898 No Error Message for Invalid Query Parameter Values

v3.8.5

Important Changes

FW-2563 Default Values for the HAKOM.Config
FW-2413 New Authorization Method implemented

New Features

FW-2282 PostgreSQL: Performance Improvement When Storing Time Series Data
FW-2515 Precision When Saving Values with Aggregation "Sum"
FW-2515 Save Data in SQL Server As Floating Point Numbers
FW-2563 Default Values for the HAKOM.Config
FW-2664 Provide a Script for Cleaning Up Databases
TSM-1618 Modification of the TSAA- and TSCA-Formula
FW-2604 Search for Exact Time Series Names In .NET API and WebTSM Services
TSM-1618 Modification of the TSAA- and TSCA-Formula
TSM-2214 Saving Data Onto a Time Series and Intentionally Leaving Out Intermittent Time Periods
TSM-2454 Removing Conditional Formatting
TSM-2526 Error Message for Invalid Audit and Quotation Date
FW-1815 Deployment of WebTSM Services as a Docker Image
TSM-1618 Modification of the TSAA- and TSCA-Formula

Fixed Bugs

FW-2629 Bug Accessing Repositories
FW-2690 Error When Using a Newly Set Up SQL Server
TSM-2308 Conversion of Units with Superscript 2 Does Not Work
TSM-2523 Rounding Errors When Converting Time Series Data
FW-2660 TimeSeriesRepository.Sum() On IAttriuteNodeEntity Incorrect
FW-2666 TimeSeriesRepository.Sum() On IAttriuteNodeEntity Uses Inefficient Method When No Unit Is Specified In Calculation
FW-2716 Error with Multiple References of a Time Series with Different Offset
TSM-2583 Flag Names Are Not Language Specific, If Setting Is Missing in HAKOM.Config
TSM-2418 KISS-A Transformation via Data Validation Server Results in Error Message
TSM-2484 Various Display Problems with Diagrams in TSM
TSM-2485 Reporting Functions on PostgreSQL Not Functional
TSM-2496 esales Plug-in: Error When Reading a Time Series with an Apostrophe in the Name
TSM-2518 SQL Server: Loading the Suggestions in the Formula Editor Takes Too Long
TSM-2578 Batch Plug-in Changes Selected Template When Clicking on "Test"
TSM-2588 Error If No Time Zone Was Stored for a Time Series
FW-2521 Problems Saving Data with Missing Periods In Between Onto a Time Series with a Greater Interval and Aggregation Rule "Sum"
FW-2627 TSM Interface Does Not Adapt to Changes in Window Size
TSM-2589 Error in TSM+ When Updating the Batch Plug-in Template
FW-1777 Incorrect Pagination Total Value for Time Series Search Requests
FW-2430 Problems with Integrated Identity Provider Endpoints
FW-2553 Wrong MetaInfo with Split Time Series Data of Compressed Time Series
FW-2660 Sum of All Series in a Tree Not Correct When Tree Attribute Itself is Included in the Request
FW-2666 Sum of Trees Does Not Use Optimized Calculation Method
FW-2702 Bulk Operations Always Return Status Code 200
FW-2713 Compressed Time Series Return Incorrect MetaInfo
FW-2717 Exception Whenever One of the Time Series IDs Does Not Exist in Bulk Requests
FW-2726 Value "Total" Not Implemented for Parameter "calculationInterval" Of GET /calculations
FW-2748 IANA Time Zones Are Not Displayed Correctly in the Time Series Search

v3.8.4

Important Changes

FW-2524 Basic Authentication Remains Available
FW-2334 Consolidated Hosting Technologies Across Platforms
FW-2524 Improved Documentation for Authentication

Breaking Changes

FW-2206 Removed SCHEMANAME and ODBCCONNECTION from FWT_TIMESERIES
FW-2304 Rename and Move <WebTSMServicesSerialize>
FW-2337 Allow Only A Single URL For Hosting The Service
FW-2488 Forwarded-Host Should Include Port

New Features

FW-2206 Removed SCHEMANAME and ODBCCONNECTION from FWT_TIMESERIES
FW-2406 Database initial script for esales
FW-2266 Validation of Settings For InternalTimeUnit
FW-2340 User-friendly Error Message When Attempting to Save A Time Series With an Empty Name
FW-2533 Aggregating Trees Should Respect Time Slices
TSM-2284 Signed Executable for Uninstalling TSM
TSM-2333 Empty Cell As Result Of a Formula
TSM-2180 User Friendly Message When Loading a Time Series Wich Has Neither Formula Nor Data Table Defined
TSM-2273 After Opening/Refreshing A Time Series The Main TSM Window Should Not Be Brought To The Foreground
TSM-2298 User Interface Improvements
TSM-2314 Support of Flag "NoValue"
TSM-2368 Immediately Use a Time Series That Was Just Edited In The Search Form.
TSM-2387 TSM+: Dedicated Buttons for Plug-ins
TSM-2440 Improve Templates for Time Series
TSM-2456 Calendar Plug-in: Improved Performance When Loading Calendar Entries
TSM-2457 esales Plug-in: Represent Multiple Selected Time Series by "Multiple Time Series Selected"
TSM-2466 Automatic Focus of Time Series Name When Opening the Time Series Search Window
FW-1283 Editing System Attributes From Within The Time Series Search Window
FW-1727 Referencing a single time series with different conversion units in a formula time series
FW-2216 User-friendly Error Message When Exceeding Maximum Length For Attributes
FW-2555 Master data - Node Import: Change Behavior When Importing Nodes With Positive ID
FW-1902 Configurable Hosting Parameters
FW-2493 WebTSM Services: Cross-Platform Support for SSL
FW-2524 Improve Documentation for Authentication
FW-1817 Edit/Create units
FW-2172 Search for attributes via name
FW-2231 Additional options for date formats
FW-2288 Improve Error Message When Webhooks Can't Be Registered Due to Config
FW-2307 Get Known Identities and the Authorities That Authenticated Them
FW-2408 Add Ability to Update Existing Attributes
FW-2414 Edit Attribute Descriptions
FW-2415 Tree Management
FW-2431 Calculating Tree Aggregates
FW-2487 Change Status Code When Wrong Database is Configured

Fixed Bugs

FW-2583 Mistake in PostgreSQL Scripts
TSM-2134 SQL Server: Attributes of Type Node Cannot be Deleted
TSM-2335 Error Message When Attempting to Create a Time Series With the Name "null"
TSM-2486 Attempting to Assign an Attribute Which Has An Empty Description Fails
FW-1727 Error When Converting the Same Time Series To Different Units In A Formula
FW-2435 DataInterface: Error When Importing Data From A CSV File Into A Database Configured for Millisecond Interval
FW-2531 PostgreSQL: Umlauts Not Properly Displayed When Using PostgreSql
TSM-2073 TSM Does Not Start Properly When Started By Opening Using the Rollout Function
TSM-2112 German Error Message in Spite of Application Being Run In English Language
TSM-2182 ZAMS Plug-in: Drop-down List "Node aggregate" Shows All Types Of Attributes.
TSM-2185 Data Validation Server: Batch Runs Even If Deactivated
TSM-2197 Attempting To Log In Without a Properly Configured BENUTZERVERWALTUNG Causes Error
TSM-2215 Selecting a Different Time Series Causes Settings of Graph To Reset to Defaults
TSM-2223 ZAMS Plug-in: Error When Attempting To Open Time Series Drop-down List While Data Source is Empty
TSM-2234 Master Data Import: Empty Cell in Columns StartOfYear and StartOfDay Overwrites Existing Values With Default Value (1)
TSM-2335 Error Message When Attempting to Create a Time Series With the Name "null"
TSM-2238 Master Data Import: No Message Of Success When Time Series Was Successfully Created If an Assigned Attribute Did Not Exist
TSM-2253 Copying Time Series Automatically Copies Attributes Instead Of Prompting The User Which Action To Take
TSM-2254 Formula Reverted to "unvalidated" State After Saving Time Series
TSM-2363 The Grid "Half a Year" Is Not Recognized When Updating
TSM-2367 Incorrect Behavior of Time Series Search Results When Creating a New Time Series
TSM-2385 TSM+: Diagram Names Always German
TSM-2386 TSM+: Custom Flag Names Are Not Being Displayed
TSM-2392 TSM+: Flag "Schedule" Not Visible In Context Menu
TSM-2399 TSM+: Flags Visible Even If Deactivated in HAKOM.Config
TSM-2412 Tables Lost When Changing a Time Series Type From "Formula" To "Standard"
TSM-2421 ZAMS Plug-in: Error When Selecting Multiple Time Series
TSM-2426 esales Plug-in: Error When Saving Data in Monthly Resolution on a Time Series Set to a Daily Resolution
TSM-2430 esales Plug-in: Error When Copying from the Search Drop-down List Using Ctrl+C
TSM-2438 Time Series Search Window Remains In Background After Minimizing
TSM-2445 esales Plug-in: Error When Reading Time Series with Description
TSM-2447 esales Plug-in: Error When Searching For Time Series
TSM-2459 User Management Plug-in: Error With ID When Editing Users
TSM-2469 Logging Out While Time Series Search Open Caused Issues On Next Login
TSM-2470 Unable To Close Time Series Search When Invalid Data Source Was Selected
TSM-2489 After Searching For Time Series Using Data Source "ZAMS" No Other Data Source Can Be Selected
TSM-2498 The aggregation rule, start of day and year are not taken into account
FW-2574 Switching Between Search Tab and Edit Tab causes Error
FW-2616 System Attributes Not Exported When Using The Master Data Export
FW-2207 Webhooks Are Registered Even Though Disabled in HAKOM.Config
FW-2374 Cookie-based authentication not possible when service behind reverse proxy server
FW-2407 WebTSM Services: Logging levels "Debug" and "Verbose" don't work
FW-2473 Verification Of Tokens By Integrated Identity Provider Is Case Sensitive
FW-2477 Error Using A Service Extension Using .NET Core
FW-2499 Unused Language Resources
FW-2502 Authentication Does Not Work Without Path in Integrated Identity Provider endpoint configuration
FW-2212 Webhooks: $RequestContent of POST /timeseries/{ID|name}/attributes is always empty
FW-2580 Errors in Documentation
FW-2498 PostgreSQL: Error When Saving Data With Many Decimal Digits
FW-2506 Wrong Status Code For Incorrect Webhook Registration
FW-2509 Error When Attempting to Register WebHook

v3.8.3

Important Changes

FW-1978 Optimize Performance and Memory Utilization by Revising Database Indices
FW-2326 Default Values for Setting: MaxNumberOfDataItem
FW-2425 Support For Current Database Versions
FW-2385 WebTSM Services: Call endpoint for integrated identity provider with Basic Authentication

New Features

FW-1978 Optimize Performance and Memory Utilization by Revising Database Indice
FW-2326 Default Values for Setting: MaxNumberOfDataItems
FW-2421 Update of Third Party Libraries
FW-2425 Support For Current Database Versions
FW-2189 API: Defining the Behavior of TimeSeriesRepository.Load with Period and Without Period
FW-2292 DataInterface: Console Should Report the Overwriting of Files
TSM-2294 TSM Visuals: Default Values for Dashboards and Editing Data in TSM Visuals
TSM-2379 Speed up TSM Setup
TSM-2181 Confirmation to save Changes When Closing Time Series Search
TSM-2270 Modernizing The TSM User Interface
TSM-2271 Modernize Charts
TSM-2294 TSM Visuals: Editing Data in TSM Visuals

Fixed Bugs

FW-2228 DataInterface: CSV Export Overwrites Export File If Export Period Is Longer than One Week
FW-2369 Oracle: Error when inserting etries into FWS_PROTOCOL
TSM-2216 TSAA Aggregation Does Not Assign Flags Correctly
FW-2290 DataInterface: Console Shows Wrong Number of Exported Time Series If They Are Separated by Columns
FW-2309 Problem When Creating a New Extension for the WebTSM Services
FW-2405 Framework API: Saving a Subset of Data Leads to Errors
FW-2420 Formula Time Slices Are Not Recognized If No Time Slice Is Available Starting on 01.01.1972.
TSM-2307 Error When Creating a Time Series with InternalTimeUnit Configured to 2 and accessing a Database Not Set Up for Milliseconds
FW-2427 SQL Server: TSAA Formula Does Not Work for Attribute Names with More than 50 Characters
TSM-1982 Roll Out: Sundays Have Day Type 7 and Therefore Behave like Public Holidays.
TSM-2111 Calendar Plug-in: Invalid Values Are Not Being Shown
TSM-2195 Sequence for Navigating Through Tsm Using the Tab Key Is Not Intuitive
TSM-2203 Many Error Messages Not User-friendly
TSM-2227 Username Is Not Displayed When Reading with Audit
TSM-2268 Small Deviations When Using Milliseconds
TSM-2279 TSM Does Not Support Conditional Formatting in Some Environments
TSM-2282 ZAMS Plug-in: Error When Copying from the Search Drop-down List Using Ctrl+C
TSM-2364 Error When Opening TSM from an Invalid Template
TSM-2380 Miscalculation When Using Time Zone "LT24" across a DST change
FW-2399 Too Many Change or Quotation Timestamps Are Displayed
FW-2105 WebTSM Services: Some Error Messages Are Displayed in German
FW-2230 WebTSM Services: Quotation Time Series Cannot Be Created Implicitly
FW-2301 WebTSM Services: Missing error message for invalid system attributes
FW-2319 WebTSM Services: Error When Reading Data Modifications with QuotationDefaultBehavior "MaxExact"
FW-2403 WebTSM Services: Error When Reading Data with Interval "Total"

v3.8.2

Important Changes

FW-1848 Allow Authentication With 3rd Party Identity Providers
FW-2173 Add Log File Flexibility
Authentication
User management

New Features

FW-1371 Extend Error Logging
FW-2179 Create Database Script for New Installation as of 3.8.
FW-2178 SQL Server: Remove Duplicate Index ID_TIMESERIES1
TSM-1559 Attributes: Name Should Not Begin/End with Spaces
FW-2197 Saving Split Time Series Data
TSM-2082 Signing Setup.exe, Addin.dll and TSMplus.exe
TSM-2106 Make FlagNames Language-dependent
TSM-2109 Create Excel Template for Readout in Milliseconds
TSM-2136 Make Control Commands Language-independent
TSM-2171 Make the Display of Flags in the Excel Context Menu Configurable
FW-2164 Changing the Description of a Time Series Should Create an Archive Entry
TSM-1830 Assignment of Attributes Based on the Attribute Name
TSM-1997 Autocompletion When Entering the Time Series Name in the ZAMS Plug-in
TSM-2038 Enable Access to the Help Menu Within the Time Series Search
TSM-2040 Unify German Name for Plug-in "User Management"
TSM-2052 Time Series Search: Button to Reset All Search Parameters
TSM-2074 Making Date Format Language-dependent
TSM-2151 Adjust Error Message If Attribute Parameters Are Not Available
TSM-2158 ZAMS Plug-in: Attribute Assignment via Cells B2-B8 by Name
TSM-2212 Adjust the Display of the Context Menu Entry for Flag "Schedule"
FW-1665 Remove Categories from Time Series Search
FW-1848 Allow Authentication With 3rd Party Identity Providers
FW-2045 Ability to query the changes made to a time series and its data
FW-2211 Transfer time series optionally with one or two time stamps

Fixed Bugs

FW-2177 Reduced Performance Due to Table FWT_TSDATAAUDIT
FW-2257 Filling Selection Lists for Attributes Using Reference Tables Does Not Work
FW-2276 Overflow When Calculating Formulas
FW-2115 No Error Message for Invalid Values of Quotationdefaultbehavior in HAKOM.Config
FW-2275 SQL Server: Time Series Cannot Be Deleted
FW-2278 Error When Calling the TSCA Formula with Long Attribute Names
FW-2283 Error When Using Multiple Databases
FW-2335 Error When Accessing a SQL Server Data Base
TSM-2025 Calendar Plug-in: Spelling Error When Reading a Time Series
TSM-2081 Unit Drop-down List Selects the First Item with the Specified String When It Opens
TSM-1575 Time Series Search Still Possible Despite Empty Data Source Field
TSM-1658 Master Data Import: Manual Assignment of a Time Series Id Is Possible, Although This Option Is Deactivated
TSM-1742 Graphical Display Is Not Updated When the Quotation Date Is Changed
TSM-1770 Formulas Cannot Be Deleted from the Time Series Definition Using Master Data Import
TSM-1782 Diagrams over Ribbon Show Wrong Chart Type
TSM-1818 "Add Attribute" Window Not in English
TSM-1848 Wrong Icon for "Add Attribute" Window in Taskbar
TSM-1876 Labels of the TSM Menu Unclear
TSM-1907 Batch Plug-in Window Empty, If It Was Previously Loaded in TSM via Excel Add-ins Tab
TSM-1909 Assigning the Same Attribute to the Same Unit Twice Causes Error Message
TSM-1929 Ribbon Setting Is Not Reset on Logout
TSM-1946 Adding/Deleting Assigned Conversion Time Series to a Time Series with Time Slices on Attributes Is Not Possible
TSM-2037 Warning When Changing Time Series Type Also Appears When Changing to Original Value
TSM-2039 TSM Attempts to Open Several Time Series Separated by ";" In the ZAMS Search Field as One Time Series
TSM-2041 Typo in English TSM Main Window
TSM-2042 Button "Cancel" In Task Handling Window Causes Error Message
TSM-2048 Spelling Error in the Time Series Search in English for "In Clipboard"
TSM-2049 Data Source in Time Series Search Incorrectly Translated to English
TSM-2063 Time Series Search: Switch Between "Edit" Tab and "Master Data" Tab Changes Time Series Selection
TSM-2066 Drop-down Lists Disappear When the Alt Gr Key Is Pressed
TSM-2070 Batch Plug-in: Link to German Documentation Despite English as Selected Language
TSM-2080 Diagrams Not Legible If Time Series Name Is Too Long
TSM-2110 Master Data Import - System Attributes: No Error Message for Invalid Values
TSM-2118 When Editing Time Series, Clicking New Does Not Remove the Unit
TSM-2124 Minor Shortcomings on Plug-in Masks
TSM-2131 Time Series Search: Wrongly Worded Message When Deleting Multiple Time Series
TSM-2132 Master Data Import: Error in English Notification Window
TSM-2140 Changing the Type of a Formula Time Series Causes Error Message
TSM-2141 "Interval" Drop-down List Empty When Opening a Sheet
TSM-2144 Batch Plug-in: Report Not Saved If Report Path Does Not Exist
TSM-2153 "Remove All Attributes" Not Possible If Attributes Were Assigned Using Attribute Template
TSM-2155 Log Monitor: Error Message When Type Is Selected
TSM-2160 Wrong Data Source Does Not Return an Error
TSM-2163 Typo in German Time Series Search Window
TSM-2172 Interval in Template Is Wrong after Updating Sheet
TSM-2174 Grids Smaller than 1/4h Are Not Interpreted Correctly by TSM If Milliseconds Are Activated in HAKOM.Config
TSM-2197 Ahead/Back Buttons Lead to Incorrect Time Jumps If a Time Zone Is Entered in Cell A16
TSM-2200 Grid Is Updated Incorrectly When Connected to a Millisecond Database
TSM-2207 If Time Series Sheets Are Updated with "Period from Template" And Millisecond Support Is Enabled, the Grid Will Be Changed
TSM-2217 When Creating a Time Series from the Time Series Search, the User Is Not Automatically Entered in FWS_USER
TSM-2235 "Ahead" And "Back" Buttons with Resolution "Template" Create Malfunctions
FW-2039 Error When Creating a Selection List Entry
FW-2048 Time Series Search: Unintelligible Error Message When No Database Source Is Specified
FW-2237 Error When Assigning a Unit to an Attribute If It Already Existed Before the Current Session
FW-2273 WebTSM Services won't run on Azure

v3.8.1

Important Changes

FW-1882 Deleting Time Series Does Not Work for Duplicates in the Database
FW-2051 Accessing Time Series With Only A Single Time Stamp Per Data Point
FW-2084 Support of Oracle 18
FW-2103 Running the WebTSM Services Under netcoreapp2.1 as a Windows Service
FW-2130 WebTSM Services Feature Complete under Linux
TSM-2101 Changes In How User IDs Are Determined

New Features

FW-2084 Support of Oracle 18
FW-2112 Standardization of Interval=no and Interval=null
FW-2157 Prevent Creation of Cyclic Time Series Without Interval
TSM-2003 Flag Context Menu Without MacrosFW-1882 Deleting Time Series Does Not Work for Duplicates in the Database
TSM-1868 Language Dependent Formatting Strings Cause Problems with Batch Processing
TSM-1951 Text for Language Selection at Start of Setup in English
FW-1944 WebTSM Services: PUT /timeseries/{name} With an ID in Body
FW-2051 WebTSM Services: Accessing Time Series With Only A Single Time Stamp Per Data Point
FW-2071 Enhanced Message for Bad Request (Could Not Deserialize Body)
FW-2129 Aggregation on TimeSeriesDefinition instead AggregationRule on Interval
FW-2135 Location in Response Header

Fixed Bug

FW-1882 Deleting Time Series Does Not Work for Duplicates in the Database
FW-2165 Customaction Script Default Also Deletes Archive Entries When Deleting Time Series
FW-2167 SQL Server: Error with Script HAKOM_Framework_v039_v040.sql
FW-2223 SQL Server: Error When Inserting New Database Version
TSM-2050 Formula Time Series: Functions Provide NaN for Division By 0
TSM-2062 Formula Time Series: Error in TSAA Function with Different Time Zones
FW-2006 Calling ITimeSeriesEntity.GetData Without Specifying an Interval Causes Incorrect Conversion
FW-2065 Attribute Names That Are Too Long Are Shortened Without an Error Message
FW-2120 Quotations: End Time Is Not Loaded for Spontaneous Time Series
FW-2123 MetaInfo: ToDate Is Always the Maximum Value in Case of Spontaneous Time Series
FW-2154 Failure to save Data Onto Compressed Time Series When That Data Does Not Align with the Series' Interval
FW-2162 TimeSeriesRepository.DeletedSince Returns Error When Parameter "Since" is Null
FW-2220 Data Interface Console: Unable to Export Formula Time Series
TSM-1764 Batch Plug-in: Ignore Setting "LogConnection" when TraceLevel Set to 0
TSM-1952 Selection "English" During Set-up - TSM Installation in German Anyway
TSM-1748 Flag Colors Are Not Displayed
TSM-1767 ZAMS Plug-in - Formula Time Series: Version & Quotation Version Is Not Copied to the Template When Opened
TSM-1874 Context Menu in Excel Shows No Color for Flag "Estimated"
TSM-1918 KISS-A Import: Columns That Do Not Have KISS-A Sellers or KISS-A Buyers Return a System Error
TSM-1944 Batch Plug-in: Template Will Not Be Processed at Double Hour
TSM-1972 Incorrect Behaviour During Time Change with Time Zone "LT24"
TSM-2009 Reading of Data in Seconds Grid with Active Checkbox at Time Fields
TSM-2032 Error Message Blocks Start of Excel If Comment in HAKOM.Config Is Not Closed
TSM-2067 Batch Plug-in: When Updating the Template, the Check Mark "Missing Blank" Is Cleared
TSM-2072 Calendar Plug-in: Holidays with Negative Days Will Be Deleted
TSM-2085 Error During Readout with Time Zone "LT24", If Daylight Saving Occurs in the Readout Period
TSM-2088 TSM+ Will Not Be Opened If HAKOM.Config Is Faulty
TSM-2091 Error When Reading and Saving in Russian Time Zone
FW-1661 Error When Specifying an Invalid Time as Time Slot (for Formulas)
FW-1921 Formula Check Returns an Error When "FormulaTimeSeriesDefinition" Is Used
FW-2154 Failure to Save Data That Does Not Align With The Time Series' Interval, in Compressed Time Series
FW-1633 Calculation Error with Query in Hourly Grid, but Not on the Full Hour with Aggregation = "Sum"
FW-1780 Error Message When "from" Parameter Greater Than "to" Parameter
FW-1945 Wrong Error Message for Expired License
FW-1954 Wrong Error Message If Method Is Not Supported
FW-2100 Creating Time Series: Wrong Location Header in Response When URL Has Been Rewritten by Proxy
FW-2134 Time Series with Interval=no Returns Wrong Multiplier
FW-2156 Time Series Aggregation with Time Zone UTC

v3.8.0

Important Changes

FW-1849 Events
FW-2042 Dropped Support for Media Type api-version <= 3.7
FW-1822 Linux Support
FW-1948 Support for Millisecond Intervals*
Webhooks
Dropped support for media type api-version <= 3.7
Support for millisecond intervals

New Features

FW-1807 Using Attributes in Formula Time Series
FW-2031 Improved Output when requiring manual intervention during database update.
TSM-1996 Time Series Manager Setup Now Shows the Full Version Information for the Application it Installs
TSM-2001 Full Support for Microsoft Office 365 in Combination with TSM+
FW-1948 Support for Milliseconds
TSM-1867 Master Data Export: Displaying Referenced Time Series in Formulas by Name
TSM-2010 Improved Performance During First Startup
TSM-2020 Additional Time Series Properties in Master Data Import/Export
FW-1281 Performance improvements when loading and saving time series definitions
FW-1807 New functions in formulas for accessing a time series' attributes
FW-1849 Webhooks
FW-2005 WebTSM Services: Include MetaInfo in Search Results
FW-2026 MetaInfo: DataPeriod for Quotation Time Series
FW-2027 Faster Determination of MetaInfo.DataPeriod
FW-2090 WebTSM Services: QuotationDefaultBehaviors
FW-2091 WebTSM Services: Time Zones

Fixed Bugs

TSM-2016 Batch Plug-in: File Naming
FW-1973 Data Interface Console: All Files Are Copied to Wrong Folder When One File Could Not Be Processed Successfully
FW-2010 Formula Time Series: Typing Mathematical Operators or White Space in Time Series Name Caused the List of Suggested Time Series to Include Irrelevant Results
FW-2012 Formula Time Series: Cursor Jumps to Start of Line After Closing Parenthesis or Bracket
FW-2079 Error Using Time Series beyond the year 2039
FW-2109 Error Saving Quotations
TSM-1651 Pressing F1 Does not Display the Specific Help Corresponding to the Current Context
TSM-1861 Incorrect Behavior when Loading Multiple Time Series without Specifying an Interval
TSM-1942 Missing Suggestions when Editing Formulas
TSM-1976 Semantic Error in Task Progress Window
TSM-1979 Data Validation Server: Misleading Error Message when License File is Missing
TSM-1989 Incorrect Version Information in Error Dialog
FW-1762 Unable to Change Time Zone Assignment
FW-2040 DataPeriod for Formula Time Series
FW-2047 QuotationDefaultBehavior Property Nonfunctional
FW-2059 Documentation Incomplete for Time Series Aggregation
FW-2102 Invalid Characters in OpenApi Specification
FW-2109 Quotations: Error when Creating Multiple Quotations for a Time Series Near-Simultaneously

Additional Information

Deprecation Notices

FW-2069: Formula Time Series: SUM Function deprecated
Integrated Windows & Basic authentication
Media Types <= 3.7