Version Information

Breaking Changes

Deprecation Notice

With this version it is no longer possible to use unstructured exception handling within EvalComponent files. It is now required to use a state-of-the-art approach to exception handling. See examples below.

Example Unstructured Exception Handling

VB

On Error GoTo ErrorHandling:
   ' do something
ErrorHandling:
   ' handle errors

Example State-of-the-art Exception Handling

VB

try
   ' do something
catch
   ' handle errors
end try

TSM-2697 TSM Visuals: Support for Port Range

It is now possible to define a range of ports that can be used by TSM to transmit data to the Visuals and vice versa.

The first unused port in the configured range will be used for the transmission of data. This behaviour allows for more than one user to use the Visuals on the same machine or other applications to run at the same time without experiencing problems related to blocked ports.

It is therefore no longer necessary to adjust settings in the basettingsLight.xml configuration file.

The port range can be configured using the following settings:

XML

<HAKOMConfiguration>
	<products>
		<TSM>
			<settings>
				<VisploreSenderPortRange>51101-51500</VisploreSenderPortRange>			<!-- Default: 51101 - 51500 -->
				<VisploreReceiverPortRange>52101-52500</VisploreReceiverPortRange>		<!-- Default: 52101 - 52500 -->
			</settings>
		</TSM>
	</products>
<HAKOMConfiguration>

This change means the following settings are obsolete and will no longer be supported:

XML

<HAKOMConfiguration>
	<products>
		<TSM>
			<settings>
				<VisPlorePort>50123</VisPlorePort>
				<VisPloreLightPort>50123</VisPloreLightPort>
				<VisplorePortOfClient>50123</VisplorePortOfClient>
			</settings>
		</TSM>
	</products>
<HAKOMConfiguration>

TSM-2755 Switch To .NET 5

The .NET Libraries used have been updated to version 5. This switch results in changes to the installation process. More detailed information can be found in the installation section of the documentation.

TSM-2758 Remove Obsolete Sum Methods From Formula Time Series

The following variations of the "Sum" method were previously marked as obsolete and have been removed with this release:

Sum(TimeseriesID)
Sum(ByVal Range as Array)

The functionality of the listed methods is covered by the method Sum([TimeseriesReference]) and the "+" operator respectively.

Examples:

Sum(TimeseriesID) (obsolete)

Sum(TimeseriesReference)

Sum(4711)

Sum([4711]) or

Sum([TimeseriesName])

Sum(ByVal Range as Array) (obsolete)	"+" Operator
Sum({({[1].Value, [3].Value})})	[1] + [3]

TSM-2866 WebTSM Services: Remove Endpoint /configuration

Due to security considerations, the endpoint

CODE

GET /configuration

was removed, as it is not relevant for the user and the full path of the configuration file of the service may be considered sensitive information which should not be exposed to service consumers via the API.

TSM-2905 Oracle Unmanaged Driver No Longer Supported

The "unmanaged" driver for connecting to Oracle databases from .NET is no longer supported as of this version.

Any entry in existing HAKOM.Config files must be updated to use the current driver:

Old:

XML

<HAKOMConfiguration>
  <dbconnections>
    <EXAMPLE>
      <cnn><!--DB connection string--></cnn>
      <password><!--DB password--></password>
      <provider>HAKOMOracle</provider><!-- NO LONGER SUPPORTED -->
    </EXAMPLE>
  </dbconnections>
</HAKOMConfiguration>

New:

XML

<HAKOMConfiguration>
  <dbconnections>
    <EXAMPLE>
      <cnn><!--DB connection string--></cnn>
      <password><!--DB password--></password>
      <provider>HAKOMOracleManaged</provider>
    </EXAMPLE>
  </dbconnections>
</HAKOMConfiguration>

TSM-2992 WebTSM Services: Remove Obsolete Query Parameters "dateFormat" And "format"

The query parameters "dateFormat" and "format", which were available for various requests, have been replaced by the media type parameters "dateFormat" and "format". The media type parameters provide the same functionality as the query parameters did.

TSM-3153 WebTSM Services: Remove Parameters "dateFormat" And "format" From POST /.../calculations Request Body

The parameters "dateFormat" and "format" for the request

CODE

POST /repositories/{repository}/calculations

are no longer contained in the request body. The media type parameters "format" and "dateFormat" provide the same functionality and should be used instead.

TSM-3265 New Fields for Audit, Compressed and Quotation Time Series

The following new fields have been introduced have been added to time series master data:

Audit
Compressed
Quotation

With these fields it is possible to configure a time series as an audit time series, a compressed time series or a quotation time series respectively. Any combination of the listed configurations is possible. It is no longer possible to control time series behavior by assigning specific table names.

Please make sure to always set these properties accordingly regardless of the assigned table names.

Corresponding changes have been made to the TSM App as well as the Master Data plug-in.

TSM-3266 WebTSM Services: Remove Endpoints "/users" And "/roles"

The endpoints /users and /roles have been moved and are now located here:

CODE

/auth/providers/hakom/users

CODE

/auth/providers/hakom/roles

Using these endpoints provides the same functionality as before.

TSM-3348 WebTSM Services: Remove Obsolete Parameters 'type>' And 'type<'

The obsolete parameters "type>" and "type<" have been been removed. The same functionality is provided by the two new query parameters "minType" (corresponds to "type>") and "maxType" (corresponds to "type<").

TSM-3373 WebTSM Services: Remove Obsolete Parameters 'Limit' And 'Offset'

The query parameters "limit" and "offset" for the request

CODE

GET /repositories/{repository}/timeseries

have been marked as deprecated in a previous version and have now been removed. The range header should be used instead in order to control the amount of timeseries returned for such a request.

TSM-3378 WebTSM Services: Remove Obsolete API Versions

API versions up to and including version 3.8.7 are no longer supported by this release and can therefore no longer be passed as the "api-version" parameter in the Accept and Content-Type headers.

TSM-3482 Changes to the Master Data Plug-In for Audit, Compressed and Quotation Time Series

The Master Data Plug-in has been modified to include the new fields "Audit", "Compressed" and "Quotation" when importing or exporting time series master data. When importing,the fields have to be present and contain either "TRUE" or "FALSE" as values.

Unlike in previous versions the table names for "Table" and "Archive Table" do not have to be configured when importing time series master data. If left empty, appropriate default values will be used for these fields depending on the configuration of "Audit", "Compressed" and "Quotation".

TSM-3532 Time Zone Parameter for Calculations

When calculating time series data via the endpoints

CODE

GET /repositories/{repository}/calculations

CODE

POST /repositories/{repository}/calculations

the results were calculated based on the time zone the service was hosted in.

As this behaviour led to unexpected results in some cases a new parameter has been introduced: timeZone. With this parameter it is possible to control the time zone a calculation will be executed and the results returned in.

For the request

CODE

GET /repositories/{repository}/calculations

the parameter is available as a query parameter, while for the request

CODE

POST /repositories/{repository}/calculations

it needs to be included in the request body for each individual calculation.

Features

TSM-3118 Improve Performance of Working With Attributes

By restructuring how time series attributes are stored in the database, overall performance when working with many attributes has been improved (e.g. querying or aggregating time series by their attributes).

Since this change to the database will affect attributes assigned to objects other than time series (a feature rarely used), a check script is provided and must be run before updating the database from a previous version. Any entries returned by the script (attribute assignments to objects other than time series) need to be adjusted before the database update in order to avoid any loss of data. The script ist located in the folder "\Database Scripts\{Database Type}\V3.9.0\V3.9.0.0\Manual scripts before upgrade" of the installation package.

TSM-3340 Improved Performance When Reading/Writing Time Series Data

By optimizing how databases are accessed from within the WebTSM Services, a gain in speed when reading and writing time series data using the WebTSM Services has been achieved. This affects the following requests:

CODE

GET /repositories/{repository}/timeseries
GET /repositories/{repository}/timeseries/{ID}
GET /repositories/{repository}/timeseries/{ID}/data
POST /repositories/{repository}/timeseries/{ID}/data
GET /repositories/{repository}/timeseries/{name}
GET /repositories/{repository}/timeseries/{name}/data
POST /repositories/{repository}/timeseries/{name}/data

TSM-3341 Improve Performance of Accessing HAKOM.Config

By modifying the way the HAKOM.Config file is accessed it was possible to reduce the number of times the file has to be read from the disk, resulting in a small overall performance gain.

TSM-3375 Overhaul of the Open Api Schemes

The schema definitions used for various types within the Open API specification have been revised and renamed for better readability. This particularly improves the automatically generated client code due to more intuitively named classes.

TSM-3473 CSV Import: Checksum Line Causes Failed Import

If the file to be imported contained a control line that should have been ignored by the import, this line was interpreted as a row that should be imported and error messages occurred.

Two new settings for import configuration files have been created:

XML

<HAKOMConfiguration>
	<products>
		<Name_Konfiguration>
			<settings>
				<StopImportAtEmptyRow>true/false</StopImportAtEmptyRow>		<!-- Controls whether the import will abort in case of an empty line -->
				<SkipLineRegex>Kontrollsumme.*</SkipLineRegex>				<!-- Regular Expression to identify rows that should not be imported -->
			</settings>
		</Name_Konfiguration>
	</products>
</HAKOMConfiguration>

With the help of the settings documented here, it is possible to stop the import at the first blank line that is encountered by setting <StopImportAtEmptyRow> to "true". This results in control lines that are contained in the import file to not cause any error messages, provided that there is a blank line before the control line.

The <SkipLineRegex> setting can be used to define a regular expression in order to ignore certain (matching) lines in the import file. The usual control characters or wildcards for regular expressions can be used.

TSM-3483 TSM App: Changes to the GUI for Audit, Compressed and Quotation Time Series

Whether a time series supports auding or quotations and whether it's data is stored in a compressed manner is no longer configured by its assigned table names. Instead, checkboxes have been added to the GUI allowing for easier configuration of a time series behavior.

The checkbox "Audit" must be activated in order to configure a time series as an audit time series
The checkbox "Quotation" must be activated in order to configure a time series as a quotation time series
The checkbox "Compressed" must be activated in order to configure a time series as a compressed time series
The checkbox "Audit" does not have to be activated for quotation time series
The fields "Table" and "Archive Table" can be left empty if the default data table and archive data table should be used

Fixed Bugs

TSM-3398 Data Interface Console: Error Messages for Missing Time Series Despite Setting <IgnoreMissingTimeSeries>

Error messages were returned for any time series that was defined in the import configuration file but not present in the import file, even if the dedicated setting <IgnoreMissingTimeSeries> was configured as "true".

The problem was fixed and by setting

XML

<HAKOMConfiguration>
	<products>
		<Name_Import_Configuration_File>
			<settings>
				<IgnoreMissingTimeSeries>true</IgnoreMissingTimeSeries>
			</settings>
		</Name_Import_Configuration_File>
	</products>
</HAKOMConfiguration>

no error messages will be returned in these cases.

At the same time, the entries in the log monitor have been improved to be more precise.

TSM-3454 Properties Are Case Sensitive

When setting any property to a specific value it was necessary to use the exact spelling and casing of the property name as it was in the response. If a different casing was used the default value was saved instead.

Example:

Setting property "TimeZone" via POST/PUT request:

CODE

POST /repositories/{repository}/timeseries

Request body contains: "Timezone": "UTC"

The corresponding property in the response is spelled "TimeZone" and because of the different spelling the TimeZone property would be set to null.

This behaviour has been adjusted and all properties are now case insensitive.

TSM-3453 Renaming Time Series Creates Duplicate

When renaming a time series via a

CODE

PUT /repositories/{repository}/timeseries/{ID}

request, a duplicate time series with a new ID was created instead of renaming the referenced time series. This error has been corrected and the renaming of time series now works as expected.

TSM-3407 Error When Hosting WebTSM Services on Azure

When hosting the HAKOM WebTSM Service on Azure an exception was thrown when trying to start the service. The problem has now been corrected by changing the configured hosting model in the default "web.config" file to "OutOfProcess":

XML

<configuration>
  <location path="." inheritInChildApplications="false">
    <system.webServer>
      <aspNetCore 
        processPath="dotnet" 
        arguments=".\HAKOM.Framework.Services.dll --run" 
        stdoutLogEnabled="false" 
        stdoutLogFile=".\logs\stdout" 
        hostingModel="OutOfProcess" 
      />
    </system.webServer>
  </location>
</configuration>

TSM-3488 CSV Import: Import Files Are Mistakenly Moved to Error Directory

Under certain conditions, the files that were successfully imported were subsequently moved to the directory specified for failed imports by mistake. This behavior has been corrected, and the import files are now moved to the directory specified for successfully processed imports as expected.

TSM-3497 CSV Import: Specific Warning in Case of Incorrect Values in the Import File

If the file to be imported contained faulty values in a column intended for data, a non-specific error message was shown and the execution was terminated with the generic error code -1.

The error handling has been improved. Now the warning "Incorrect value in column [column number]" is shown, along with a corresponding warning for each row containing an incorrect value. The error code in case of such an error, corresponds to the ID of the import call.

Version History

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