Release Notes of Invantive® SQL for Core 22.1.79-BETA

Invantive® SQL for Core

Invantive SQL for Core is the .NET Core version of Invantive SQL that allows access to over 75 platforms, all acting together as one global database.

These release notes describe all bug fixes and enhancements on Invantive® SQL for Core per released version. The release number consists of three elements: major version, minor version and patch version. The latest version is listed on top of the list, with older releases further down. Notes are listed per patch release for the current minor release. Changes from patch releases are bundled for previous minor releases. The release notes include all changes deemed informative for use outside the product development team. Refactoring, logging, translations and internal code-only changes are not included in these external release notes. A change is considered a bug fix when it solves a problem with previously released functionality. A change is considered an enhancement when the software change extends previously released functionality.

Version: 22.1.79

Released: 17-09-2022 19:22:00 (UTC)

State: Beta

Manufacturer: Invantive Software B.V.

Brand: Invantive

Operating systems:

  • Android
  • iOS
  • Linux
  • MacOS
  • Microsoft Windows 10
  • Microsoft Windows 11
  • Microsoft Windows Server 2012 R2 (64-bit)
  • Microsoft Windows Server 2016 (64-bit)
  • Microsoft Windows Server 2019
  • Microsoft Windows Server 2022


  • Requires Internet access.
  • Requires all required Operating System updates applied at most 1 month ago.

Software Requirements:

  • Microsoft .NET 6.0 or higher.
  • Screen resolution 1280x1024 or higher.
  • User license for databases used and/or business applications.

Category: Business


Forums (URL):

Manual (URL):


  • android
  • ios
  • linux
  • macos

MSI Product ID: 8cec1224-21c8-484e-95f0-75c4b35765a2

Included Components:

Version 22.1.66-BETA, released 2022-07-02.

- Add Danish, Finnish, Norwegian Bokmal and Swedish.
- Add Japanese.
- Capability to ignore error when accessing a non-existing file with file_info.
- Extend file copy by additional options.

Bug fixes:
- Fix regexp_split_row to return multiple columns.
- Register Oracle client IP address.

Version 20.2.241, released 2021-11-30.

- Add error message on failed calls.
- Add Oracle Managed Core provider.
- Cancellation on pending requests.
- Centralize rate limiting.
- Change execution log and native call logging to NDJSON format.
- Improve Linux directory separator and CR/LF compatibility.
- Make email address resolution through registry only available on Windows.
- Move incremental data to cache folder.
- Reduce garbage collection.
- Switch to IPv6.
- Upgrade to .NET 6.

Version 20.1.471-BETA, released 2021-04-12.

- Add compiler options to error itgenshr008.
- Add ignore_errors to read_file and read_file_text on OS-connector.
- Add log file and trace file name path to Data Hub end-user failure reports.
- Add main category to providers.
- Add public query parameters to session I/O in data dictionary.
- Better clean email addresses.
- Enable free space on system disk check during startup using environment variable INVANTIVE_MIN_GB_FREE_SYSTEM.
- Improve handling of disk full.
- 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).
- Log native calls also to disk.
- Make free disk space check configurable.
- Make locker readonly.
- Memorize last action.
- Refactoring [INTERLAL]
- Rename Open Data to Public Data.
- Replace return value to exception.
- Return primary key, row count and native answer from insert.

Bug fixes:
- Fix race condition in determining IUID.
- Improve concurrency.
- Improve Windows 10 detection

Version 17.33.303-BETA, released 2019-06-16.

- Add Mac OSX support.
- Add OS provider to .NET Core applications.
- Allow check on maximum length of file name and path combined.
- Bridge Online provider.
- Improve usability on MacOS.
- Initial release for .net core 2.0.
- SQL: Add htmltable table function.
- Twinfield.
- Update to .NET Core 3.1.

Bug fixes:
- Exclude non-existent path from files@os.
- Make read_file_text return identical Incapable to read_file when file doesn't exist.