Release Notes of Invantive(R) SQL for Windows 20.1.394-BETA

Invantive(R) SQL for Windows

Invantive SQL for Windows is the Windows version of Invantive SQL that allows access to over 50 platforms, all acting together as one global database. Compared to the platform-independent version it adds support for MySQL, Oracle, IBM DB/2, LDAP, Teradata, Windows ODBC, Invantive Web Service, LDAP, Windows WMI and Windows OS.

Created: 07/04/2021 10:35:15 (UTC, deploy002)

Version: 20.1.394

State: Beta

MSI Product ID: e0415ce3-a127-4906-b6d6-c72067ed22e1

Manufacturer: Invantive Software B.V.

Brand: Invantive

Category: Business

Permissions: Software Requirements: Tags:

Included Components:

Version 20.1.392-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.372-BETA, released 2021-03-03.

Enhancements:
- Make check of OS upgrades applied configurable using INVANTIVE_CHECK_OS_UPGRADES.

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.356-BETA, released 2021-02-10.

Enhancements:
- Add log file and trace file name path to Data Hub end-user failure reports.

Version 20.1.353-BETA, released 2021-02-04.

Enhancements:
- Make many early compatibility checks fatal.

Version 20.1.345-BETA, released 2021-01-28.

Bug fixes:
- Avoid error when upgrade service is not enabled.

Version 20.1.340-BETA, released 2021-01-25.

Enhancements:
- Rename Open Data to Public Data.

Version 20.1.329-BETA, released 2021-01-10.

Enhancements:
- Replace return value to exception.

Version 20.1.326-BETA, released 2021-01-04.

Enhancements:
- Add ignore_errors to read_file and read_file_text on OS-connector.

Version 20.1.315-BETA, released 2020-12-21.

Enhancements:
- Add Oracle support for derived data type INTEGER.

Version 20.1.301-BETA, released 2020-12-08.

Enhancements:
- Clearer hint on 32-bit only ODBC.
- Add main category to providers.

Version 20.1.288-BETA, released 2020-11-24.

Bug fixes:
- Make GetObjectMetadata more thread-safe.

Version 20.1.284-BETA, released 2020-11-20.

Bug fixes:
- Make text fields always nullable on ODBC, since MySQL can be accessed through ODBC.

Version 20.1.278-BETA, released 2020-11-13.

Bug fixes:
- Forward ignore-memo-value-errors from AccountView to FoxPro.

Version 20.1.273-BETA, released 2020-11-07.

Enhancements:
- Return primary key, row count and native answer from insert.

Version 20.1.271-BETA, released 2020-11-06.

Enhancements:
- Memorize last action.

Version 20.1.267-BETA, released 2020-11-04.

Enhancements:
- Enable configuration of FoxPro memo value errors configuration from within AccountView connector.

Version 20.1.256-BETA, released 2020-10-16.

Enhancements:
- Support for SQL Server with case-sensitive collations.

Bug fixes:
- Fix determining primary key columns on Oracle.

Version 20.1.243-BETA, released 2020-10-05.

Enhancements:
- Improve real, float and double Oracle support.
- Add drop table for Oracle.

Bug fixes:
- Fix Oracle metadata discovery.
- Clarify error message itgeneuy004 what application to restart.

Version 20.1.230-BETA, released 2020-09-25.

Enhancements:
- Switch to Invantive's own RSA implementation.

Bug fixes:
- Improve Windows 10 detection

Version 20.1.224-BETA, released 2020-09-19.

Bug fixes:
- Do not check for recent Windows updates on Windows 10 20H1 due to broken API, avoiding itgensuy033/itgensuy034.

Version 20.1.154-BETA, released 2020-07-08.

Bug fixes:
- Fix Producer repository log on using managed Oracle driver.

Version 20.1.118-BETA, released 2020-07-05.

Enhancements:
- Switch object size resolution from KB to bytes.

Version 20.1.89-BETA, released 2020-06-17.

Bug fixes:
- Correct need for user/password on non-authorized connectors.

Version 20.1.52-BETA, released 2020-06-12.

Enhancements:
- Improve error length checks on Oracle parameter names.
- Enable application mode authentication on Oracle.

Bug fixes:
- Improve concurrency.

Version 20.1.44-BETA, released 2020-05-24.

Enhancements:
- Log native calls also to disk.
- Materialize bind variables in large IN value lists.

Version 20.1.20-BETA, released 2020-04-19.

Enhancements:
- Include non-primary key field value of 'field' in update on ActiveCampaign contact custom field.

Version 20.1.9-BETA, released 2020-04-06.

Enhancements:
- Add more ODBC data types.
- More accurate determination of data container ID for ODBC-based data containers.

Version 20.1.2-BETA, released 2020-04-04.

Enhancements:
- Allow use of aliases for connection string key values to fix PostgreSQL SSL mode configuration.

Bug fixes:
- Fix missing expansion on message itgensuy012.
- Improve support for Multivers ODBC.
- Fix connection to Multivers ODBC driver.
- By default enable user and password entry on ODBC data containers.

Version 17.33.337-BETA, released 2020-03-20.

Enhancements:
- Fine-tune PostgreSQL datamodel upgrades to enable solely column nullable change when column is used in view.
- Allow setting text encoding on FoxPro and AccountView.
- Make bulk insert batch size configurable.
- Add SAGE50 ODBC support.
- Improve ODBC level 3 support.
- Show source file for databases in tooltip.
- Increase default connection timeout from 15 to 60 seconds.
- Add basics for retrieving difference in date/time notation between platform and Invantive SQL engine.
- Add AccountView.net [ITGEN-4652].
- Skip AccountView companies that have not been set up complete.
- Bridge Online provider.
- Increase criteria for required Windows update to ensure proper security of devices running Invantive products which typically handle personal and financial data to last search 32 days ago and last Windows update installed 95 days ago.
- Make batch size for delete and insert configurable.
- Twinfield connector.
- Indicate that encrypted value is a license key instead of the default 'password' text on decryption failure.
- Exclude virtual and inactive tables from AccountView metadata.
- Check that a unique AccountView data dictionary file DCT_FILE can be found.
- Improve support for copied AccountView environments.
- Add search directories for AccountView replicated databases.
- Add Outlook connector.
- Allow disk cache root folder to be specified as execution option.
- Exclude grouping by directory path from AccountView partitions.
- Add support for rooted paths in AccountView.
- Allow skip on inaccessible AccountView partitions.
- Add support for generation of ksh scripts.
- SQL: Add htmltable table function.
- AccountView provider.
- AccountView connector
- Allow specification of data container alias to derive IUID from in settings.xml on database level using 'iuidSource' attribute.
- Add row level security.
- Make setting Oracle client information optional.
- Allow specification of SQL statement to execute upon open and close of pooled connection.
- Add RLS labels.
- Add Mac OSX support.
- Allow check on maximum length of file name and path combined.
- Allow configuration of cache folders on Windows.
- Split cache files for HTTP disk cache and Data Cache.
- Memorize content type of HTTP requests.
- Improve performance by reduced use of DateTime.Now.
- Allow overrule of configuration folder location with environment variables.
- Add ensure view dropped and column dropped methods to ANSI SQL-based connectors.
- Consider length in conversion from string to char or varchar database data type on Windows-based connectors.
- Validate data against metadata when rows are transported over Invantive Web Service.
- Include name, type, nullable and origin of column in generated SQL DDL.
- Upgrade to .NET Framework 4.7.2.
- Recover broken Oracle connections transparently.
- Include fetch parameters in session I/O logging.
- Add file_path parameter to read_file and read_file_text table functions.
- Add maintenance of indexes for MySQL.
- Default casing of Invantive SQL identifiers is upper case.
- Make standardization with SQL identifier escape optional.
- Cache field metadata to improve performance of ANSI providers.
- Standardize Oracle sequence and primary key naming.
- Add provider attribute 'maximum-length-identifiers' to specify non-default maximum length of identifiers for a platform.
- Extend data dictionary model to allow differentiation between read-only partitions and read/write partitions.
- Exclude data from external companies depending on subscription for accountants.
- Allow non-default casing column names on ANSI SQL providers.
- Reduce number of alternative provider attribute names to avoid confusion with users.
- Performance improvements SQL engine: faster returning data, cache some system table functions.
- Performance improvements SQL engine: faster returning data, less memory pressure.
- Improve performance by streaming row checks.
- Streamed reading for ANSI SQL providers, like SQL Server and Oracle.
- Add 'drop table' on MySQL [ITGEN-3052].
- Add create or replace table support for MySQL and support for MySQL on Data Cache/Data Replicator [ITGEN-2083].
- Allow ignore errors from File Access Information determination to avoid itgenube078 errors in Query Tool on restricted Windows environments.
- Add group function 'product'.
- Invantive Business for XAF files.
- Only try once to write to event log when not privileged.
- SQL: Allow specifying the timeout on a specific action.
- Improve upgrade scenarios for Data Replicator new not-null columns.
- Add Data Replicator support for Oracle.
- Add support for table or view synonyms in available objects  [ITGEN-2604].
- Default user log on code to database value when not specified on connectionstring.
- Add more context when license key can not be decrypted.
- Move providers.xml to settings.xml.
- Add display names to all providers for use in new login screen.
- Enable configuration of internal consistency checks.
- Updated partitioning in Control and Composition to allow selection of the partition when having multiple data containers opened, like two Exact Online accounts.
- Include documentation column on providers in Data Dictionary.
- Add support for file copy actions to OS-provider.
- Add file insert/delete/move tables with audit file_actions to OS-provider.
- Make use of connection pooling configurable per data container in settings.xml.
- Determine version number of database platforms for certification checks.

Bug fixes:
- Fix character set encoding for AccountView Euro.
- Switch new ODBC databases from native SQL to Invantive SQL.
- Improve naming of partitions on ODBC.
- Add discovery for ODBC data sources.
- Map Oracle data type date to Invantive database data type 'datetime' instead of 'date'.
- Raise correct error when Windows Update is not running instead of a COMException.
- Fix discovery showing username and password login for OAuth client credentials providers when it shouldn't.
- ODBC correct float data type.
- Exclude AccountView tables which have no active columns.
- Correct numeric precision of specific AccountView number data types.
- Fix data type issues. Do not raise exception when an administration is missing a specified table file.
- Fix data type issues. Do not raise exception when an administration is missing a specified table file.
- Fix retrieving wrong values for AccountView tables.
- Avoid NullReference instead of a decent error when a describe is done on a non-existing table.
- Exclude inactive fields on AccountView.
- Give stock_type on AccountView's article a precision.
- AccountView: Fix partition selection bug.
- Only take AccountView's system table location path from system.ini when present [SUP-977].
- Make read_file_text return identical Incapable to read_file when file doesn't exist.
- Correctly display inner exceptions on Oracle.
- Fix ADO.NET version resolve issue.
- Avoid 'itgenlic457 User too vague' by improved algorithm.
- Also deliver messages from last 15 seconds of session to Customer Service.
- itgenrst004 The metadata of the column XXX in '' must have the same .net type as the actual data. [ITGEN-4356]
- Make compliant on SQL Server 7 [ITGEN-4355].
- Fix itgendca005 error when NativeScalarRequests view is registered twice.
- Improve .NET Core compliance.
- Fix number and datetime metadata issue.
- Avoid message on missing license variant code when default license variant code when not present in top-level assembly.
- Avoid unnecessary LOB cache can not be saved error when there is nothing to save early in boot phase.
- Fix use on Oracle of Data Replicator with upper casing
- Fix System.Runtime not found exception  [ITGEN-3857].
- Reduce impact of crash during calculation of stack trace.
- Remove dependency on System.Net.Http to avoid itgensuy016 error.
- Correct Microsoft .NET Framework version check.
- Avoid itgeniuy003 error when not logged to Office 365 [ITGEN-3789].
- Fix error itgeniuy003: Platform user is missing in construction of IUID [ITGEN-3789].
- Fix itgendca002 on discovery on MySQL data model.
- Fix itgendca002 on discovery on Oracle metadata.
- Avoid repeatedly loading same metadata on SQL Server [ITGEN-3458].
- Enable forwarding of application across Invantive Web Service.
- Add proper escaping of reserved words across all SQL platforms.
- Incremental evaluation of file access privileges to reduce false negatives when checking file permissions.
- Handle column data model upgrade from limited length to unlimited length.
- Fix get object metadata not working for SQL Server and PostgreSQL [ITGEN-2276].
- Filter failure itgendid048 "The value %123123% is not a valid integer".
- Improve double data type mapping for Oracle.
- Fix database version query DB2.
- Better support for specifying password on IBM DB2 UDB  [ITGEN-2498].
- Password DB2 UDB is incorrectly handed over and not obfuscated [ITGEN-2498].
- Update web service exception conversion.
- Fix concurrency issue in webhook receiver causes itgenwrr005 [ITGEN-2108].
- Not found table 'FileSystem..file_actions' [ITGEN-2407].
- Set nullable property on Oracle-based columns correctly, were always false.
- Joining with read_file_text yields invalid results [ITGEN-2246].
- Improve performance by reducing number of lookups on processes.
- Fix NRE and other bugs in Os provider.


Details of Release Notes:

Version 20.1.230:
Improve Windows 10 detection
#	src/Invantive.Data.Windows/LastResortOnWindowsProvider.cs
#	src/Invantive.Data.Windows/Providers/Os/OsProvider.cs
#	src/Invantive.Data.Windows/Providers/Os/WmiProvider.cs