Data Virtuality Platform 2.4.19: Updates, improvements, and bugfixes

This release is mostly about the Server. First of all, we have updated several components: the embedded JDK (in the Server and Studio) to version 11.0.14.9, the "plaind-commons" library file, to a version with Log4j 2.17.1, and the JDBC driver for Exasol, to version 7.1.1. Second, we have fixed several bugs, most importantly, one causing the backup job to fail on Windows in case the Server was installed in a directory with a space. If you are using Netsuite, you can now safely select data from a schema name containing spaces: the query re-writer will now put the schema and table name in quotes, as it should. Please note that as a result of this bugfix, the default value of the importer.loadColumnsTableByTable model property has been changed to TRUE for Netsuite, which can significantly slow down data source creation in some cases. Another bugfix bringing a major change concerns the SYSADMIN.getResourceDependencies procedure. While it now works correctly on system procedures, as a result of the solution used, all views in data sources and system schemas are now treated not as tables but as views. It means that the 'VIEWS' resourceType must be used to retrieve dependencies information, and we ask you to update your scripts accordingly.

As for the Studio, we have improved performance of the dependency graph generation and display of timezones. Now the Studio will always use and display the Server's timezone.

Last but not least, we have good news for the Amazon Seller Partner users. Our connector now includes a bunch of newly added reports: FBA Stranded Inventory Report, Report_FlatFileSettlement, Report_FlatFileV2Settlement, Report_Settlement, Report_SnsForecast, Report_SnsPreformance.

Here are all issues in this release:

Server

• DVCORE-7658 (Improvement): Update embedded JDK in Data Virtuality Server and Studio to version 11.0.14 9
• DVCORE-7648 (Improvement): Update the "plainid-commons" library file to a version with Log4j 2.17.1
• DVCORE-7606 (Improvement): Enhance the SYSADMIN.getResourceDependencies procedure to return dependencies of different types
• DVCORE-7566 (Improvement): Exasol: update JDBC driver from version 5.0 to 7.1.1
  Fingerprint was added into CliTemplate.
  The fingerprint of the certificate currently in use by Exasol can be viewed in EXAoperation.
  JDBC property validateservercertificate=0 can be used to skip certificate validation.
• DVCORE-7655 (Bug): Give translators a better batch size
• DVCORE-7638 (Bug): Netsuite: schema and table names are not quoted in the translated query
  The default value of the importer.loadColumnsTableByTable model property has been changed to TRUE for Netsuite, which can significantly slow down data source creation in some cases.
• DVCORE-7568 (Bug): Backup job fails with ClassNotFoundException on Windows when the Server is installed in a directory with a space
• DVCORE-7337 (Bug): SYSADMIN.getResourceDependencies procedure fails on system procedures
  All views in data sources and system schemas are now treated not as tables but as views. Therefore the 'VIEWS' resourceType must be used to retrieve dependencies information. Please update your scripts accordingly.
• DVCORE-6123 (Bug): The ARRAY_ADD function behaves incorrectly on NULL values

Studio

• DVCORE-5405 (Improvement): improve performance of the dependency graph generation
• DVCORE-7575 (Bug): timestamp timezones are not consistent

Connectors

• SQL-458 (Improvement): Amazon Seller Partner: add FBA Stranded Inventory Report, Report_FlatFileSettlement, Report_FlatFileV2Settlement, Report_Settlement, Report_SnsForecast, Report_SnsPreformance reports