Release Notes 5.2.4

Release Highlights

In this release, Incorta enhanced the daysBetween function. Now, the daysBetween function does not automatically round up the returned value to the nearest long value, instead, it returns and saves the value as double. To round the returned value and retain the old behavior, you have to wrap up the daysBetween function with the round or ceil function.

Important

To avoid errors that might occur after the upgrade when rendering insights and business schemas that reference columns with the daysBetween function, you have to load from staging all physical schemas where these columns exist.

Enhancements and Fixes

In addition to the enhancement mentioned above, this release introduces other enhancements and fixes that help make Incorta more stable, engaging, and reliable.

Issue resolvedArea
$currentWeekStart and $lastWeekStart system variables returned incorrect day and year for the first week of the year.Analyzer
max() and min() functions in some cases incorrectly converted data types.Analyzer
Error resulted from exporting data sources using Incorta CLI while using python3.CLI
BigQuery connector times out during discovery.Connectors
Connection closed after executing pre-SQL statements, resulting in no results retrieved.Connectors
The Netsuite connector would freeze during load if chunking was enabled where only one batch exists.Connectors
Intermittent failure connecting to Google Drive.Connectors
Renaming a dashboard filter moved up and renaming switched to the second filter.Dashboard
When the Row Subtotal option is on, you could not download the insight to XLS.Dashboard
Insights with a non-alphanumeric schema source name could not be edited.Dashboards
Selecting the Done button in Manage Dashboard Filters, deleted all prompts and filters.Dashboards
Dashboard load failure due to an aggregation failed error.Dashboards
Sending a dashboard via email failed when it had more than one insight with Average Lines.Dashboards
Filters were not always from BlackLine to an Incorta Dashboard.Dashboards
Dashboard insight kept loading with no error displayed.Dashboards
Empty XLSX files when scheduling dashboard reports.Dashboards
Error Index 3 out of bounds for lengths 3 when trying to download Pivot tables having a measure in percentage format as excel.Dashboards
When downloading an insight as a CSV file, the numbers in the exported file were rounded per the insight configurations.Dashboards
Validation issue while using Last Version Operator.Dashboards
Downloading to Excel took too long to actually download.Dashboards
Some insight names displayed HTML tags on the data lineage page.Inspector Tool
Inspector tool could not resolve lookups that had formulas.Inspector tool
Shared schema via email broken link.Physical Schema
Improved performance when retrieving model and schema updates.Physical Schemas
Schema updates failure resulting in java.lang.IndexOutOfBoundsException: Index: -1 error when selecting the Done buttonPhysical Schemas
Inability to create a new hive dataset as the two fields File type and File location were empty.Physical Schemas
Failure while loading a table based on a PostgreSQL connection that fell back to spark.Physical Schemas
Scheduler indicated that a schema load occurred twice when only one was requested.Physical Schemas
Empty email ID in data alerts.Scheduler
Intermittent error when sending GoogleSheets-based dashboards.Scheduler
SQLi connection from Datagrip failure after upgrading Incorta from 5.1.x to 5.2.2.SQLi
Conditional formatting did not appear for subtotals when the Merge Columns and Collapsed insight settings were enabled in Aggregated tables.Visualizations
Large log files resulting from Analytics tenants in 5.2.2.Miscellaneous
Merge tool performance issues after migrating to Azure Data Lake Storage.Miscellaneous