Release Notes 5.2.5

The 5.2.5 release is bringing several enhancements and fixes into the 5.2.x release to make sure Incorta is more stable, engaging, and reliable. In addition, Incorta is now supporting aggregate filters in pivot table insights. Incorta is also introducing the new "Allow Cloud Disk Space Monitoring" configuration in the Cluster Management Console (CMC).

Upgrade considerations

  • You must run the Versioning Migration Tool if you are upgrading from an Incorta version prior to 5.1.x.
  • To migrate your load jobs history, you must run the migratejobs.sh file script located at <incorta_installation_path>/IncortaNode/incorta.jobsmigration.5.1/.
  • Sending dashboard attachment size has increased by approximately 60% as a result of the additional features added. Ensure allowing your mail server attachment limit matches that increase.
General Availability (GA) features

Both of the insights over result sets and Incorta SQL Table features are now GA fully supported product features.

What's new?

Oracle metadata database support

In this release, Incorta is supporting Oracle as a metadata database. Currently, Incorta supports Oracle database versions 12c and 19c. For more information, refer to Installation Requirements.

Support Aggregate filter in Pivot table visualizations

Incorta now supports aggregate filters for Pivot table visualizations. For more information, refer to Visualizations → Pivot Table.

Allow Cloud Diskspace Monitoring configuration

Incorta is adding a new configuration to the CMC. The Allow Cloud Diskspace Monitoring option is under Clusters > Cluster Configurations > Server Configurations > Diagnostics. When you enable this option, you will be able to see the Shared Directory Diskspace under Monitoring > Tenants. This configuration is applied to cloud storage only and it is disabled by default. Enabling this configuration is not recommended and it might increase the number of I/O operations on your cloud storage. For more information, refer to Guides → Configure Server.

Fixes and enhancements

Enhancements

EnhancementArea
Timezone list in Scheduler to be more clear. For example, Etc/GMT +1 (GMT-1) instead of Etc/GMT +1.Scheduler

Fixed issues

Issue resolvedArea
Running total calculating all records regardless of grouping.Analyzer
Inaccurate calculations when using insights over result sets.Analyzer
Couldn’t create a physical schema based on an FTP data source although testing the connection succeeded.Connectors
INC_03070701: ConnectorFactory Error: For input string: "" error when editing a table and choosing the Load last batch only option.Connectors
Dashboard is not sent when using formula columns as prompts.Dashboards
INC_05001101: Failed to Connect to Mail server error while sending dashboards as HTML.Dashboards
Insight names of an emailed dashboard in XLSX would have style tags displayed in the title.Dashboards
Intermittent failure to download Pivot table insights in XLSX format.Dashboards
Big banner hiding dashboard when sending dashboards using impersonation.Dashboards
Unexpected error when using free text in dashboard filters.Dashboards
The Inspector tool did not detect columns with non-ASCII characters.Inspector Tool
BUSINESS_VIEW_ON_MISSING_COLUMN error when running the inspector tool on a business view based on a physical table with a self-join relation.Inspector Tool
INC_03070101: Transformation error intermittent error when pushing Synapse MVs.Materialized Views
java.lang.OutOfMemoryError: Java heap space error.Materialized Views
Currency value shifted twice when the Process in Incorta option is disabled.Physical Schemas
INC_03070400: Failed to generate schema error when validating column with a query that contains the word LIMIT while the chunking option is disabled.Physical Schemas
Intermittent error when calculating joins of aliases between two loader services.Physical Schemas
INC_03010102: Not enough memory error during extraction that results in load failure.Physical Schemas
Schema notifications are not functioning properly.Scheduler
Query failing when using DISTINCT ON without ORDER BY clause.SQLi
java.lang.NullPointerException error leading to query failure.SQLi
Aggregate values on a stacked column insight would not be removed when total values were disabled.Visualizations
Large log files.Miscellaneous
Intermittent error when logging in to Incorta using an LDAP account.Miscellaneous