Release Notes of Invantive(R) SQL for Windows 17.32.270

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: 10/11/2020 19:25:30 (UTC, deploy002)

Version: 17.32.270

State: Long-term Support

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

Manufacturer: Invantive Software B.V.

Brand: Invantive

Category: Business

Permissions: Software Requirements: Tags:

Included Components:

Version 17.32.266, released 2020-09-30.

Bug fixes:
- Clarify error message itgeneuy004 what application to restart
- Improve Windows 10 detection

Version 17.32.264, 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 17.32.262, released 2020-09-10.

Bug fixes:
- Avoid hang on close.

Version 17.32.223, released 2020-06-10.

Enhancements:
- Enable application mode authentication on Oracle.

Version 17.32.208, released 2020-04-06.

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

Version 17.32.205, 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.

Version 17.32.203, released 2020-04-03.

Bug fixes:
- Improve support for Multivers ODBC.
- Fix connection to Multivers ODBC driver.

Version 17.32.165, released 2020-01-30.

Enhancements:
- Add SAGE50 ODBC support
- Improve ODBC level 3 support

Version 17.32.160, released 2020-01-18.

Enhancements:
- Increase default connection timeout from 15 to 60 seconds.

Version 17.32.147, released 2020-01-03.

Bug fixes:
- Improve naming of partitions on ODBC

Version 17.32.139, released 2019-12-18.

Bug fixes:
- Map Oracle data type date to Invantive database data type 'datetime' instead of 'date'.

Version 17.32.135, released 2019-12-11.

Enhancements:
- 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.
- Re-enable Twinfield when licensed.
- Indicate that encrypted value is a license key instead of the default 'password' text on decryption failure.
- Allow specification of data container alias to derive IUID from in settings.xml on database level using 'iuidSource' attribute.
- Make setting Oracle client information optional.
- Allow specification of SQL statement to execute upon open and close of pooled connection.
- 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:
- Raise correct error when Windows Update is not running instead of a COMException.
- ODBC correct float data type.
- Avoid NullReference instead of a decent error when a describe is done on a non-existing table
- Add documentation on use of read_file_text parameter.
- 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.
- Complete list of licensed modules displayed in Agreement window.
- 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 17.32.266:
Clarify error message itgeneuy004 what application to restart
#	src/Invantive.Data.Windows/DependencyInjection/ErrorHelper.cs
Improve Windows 10 detection
#	src/Invantive.Data.Windows/DependencyInjection/SystemHelper.cs

Version 17.32.165:
Add SAGE50 ODBC support
# Conflicts:
#	src/Invantive.Data.Windows/Providers/Odbc/OdbcProvider.cs
Improve ODBC level 3 support
# Conflicts:
#	src/Invantive.Data.Windows/Providers/Odbc/OdbcDataSources.cs

Version 17.32.147:
Improve naming of partitions on ODBC
# Conflicts:
#	src/Invantive.Data.Windows/Providers/Odbc/OdbcProvider.cs

Version 17.32.118:
Avoid NullReference instead of a decent error when a describe is done on a non-existing table
# Conflicts:
#	src/Invantive.Data.Windows/Providers/IbmDb2/IbmDb2Provider.cs
#	src/Invantive.Data.Windows/Providers/InvantiveAdoNet/InvantiveAdoNet.cs
#	src/Invantive.Data.Windows/Providers/Odbc/OdbcProvider.cs
#	src/Invantive.Data.Windows/Providers/Oracle/OracleProvider.cs
#	src/Invantive.Data.Windows/Providers/OracleManaged/OracleManagedProvider.cs

Version 17.32.115:
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
# Conflicts:
#	src/Invantive.Data.Windows/SystemUtility.cs

Version 17.32.46:
Allow specification of data container alias to derive IUID from in settings.xml on database level using 'iuidSource' attribute.
# Conflicts:
#	src/Invantive.Data.Windows/Providers/Webservice/WebServiceProviderDiscovery.cs
#	src/Invantive.Data.Windows/Providers/Webservice/WebServiceUtility.cs