Skip to main content
Skip table of contents

Version Information

Breaking Changes

TSM-2895 Upgrade PostgreSQL Support

PostgreSQL 9.5 is no longer supported by its maintainers. To reflect this, HAKOM products now only support PostgreSQL versions 11 and up.

Features

TSM-2286 Master Data: Default Table Should Be "Attributes"

When switching to the tab "Master data" in the TSM App the table displayed by default is now "Attributes". Another table "Attribute → Entity Assignment" has been removed from the user interface as it provided no additional functionality.

TSM-2590 TSM App: Allow Hiding of Advanced Parameters

There are quite a few parameters to choose from when loading a time series. In order to simplify the user interface, some of the more advanced parameters have been grouped together in a collapsible field called "parameters".

TSM-2731 WebTSM Services: Live and Ready Health Checks

Health checks have been implemented for the HAKOM WebTSM Services. For configuration options two new HAKOM.Config settings have been introduced:

XML
<HAKOMConfiguration>
    <products>
        <WebTSMServices>
			<HealthChecks>
				<DegradedMemoryAllocationLimit></DegradedMemoryAllocationLimit>		<!-- Default: unlimited -->
				<UnhealthyMemoryAllocationLimit></UnhealthyMemoryAllocationLimit>	<!-- Default: unlimited -->
			</HealthChecks>
       </WebTSMServices>
    </products>
</HAKOMConfiguration>

Using the new health checks it is now possible to evaluate the status of a service via the following requests:

CODE
GET /health/live

This request will return

  • Healthy, if the service is running or
  • Unhealthy, if the service is offline
CODE
GET /health/ready

This request will return Healthy if the following conditions are met:

  • IntegratedIdentityProvider is enabled and the connection configured for <USERMANAGEMENT> is reachable
  • All database connections configured in the HAKOM.Config are reachable
  • IdentityProvider is reachable (if configured)
  • Configured UnhealthyMemoryAllocationLimit is not exceeded

If one of the listed conditions are not met, the request will return "Unhealthy"

TSM-2984 PostgreSQL: Scripts for Linux

New power shell scripts are available for installing or updating HAKOM databases on a Linux machine. These scripts are located in the folder: Database Scripts\PostgreSQL

TSM-3002 WebTSM Services: Configurable Details in Error Messages

Error messages returned by the WebTSM Services used to include details which should not necessarily be exposed in a production environment. The level of detail reported by the service is now configurable:

XML
<WebTSMServices>
    <Response>
        <IncludeInternalServerErrorDetails>true/false</IncludeInternalServerErrorDetails>	<!-- Default: false -->
    </Response>
</WebTSMServices>

TSM-3079 WebTSM Services: Environment Variables for Dockerized Deployments

For dockerized deployments of the HAKOM WebTSM Services it is now possible to use environment variables for configuring and licensing a service instead of providing a HAKOM.Config and HAKOM.License file via the mount command.

Detailed information on environment variables in docker may be found here: https://docs.docker.com/engine/reference/run/#env-environment-variables

HAKOM.Config

Any setting and even entire setting subcategories may be provided as an environment variable. The name of an environment variable must correspond to the location of a setting in the HAKOM.Config file.

XML
<HAKOMConfiguration>
	<products>
		<WebTSMServices>
			<Hosting>
				<Url>http://127.0.0.1/</Url>
			</Hosting>
		</WebTSMServices>
	</products>
</HAKOMConfiguration>

This setting can be configured by the environment variable

CODE
"HAKOMConfiguration_products_WebTSMServices_Hosting_Url=http://127.0.0.1/"

By assigning XML tags as the value of an environment variable it is possible to set up multiple configurations:

XML
<HAKOMConfiguration>
	<products>
		<WebTSMServices>
			<Authentication>
				<IntegratedIdentityProvider>
					<ValidClients>
						<Client>
							<Id>TestClient</Id>
							<Secret>Password</Secret>
							<User>TestUser</User>
						</Client>
						<Client>
							<Id>TestClient2</Id>
							<Secret>Password2</Secret>
							<User>TestUser2</User>
						</Client>
					</ValidClients>
				</IntegratedIdentityProvider>
			</Authentication>
		</WebTSMServices>
	</products>
</HAKOMConfiguration>

This configuration may be replaced by the environment variable:

CODE
"HAKOMConfiguration_products_WebTSMServices_Authentication_IntegratedIdentityProvider_ValidClients=<Client><Id>TestClient</Id><Secret>Password</Secret><User>TestUser</User></Client><Client><Id>TestClient2</Id><Secret>Password2</Secret><User>TestUser2</User></Client>"

HAKOM.License

The functionality and structure of environment variables is identical to that of HAKOM.Config settings however it is only necessary to provide the following three entries:

HAKOM.License TagEnvironment Variable
XML
<HAKOMLicensing>
  <customer>TestCustomer</customer>
</HAKOMLicensing>
CODE
"HAKOMLicensing_customer=TestCustomer"
XML
<HAKOMLicensing>
	<products>
		<product>
			<name>TestProduct</name>
		</product>
	</products>
</HAKOMLicensing>
CODE
"HAKOMLicensing_products_product_name=TestProduct"
XML
<HAKOMLicensing>
	<products>
		<product>
			<licensekey>123123123</licensekey>
		</product>
	</products>
</HAKOMLicensing>
CODE
"HAKOMLicensing_products_product_licensekey=123123123"

More than one product can be licensed by using XML tags as values for the environment variables as described above.

TSM-3155 PostgreSQL: Changes in configuration.ini

Due to required privileges to run update scripts for PostgreSQL, some changes were made in the configuration.ini. The most important changes are:

  • "dbuser" changed to "dbowner"
  • "dbuser_password" changed to "dbowner_password"

TSM-3177 WebTSM Services: Authorization Caching

Authorization rules stored in the database may now be cached locally in order to reduce database calls and consequently improve the performance of WebTSM Service requests.

New HAKOM.Config settings allow for the configuration of authorization caching:

XML
<HAKOMConfiguration>
	<products>
		<WebTSMServices>
			<Caching>
				<Expiration>00:01:00</Expiration> <!-- Default: 01:00:00 one hour -->
				<Enabled>true</Enabled> <!-- Default: true -->
			</Caching>
		</WebTSMServices>
	</products>
</HAKOMConfiguration>

The authorization cache expires after a configurable time period. The expiration timer starts when

  • a cache entry is created or
  • a cache entry is overwritten

Changes to authorization rules (creating, updating or deleting one or more rules) result in an immediate reset of the cache.

TSM-3233 WebTSM Services: Add StartOfDay and StartOfYear Parameters To Calculations

When performing calculations using the WebTSM Services 

CODE
/repositories/{repository}/calculations

endpoint, two new parameters have been added:

  • StartOfDay (The hour that marks the beginning of a day, default = 0)
  • StartOfYear (The month within a calendar year that marks the beginning of the year, default = 1)

Adjusting these parameters affects the way data is calculated and returned when specifying an interval greater than or equal to one day.

TSM-3277 WebTSM Services: GET Method for repositories/{repository}/timeseriescollections/attributes/{attributeID}

A new request has been implemented:

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

With this request it is possible to read a single attribute, identified by it's ID, from a collection of time series.

TSM-3300 Rename ZAMS Plug-in to Time Series Plug-in

Historically, the core TSM plug-in used for basic time series management has been named "ZAMS" (a german acronym dating to the very beginnings of HAKOM). In order to make things more easy to understand, especially to our growing number of international clients, this has now been renamed and will from here on be referred to as the "time series plug-in".

TSM-3315 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.

TSM-3328 WebTSM Services: Improve the Way Logging is Configured

Previously, any configuration relating to how the WebTSM Services logged messages has been done by specifying attributes on the

XML
<HAKOMConfiguration>
    <products>
        <WebTSMServices>
       </WebTSMServices>
    </products>
</HAKOMConfiguration>

Element. Since the number of configurable options has increased substantially over the last few versions, this part of the configuration has become a bit cluttered. In order to improve readability of the configuration file, the HAKOM.Config file now has a separate section for configuring the logger:

XML
<HAKOMConfiguration>
    <products>
        <WebTSMServices>
            <Logging>
               <Format></Format>
               <Level></Level>
               <DbConnections></DbConnections>
               <DbCommands></DbCommands>
               <File>
                  <Path></Path>
                  <SizeLimitBytes></SizeLimitBytes>
                  <RollOnSizeLimit></RollOnSizeLimit>
                  <RollingInterval></RollingInterval>
                  <RetainedCountLimit></RetainedCountLimit>
               </File>
            </Logging>
        </WebTSMServices>
    </products>
</HAKOMConfiguration>

TSM-3343 PostgreSQL: Script to Create Initial Database

A script is now available to create a new HAKOM TSM PostgreSQL database in one step. The script "install-latest.ps1" is located in the folder: Database Scripts\PostgreSQL

TSM-3562 Performance Improvement for Time Series Search

The performance of the time series search has been improved by removing checks for audit times when they are not necessary.

TSM-3614 Remove References to ZAMS

ZAMS is a german acronym dating back to the beginnings of HAKOM and has been used throughout our software for historical reasons. This release changes that by replacing it in numerous locations with more fitting terms such as TSM or Time Series.

This causes some changes to configuration files and data deployed with a default installation of our products.

TSM-3621 WebTSM Services: Time Zone Transformation

Up until now when reading data from one or more time series, the time zone that was used to retrieve data and calculate aggregations, was either determined by the time zone of the service host for "/sum" endpoints or by the time series master data for "/data" endpoints.

It is now possible to include a time zone in all relevant requests via a new "timeZone" query parameter. The specified time zone consequently serves as the basis for reading data and performing calculations. This change affects the following endpoints:

CODE
GET /repositories/{repository}/timeseries/{ID}/data
GET /repositories/{repository}/timeseries/{Name}/data
GET /repositories/{repository}/timeseriescollections/data
GET /repositories/{repository}/timeseriescollections/data/sum
GET ​/repositories​/{repository}​/trees​/{ID}​/sum
GET ​/repositories​/{repository}​/trees​/{name}​/sum
GET ​/repositories​/{repository}​/trees​/{ID}​/nodes​/{nodeID}​/sum
GET ​/repositories​/{repository}​/trees​/{name}​/nodes​/{nodeID}​/sum

If no time zone and unit parameters are provided, aggregations are performed using the time zone of the service host when requesting from "/sum" endpoints or using the configured time zone of the relevant time series when requesting from "/data" endpoints. Aggregations without time zone and unit parameters require all involved time series to share the same unit and interval as well as the same time zone as the service host in order for the calculation to be performed properly.

TSM-3631 WebTSM Services: Improved Error Message When Attempting to Write Data onto A Formula Time Series

When attempting to write data onto a formula time series, which by design does not hold data itself, a misleading error message was returned. The response has been improved and now includes a more specific error message.

TSM-3638 TSM App: Add Warning Message When Attempting to Load a Simple Time Series With Quotation Date

When loading a time series that does not have quotations enabled with a specific quotation date/time, a warning message is now displayed in the "Task Progress" window letting the user know that the time series has been loaded without quotations.

TSM-3711 WebTSM Services: Extend the Time Series Data Format "TimeStamp" to Include Time Zone

It is now possible to include a time zone for requests that use the TimeStamp format. All responses containing time series data of the format "TimeStamp" will include a time zone as well.

In case a requests contains no time zone, depending on the use case either the time zone configured for the relevant time series or the time zone the WebTSM Service is running in will be applied - whichever is more feasible.

Example

In this example the request contains the time zone relevant to the data in line 7:

CODE
POST /repositories/{repository}/timeseries/{ID}/data
YML
{
    "Interval": {
        "Value": 1,
        "Multiplier": 3600
    },
    "Unit": "kWh",
    "TimeZone": "W. Europe Standard Time",
    "Data": [
        {
            "From": "2021-01-01T00:00:00Z",
            "Value": 10,
            "Flag": 9
        },
        {
            "From": "2021-01-01T00:00:00Z",
            "Value": 11,
            "Flag": 9
        }
    ]
}

TSM-3754 Configurable Behaviour When Adding and Deleting Time Periods in TSM Templates

A new HAKOM.Config setting has been created to make the behaviour of Excel formulas configurable when extending or reducing the time periods contained in TSM templates. This applies to time period changes due to an adjustment of the from and to dates as well as changes resulting from adjusting the interval.

The behaviour is controlled by the following new setting:

XML
<HAKOMConfiguration>
  <products>
    <TSM>
     <settings>
      <UpdateSheetFormulasOnTemplateUpdate>true/false</UpdateSheetFormulasOnTemplateUpdate> <!-- Default: false -->
     </settings>
    </TSM>
  </products>
</HAKOMConfiguration>

If the setting is set to true, changes to the time period are automatically taken into account in all corresponding Excel formulas as new rows are inserted into the template instead of populating existing rows or, if the time period is reduced, rows are deleted instead of just the contents being emptied.

With the setting set to false, no lines are inserted or deleted, contents are only inserted or emptied and therefore the affected formulas are not automatically adjusted. When adding rows, this can lead to existing contents in the template being overwritten.

The following restriction must be considered: If the read-out time period was reduced to a single line at one point (e.g. read-out period one day in a daily interval), only the bottom row is taken into account in the formula for every subsequent extension of the read-out period. This is a technical limitation; an improvement is not possible at the moment.

It is also possible to overwrite the setting defined in the HAKOM.Config using Defined Names in order to create different settings for individual Excel workbooks or even individual Excel worksheets. For this purpose a Defined Name must be created with the name of the setting and the desired value true/false.

The hierarchy for the application of the setting is as follows:

  1. Defined Names in worksheet
  2. Defined Names in workbook
  3. HAKOM.Config

All information described here applies to the use of the TSM MS Excel Add-in as well as to TSM+.

TSM-3760 Improved Update Script for PROTOCOL Tables on MS SQL Server

The performance of the update script for PROTOCOL tables has been improved for MS SQL Server databases.

Fixed Bugs

TSM-2784 WebTSM Services: /repositories/{repository}/timeseries?interval=No Returns All Time Series

As a result of the way time series without an interval were stored in the database, a request for time series with the query parameter "interval=No" returned all time series from the database (any filtering of time series by other query parameters still applied). This has been corrected and the interval "No" is now stored properly and can be used to filter time series.

TSM-2823 WebTSM Services: Error Message for Missing URL in HAKOM.Config Was Not Logged

In case no URL was configured in the HAKOM.Config the corresponding error message was not logged and an error occured. This behaviour has been corrected and a proper error message will now be returned.

TSM-3319 Automation Plug-In: Default Values for HAKOM.config

New default values have been defined in HAKOM.config. It is possible to use the Automation plug-in or the Automation Server without specific HAKOM.config settings.

TSM-3639 Error Message If Enums in the Request Body Were Passed as Strings

Some parameters (eg. intervals, flags,...) may be submitted via the request body as either an integer, using the ID of the corresponding name, or as a string by submitting the name of the enum. As of a recent change, the parsing was no longer working correctly when trying to pass these parameters as strings. The bug has been fixed and it is once again possible to submit enum parameters as strings.

Example:

Line 5, Passing an enum parameter via ID

XML
{
    "Name": "MyFirstTimeSeries",
    "Type": 2,
    "Interval": {
        "Value": 2,
        "Multiplier": 15
    },
    "Unit": "KWh"
}

Line 5, Passing an enum parameter as a string

XML
{
    "Name": "MyFirstTimeSeries",
    "Type": 2,
    "Interval": {
        "Value": "Minute",
        "Multiplier": 15
    },
    "Unit": "KWh"
}

TSM-3650 Correction in Script connect_SYSTEM.sql

A bug in the script connect_SYSTEM.sql led to errors during execution because of insufficient permissions. The script has been corrected.

TSM-3653 TSM App: Empty Line Is Added by Mistake

TSM templates containing a time series with data in the time zone "Western European Standard Time" added an empty line at the bottom, after the last value, when the template was updated using the time zone "UTC". This error has been fixed.

TSM-3657 WebTSM Services: Wrong Format for MetaInfo

The MetaInfo, which is included in a requests response for the endpoints

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

as well as for requests to the endpoint

CODE
/repositories/{repository}/timeseries

with the query parameter "includeMetaInfo" set to "true", was provided in the wrong format and included redundant information. The problem has been fixed and the MetaInfo is now being returned properly.

TSM-3672 WebTSM Services: Internal Server Errors Are Not Logged

For Internal Server Errors only the status code 500 was displayed in the log file as well as in the console but no error details were included. This bug has been fixed.

TSM-3758 OutOfMemory Exception When Loading Formula Time Series

When loading formula time series with formulas containing a lengthy chain of time series references, it led to long loading times and in some cases to error messages. The problem in the time series cache that caused this behaviour has been corrected and the performance of such loading processes has been significantly improved, which means that error messages no longer occur.

Version History

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


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.