LDW 2.4.11: Many improvements and bugfixes for connectors, and some for Server and Studio

This release, most notably, brings forth a number of improvements and bugfixes for our connectors.

The Excel connector has got most attention as four bugs have been fixed: queries will now return correct results when headerRowNumber value is greater or equals to the number of rows in the Excel sheet, SELECT will work correctly if any column contains a boolean value and will return all columns if the connection is configured with headerRowNumber parameter set to zero, and last but not least, creating a data source from an OOXML file will not cause NullPointerException.

We have also fixed a bug with Emarsys, so queries will no longer fail with the error "Invalid script cannot be used as a constructor in OBJECTTABLE".

We have also refactored the Price API connector and updated the Facebook Business connector to API v10.0 to make them even more efficient.

As for the Server, it has received four improvements and two bugfixes. The obsolete warning "-jaxpmodule is deprecated" will no longer be shown, and the data type mismatch error message will now include column name. The JSONOBJECT function is now able to process empty JSON without fields, and batch replication will work even if your target is a regular data source, not an analytical storage, as it required previously.

We have also improved the Web Business Data Shop: a procedure to delete catalog attributes (please note that from now on the setDataCatalogAttribute procedure throws an error when passed an empty string value) and a NOFAIL option for SYSADMIN.webBusinessDataShopPublish and SYSADMIN.webBusinessDataShopUnpublish procedures.

And finally, the Studio has become a bit easier to work with: we have removed the capability of moving objects between virtual schemas via substring replacement and added "collapse all" menu item to "System schemas".

Here are all issues in this release:

Server

• DVCORE-7453 (Improvement): Remove the obsolete warning "-jaxpmodule is deprecated"
• DVCORE-5915 (Improvement): Error Handler: add column name to the data type mismatch error message
• DVCORE-7387 (Improvement): Web Business Data Shop: add a procedure to delete catalogue attributes 
• DVCORE-6876 (Improvement): Web Business Data Shop: add a NOFAIL option for SYSADMIN.webBusinessDataShopPublish and SYSADMIN.webBusinessDataShopUnpublish procedures
• DVCORE-7491 (Bug): Batch replication requires an Analytical Storage to be configured even if the target is a regular data source
• DVCORE-7180 (Bug): JSONOBJECT function fails if no arguments are passed

Studio

• DVCORE-7479 (Improvement): remove the capability of moving objects between virtual schemas via substring replacement
• DVCORE-7449 (Improvement): add "collapse all" menu item to "System schemas"

Connectors

• SQL-383 (Improvement): Price API: refactor Price API connector
• SQL-305 (Improvement): Facebook Business: update connector to API v10.0
• SQL-409 (Bug): Emarsys: queries fail with an error "Invalid script cannot be used as a constructor in OBJECTTABLE"
• DVCORE-7483 (Bug): Excel: queries return incorrect results when headerRowNumber value is greater or equals to the number of rows in the Excel sheet
• DVCORE-6644 (Bug): Excel: SELECT fails if any column contains a boolean value
• DVCORE-6066 (Bug): Excel: SELECT returns only the first column if the connection is configured with headerRowNumber parameter set to zero
• DVCORE-4565 (Bug): Excel: NullPointerException when creating a data source from an OOXML file