Invantive(R) Basics
Invantive Basics enables multi-platform implementations of Invantive SQL
Created: 08/04/2021 06:56:09 (UTC, deploy002)
Version: 20.0.148
State: Production
MSI Product ID: df465ee1-adaa-4aed-ba39-3d6b8961a42c
Manufacturer: Invantive Software B.V.
Brand: Invantive
Copyright: (C) Copyright 2004-2021 Invantive Software B.V., the Netherlands. All rights reserved.
Category: Business
Software Requirements:Included Components:
Version 20.0.147, released 2021-03-10. Bug fixes: - Set session I/O uid. Version 20.0.124, released 2020-11-18. Bug fixes: - Do not crash when an invalid value is specified for INVANTIVE_TRACE*. Version 20.0.118, released 2020-11-15. Enhancements: - Allow use of 0 and 1 for itgenrst0xx check configuration on environment variables. Version 20.0.117, released 2020-11-07. Bug fixes: - Improve license present determination. Version 20.0.114, released 2020-11-06. Enhancements: - Memorize last action. Version 20.0.112, released 2020-11-05. Enhancements: - Add local exit logging. Version 20.0.108, released 2020-10-30. Enhancements: - Add option to close application on console menus. Version 20.0.94, released 2020-09-25. Enhancements: - Improve message on "Key not in a valid state". - Add OS version to trace log to ease analysis of issues. Bug fixes: - Improve Windows 10 detection. Version 20.0.50, released 2020-07-27. Enhancements: - Add new_time SQL function and support a wide variety of time zones Version 20.0.49, released 2020-07-14. Bug fixes: - Control: Add check workbook structure tool button to check if all required worksheets are registered. - Control: Add check workbook structure tool button to check if all required worksheets are registered Version 20.0.45, released 2020-07-03. Bug fixes: - Avoid duplicate inclusion of error. Version 20.0.29, released 2020-05-22. Enhancements: - Improve determination of environment variable values on ASP.Net CORE. Bug fixes: - Improve concurrency of URL lob cache and other caches by name. Version 20.0.25, released 2020-05-10. Enhancements: - Reduce length of disk cache file names. Version 20.0.18, released 2020-05-02. Enhancements: - Differentiate discovered database per version. Version 20.0.14, released 2020-04-20. Bug fixes: - Do not start monitor; AWS code does not check whether it was started previously and it autostarts. Version 20.0.12, released 2020-04-10. Enhancements: - Add exception class for SQL failures. - Increase trial duration from 30 to 90 days. - Disable TLS 1.1 support. SSL and TLS 1.0 were already disabled in 2018. - Update to .NET Core 3.1. - Update Open Data license keys to include Producer Runtime. - Add AccountView.net [ITGEN-4652]. - Add Interbase. - Improve performance of Invantive Control tables. - Bridge Online provider. - Disable Data Replicator on synchronize statement. - Fine-tune messages for locations where Invantive services are not available. - Clarify license encryption error message itgenale013. - Indicate that encrypted value is a license key instead of the default 'password' text on decryption failure. - Use separate keychain for V2 encryption to allow mutual use of old and new releases on one device - Ignore more disk cache encryption problems. - Measure duration of encrypt/decrypt operations for HTTP disk cache. - Improve symmetric encryption - Allow use of custom RSA key for encrypting long messages. - Allow use of custom RSA implementation by setting environment variable INVANTIVE_RSA to "INVANTIVE". - Add Outlook provider. - SQL: Add htmltable table function. - Breadcrumbs and translations. - Include global state in event arguments to improve window ownership. - Allow specification of data container alias to derive IUID from in settings.xml on database level using 'iuidSource' attribute. - Improve null value handling from/to base64 encoding. - Add Mac OSX support. - Add analysis features for HTTP disk cache usage per connector in data dictionary. - Allow check on maximum length of file name and path combined. - Add Cloud API. - Restrict number of times a user message is displayed in client editions. - Add header to Invantive encryption of long messages in IVEC0001 format. - Split cache files for HTTP disk cache and Data Cache. - Allow specification of iiid, osuser, sessionid and frontenduser in configuration environment variables. - Register OData4 URL processed by Bridge Online [ITGEN-4305]. - Added state constructor methods for ASP.NET and ASP.NET Core. - Memorize content type of HTTP requests. - Differentiate between maximum accepted and maximum desired URL length for HTTP-based platforms. - Improve licenses on Linux. - Upgrade components. - Improve performance by reduced use of DateTime.Now. - Allow separate specification of folder with database specifications. - Display partition code in error message [ITGEN-3990]. - Include SQL fragment causing error in error message. - Differentiate MIME type for Content-Type and Accept header. - Improve error message on invalid content for decryption. - Add utility for parallel tasks with aggregated exceptions. - Add global support by basing times of Data Replicator on UTC instead of local time. - Allow specification of billing reference. - Upgrade to Microsoft.net 4.7.2. Bug fixes: - Remove checks itgenilr005 and itgenilr006. - Exclude reference to ClickOnce from license mail. - Add license and object property checks on synchronize statement. - Default current page number to 1 when determining the next page URL. - Improve defaulting of license limits to null instead of 0 to fix itgenyst007 in Data Replicator. - Avoid InvalidCastException during error handling. - Simplify aggregate exceptions when possible. - Improve compatibility of RSA keys between .NET Standard and .NET Framework. - Avoid IndexOutOfRangeException during thread abortion on compression. - Change default date format for Excel exports from US to EU format. - Also deliver messages from last 15 seconds of session to Customer Service. - Load and check license [ITGEN-4399]. - Avoid ObjectDisposedException during exception handling. - ProcessQueuedMessages runs multiple times in parallel when Power BI retrieves multiple data sets in parallel from Invantive Bridge Online [ITGEN-4303]. - Improve thread-safety of concurrent dictionaries. - Delay Customer Service when calling sender repeatedly [ITGEN-4281]. - Improve .NET Core compliance. - Avoid "Collection Modified" error when querying Audit trail messages. - Allow use of direct trace during tear-down phase. - Correct clock measurement against atomic clock. - Fix NullReferenceException in HTTP caches when answer could not previously be stored. - Fix race condition in anonymizing URL. - Fix serialization issue after obfuscation. Version 17.30.20, released 2019-01-08. Enhancements: - Add automatic time correction based upon Internet time of Invantive servers. - Include fetch parameters in session I/O logging. - More diagnostics on Invantive Keychain issues. - Reduce clock duration on dependency injection for improved startup performance. - Allow transport of application across Invantive Web Service. - Include metric dimensions in history of audit events. - Add string_split table function. - Improve formatting of errors with nested errors by adding line feed. - Increase maximum size of result sets to above 4 billion rows. - Standardize JSON format for export to ignore null values. - Add simplification of aggregated exceptions. - Include software requirements. - Include more trace messages being logged at application exit in trace. - Improve performance of HTTP input value extraction using 'name'. - Extend string library with remove characters from any char array. - Improve performance of retrieval of HTML INPUT parameters on large HTML pages. - Add Open Data license to Query Tool and Data Loader. - Avoid collateral damage by allowing ignore errors during adding values to an exception's data dictionary. - Add Sample Dummy data source to Invantive Business. - Allow use of a machine-based key pair for cryptographic operations [ITGEN-3094]. - Register Data Container ID and Log On Code in HTTP response cache object to improve correct matching for re-use of disk caches. - Add number of HTTP disk and memory cache incorrect version and content counters to providers. - Add Id and ProtocolVersion to HTTP disk cache files. - Make trace logging async from program execution and improve throughput. - Improve performance of trace logging from within Visual Studio by an order of magnitude. - Enable configuration of startup checks. - Ignore exception during collection of HTTP properties on exception [ITGEN-2986]. - Allow ignore errors from File Access Information determination to avoid itgenube078 errors in Query Tool on restricted Windows environments. - Add base class for JSON debugging. - Add option to remove key for Invantive Keychain from Microsoft Windows key container. - Add UTC time to system/myinfo endpoint. - Add thread ID to session I/Os. - Allow inheritance of inner message codes. - Allow filtering on data container ID when downloading feeds on Data Replicator. - Enable trace gathering during startup phase. - Improve concurrency of Dependency Injection. - Support for OAuth Code Grant Flow from AngularJS. - Larger batching of logging messages for massive parallel environments. - Performance improvements Exact Online for massive parallel environments. - Forward Customer Service validation messages to end user. - Allow overruling of OS platform for .NET Core through environment variable INVANTIVE_FORCED_OS. - Show provider attribute categories in logon screen. - Reduce memory leak by Webhook Receiver Daemon [ITGEN-2431]. - Allow differentiating log files based on the process ID. - Send all logging in one go instead of one each time [ITGEN-1161]. - Obsolete TLS 1.0 support. - Allow platform specific location of Cache, Providers and Log. - Add Direct Trace to ease analysis of startup problems using the environment variable INVANTIVE_DIRECT_TRACE_FILE_PATH. - Allow configuration of stack trace logging through environment variable INVANTIVE_TRACE_OWN_EXCEPTION_DETAILS. - Batch mode for insert on Exact Online. - Enable delete of Data Replicator messages. - Add date occurred at server local time to Data Replicator messages. - Remove dependency on System.Web to allow .NET Standard 2.0. - Cache HTTP requests also on disk. - Make compression of HTTP cache configurable. Bug fixes: - URL encode '!', '(' and ')' [ITGEN-3256]. - Avoid itgenhhr023 error when testing headless. - Fix Null Reference exception retrieving partitions. - Avoid NullReference on untrusted devices. - Avoid casting errors when simplifying aggregate exception data. - Ensure that cut out of string always has the right length. - Avoid NullReferenceException in audit logging. - Avoid NullReferenceException in tracing during high load in parallel scenarios. - Avoid repeating line prefix in trace when already printed. - Add proper escaping of reserved words across all SQL platforms. - Avoid Method not found: 'System.ValueTuple`2Invantive.Basics.HttpHelper.DownloadUrlToByteArray(System.String)'. - Improve unwrapping of aggregate exceptions in error handling. - Raise error when trying to log direct trace to a directory instead of a file. - Avoid StackOverflow when enabling direct trace on Power BI. - Improve web products performance by caching outcome of Info Response. - Reduce memory allocations by trace on exceptions. - Earlier start of sending session I/O statistics. - Error itgencun016: Could not determine Data Replicator messages [ITGEN-2487]. - Prevent using connection pooling on Invantive Estate through the Invantive Web Service tunnel. - There was an error reflecting type 'Invantive.Data.ResultSet' [ITGEN-2395]. - Enable StringifyFormat.JoinNull to correctly handle enum lists. - Reduce lock contention on session I/O registration. - Reduce number of AggregateExceptions thrown with 1 exceptions. - Reduce number of signature checks on DLLs. - Define central configuration file folder. - Fix bug when compressing results where results length = 0. - Remove leading backslash from machine name when no domain name present. - Fix determination of domain name for web applications. - Avoid loss of measured session I/Os not being forwarded during high intensity loads. - Give ID of new session I/O an incrementing value. Details of Release Notes: Version 20.0.50: Add new_time SQL function and support a wide variety of time zones # src/Invantive.Basics/Licensing/FunctionLicenseRequirementsBase.cs Version 20.0.49: Control: Add check workbook structure tool button to check if all required worksheets are registered # src/Invantive.Basics/Licensing/FunctionLicenseRequirementsBase.cs Version 17.24.38: Improve performance of trace logging from within Visual Studio by an order of magnitude. Background: 20K lines Unattached: 11 sec Optimized code: 16 sec Original: >200 sec