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 resolved | Area |
|---|---|
$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 button | Physical 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 |