Invantive(R) Basics
Invantive Basics enables multi-platform implementations of Invantive SQL
Created: 05/08/2021 11:34:09 (UTC, deploy002)
Version: 20.1.532
State: Beta
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.1.508-BETA, released 2021-07-27.
Bug fixes:
- Fix itgeneon001.
Version 20.1.497-BETA, released 2021-07-21.
Enhancements:
- Deviating title on sign up per step.
Version 20.1.483-BETA, released 2021-07-12.
Enhancements:
- Rewrite ObjectDisposedException on web fetch to connection closed event.
Version 20.1.480-BETA, released 2021-07-09.
Enhancements:
- Refactoring to provide status code to native requests.
Version 20.1.477-BETA, released 2021-07-09.
Enhancements:
- Add HTTP status 599 support.
Version 20.1.474-BETA, released 2021-07-06.
Enhancements:
- Improve handling of customer service messages.
Version 20.1.466-BETA, released 2021-06-30.
Enhancements:
- Make locker readonly.
Version 20.1.465-BETA, released 2021-06-28.
Enhancements:
- Retry on itgencsy020: Internet time can not be determined.
Version 20.1.449-BETA, released 2021-06-17.
Enhancements:
- Check validity of pool identity ID.
Bug fixes:
- Improve locking on session variables.
Version 20.1.432-BETA, released 2021-05-26.
Enhancements:
- Extend email address verification.
- Add source to email address validation.
Version 20.1.428-BETA, released 2021-05-20.
Enhancements:
- Improve error handling on invalid JSON in response cache across releases.
Version 20.1.405-BETA, released 2021-04-22.
Enhancements:
- Better clean email addresses.
Version 20.1.396-BETA, released 2021-04-11.
Enhancements:
- Add compiler-options detection.
- Add .NET Core 5.0.
Version 20.1.394-BETA, released 2021-04-07.
Enhancements:
- Add helper for RFC 850 date time.
Version 20.1.393-BETA, released 2021-04-04.
Enhancements:
- Add log text stream.
Version 20.1.391-BETA, released 2021-03-29.
Enhancements:
- Add public query parameters to session I/O in data dictionary.
- Enable free space on system disk check during startup using environment variable INVANTIVE_MIN_GB_FREE_SYSTEM.
Version 20.1.386-BETA, released 2021-03-17.
Enhancements:
- Optimizations for incremental loading of data.
Version 20.1.384-BETA, released 2021-03-15.
Enhancements:
- Add error handling when CloudWatch is down.
Version 20.1.378-BETA, released 2021-03-14.
Enhancements:
- Optimize performance by reducing global state allocations.
- Optimize performanec by reducing global state allocations.
- Optimize performanec by reducing global state allocations.
- Reduce CPU usage of trace when idle.
- Optimize global state stubs.
Version 20.1.372-BETA, released 2021-03-09.
Enhancements:
- Add driver instance-specific session I/O cumulatives.
Version 20.1.368-BETA, released 2021-02-19.
Enhancements:
- SQL HTML encode/decode.
- SQL HTML encode/decode.
Bug fixes:
- Fix registering session I/Os in NDJSON.
Version 20.1.365-BETA, released 2021-02-17.
Enhancements:
- Introduce INVANTIVE_CONFIGURATION_PERMANENT_CACHE_FOLDER and INVANTIVE_CONFIGURATION_INCREMENTAL_DATA_FOLDER environment variables for configuring location of permanent cache (such as Swagger specifications) and incremental data (such as Exact Online sync APIs).
Version 20.1.362-BETA, released 2021-02-12.
Enhancements:
- Include kind request from aggregate exceptions.
Version 20.1.356-BETA, released 2021-02-10.
Enhancements:
- Add log file and trace file name path to Data Hub end-user failure reports.
Bug fixes:
- Fix default license keys for new Public Data subscriptions.
Version 20.1.352-BETA, released 2021-02-04.
Enhancements:
- Make many early compatibility checks fatal.
Version 20.1.340-BETA, released 2021-01-25.
Enhancements:
- Rename Open Data to Public Data.
Version 20.1.332-BETA, released 2021-01-14.
Bug fixes:
- Fix .NET 5.0 preprocessor directive.
Version 20.1.329-BETA, released 2021-01-12.
Bug fixes:
- Avoid NullReference when deserializing JSON.
Version 20.1.327-BETA, released 2021-01-07.
Enhancements:
- Automatically accept all compression methods on .NET 5.
Bug fixes:
- Revert change for nullability.
Version 20.1.302-BETA, released 2020-12-13.
Enhancements:
- Make application/xml MIME type text.
Version 20.1.301-BETA, released 2020-12-07.
Enhancements:
- Return clearer error when license key has been disabled.
- Display deviating error message when license key has been disabled.
Version 20.1.284-BETA, released 2020-11-18.
Bug fixes:
- Do not crash when an invalid value is specified for INVANTIVE_TRACE*.
Version 20.1.279-BETA, released 2020-11-15.
Enhancements:
- Allow use of 0 and 1 for itgenrst0xx check configuration on environment variables.
Version 20.1.278-BETA, released 2020-11-13.
Enhancements:
- Try to determine application name and version better when exiting.
Version 20.1.273-BETA, released 2020-11-07.
Bug fixes:
- Improve license present determination.
Version 20.1.271-BETA, released 2020-11-06.
Enhancements:
- Memorize last action.
Version 20.1.266-BETA, released 2020-10-30.
Enhancements:
- Add option to close application on console menus.
Version 20.1.241-BETA, released 2020-10-05.
Enhancements:
- Add lookup of HSTS preload status to Internettable.
- Enable overrule of UI language by environment variable INVANTIVE_ALLOWED_LANGUAGE_CODES.
Version 20.1.230-BETA, released 2020-09-25.
Enhancements:
- Add Zoom connector license structure.
- Add Zoom provider.
- 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.1.200-BETA, released 2020-09-03.
Enhancements:
- Add prefix differentiation for HTTP disk cache.
Version 20.1.198-BETA, released 2020-09-02.
Enhancements:
- CSV encode and decode SQL functions.
Version 20.1.179-BETA, released 2020-08-25.
Enhancements:
- Type and check payload type of HTTP response cache objects.
Version 20.1.156-BETA, released 2020-07-27.
Enhancements:
- Add new_time SQL function and support a wide variety of time zones.
Version 20.1.154-BETA, released 2020-07-23.
Enhancements:
- Yuki: support changing domains [ITGEN-5137].
Version 20.1.153-BETA, released 2020-07-13.
Bug fixes:
- Control: Add check workbook structure tool button to check if all required worksheets are registered.
Version 20.1.115-BETA, released 2020-07-03.
Bug fixes:
- Avoid duplicate inclusion of error.
Version 20.1.109-BETA, released 2020-06-29.
Enhancements:
- Make correction of invalid dates possible using invantive-sql-correct-invalid-date setting.
Version 20.1.51-BETA, released 2020-06-08.
Enhancements:
- Add simulator for OData 401 errors.
Bug fixes:
- Do not include kind request twice in Invantive Cloud errors.
Version 20.1.48-BETA, released 2020-05-29.
Bug fixes:
- Avoid duplicate inclusion of message code in errors.
Version 20.1.44-BETA, released 2020-05-24.
Enhancements:
- Log native calls also to disk.
Version 20.1.43-BETA, 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.1.34-BETA, released 2020-05-10.
Enhancements:
- Reduce length of disk cache file names.
Version 20.1.20-BETA, released 2020-05-02.
Enhancements:
- Differentiate discovered database per version.
Version 20.1.11-BETA, released 2020-04-20.
Enhancements:
- Add AWS logger.
Version 20.1.9-BETA, released 2020-04-16.
Enhancements:
- Split system and SQL errors.
Version 20.1.5-BETA, released 2020-04-10.
Enhancements:
- Add exception class for SQL failures.
Version 17.33.329-BETA, released 2020-03-14.
Enhancements:
- 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.
- 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:
- 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.
- 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`2 Invantive.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 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