Release Notes 5.2.9

Upgrade Consideration

A new validation is now applied to the lookup function that prevents saving an expression where the result lookup field and primary key field N parameters are not from the same object. As a result, existing expressions with a lookup function must be updated accordingly; otherwise, these expressions will return #ERROR as a value.

What's new?

The following are the new features in 5.2.9:

Limit prompt filters dashboard selection

In this release, Incorta enables the Cluster Management Console (CMC) admin to restrict demanding execution queries by limiting the number of selections in a dashboard prompt filter that a dashboard consumer can apply. This limitation is applicable for the following prompt filter operators:

  • In
  • Not In
  • Contains
  • Does Not Contain
  • Starts With
  • Does Not Start With
  • Ends With

You can find the new configuration in the CMC under Default Tenant Configuration > Incorta Labs > Max no. of selections for for string filter operators. The default value for the configuration is -1, which indicates an unlimited number of selections. 0 indicates an unlimited number of selections as well. Any number greater than 0 will indicate the maximum number of selections a dashboard consumer can select in a prompt filter.

For Contains, Does Not Contain, Starts With, Does Not Start With, and Ends With, the Select All option will not be available while creating filters. Instead, it is recommended to enter a custom-optimized string value to enhance filtration performance.

Analytics and Scheduler separation

Incorta has developed a new option to disable the scheduler on an analytics service. By disabling the scheduler, the admin eliminates any competition for resources between the scheduler and user queries. This ensures that the dashboard consumers have a dedicated analytics service solely for their queries.

In previous releases, the scheduler is always enabled on all analytics services. Starting this release, as a CMC admin, you can disable the scheduler while creating or editing an analytics service.

By disabling the Scheduler toggle, background jobs such as sending dashboards, load jobs, and scheduler jobs, run using the dedicated resources as per your infrastructure setup. Knowing that the Send Now feature in dashboards will work normally.

To enable or disable this option, you must apply the following steps:

  1. Log into the CMC.
  2. Navigate to Clusters > cluster_name > Nodes.
  3. Select More Options (⋮ vertical ellipsis icon) next to the needed analytics service and select Edit.
  4. Enable or disable the Scheduler option accordingly.
  5. Go to the IncortaNode/services/{service-id}/incorta/service.properties file for each analytics service that you have, and add the following properties, making sure to add the port and IP numbers with the info for the analytics service that has the scheduler enabled:
    • local.server.host=<ip_address>
    • local.server.port=<port_number>
  6. Restart the service for the change to take effect.
Important

You must have at least one analytics service with the Scheduler option enabled to ensure the system continues to function properly.

Tips and Tricks

  • While setting up your infrastructure, you must keep in mind which analytics URL you share with your users in case you have multiple analytics services that have different scheduler enablement set up. It is recommended to share the URL of which the Scheduler option is disabled to maintain high availability.
  • If you have a load balancer in place, make sure to configure it for the services that have the Scheduler option disabled.

A new adjust offset TMT command

Incorta is introducing a new tenant management tool command that aims to adjust the scheduler offset time during daylight saving time.

Command format:

./tmt.sh -clnm <clustername> -aofs <tenantName> <userName> --dry

For more information, refer to Tenant Management Tool → Adjust Offset Time for Scheduler.

Engine Concurrent Service Thread Throttling

A dashboard’s filtering can slow or be unable to render due to all Engine threads being used concurrently for another dashboard. With this resolution, workers will be throttled or increased based on the number of waiting jobs. Contact Incorta Support to edit the engine.properties file that exists in the Analytics Service directory and enable this feature.

Fixes and enhancements

In addition to the new features mentioned above, this release introduces some additional enhancements and fixes that help make Incorta more stable, engaging, and reliable.

Enhancements

EnhancementArea
A new option, Load Last Valid Batch Only, is now available in the Oracle Cloud Applications table data source properties to allow the connector to search for the last valid batch in the batches that are uploaded to UCM within a defined period from the load time (the default is 7 days). If no valid batch is found, the load job will fail with an error message: Couldn't find a valid record set.Connectors
The Google Sheets connector now supports skipping first few rows using the Skip First N Rows attribute, where N is the number of rows. Knowing that this attribute is mandatory, with a default value 0.Connectors
The service name will be added as a prefix to the audit output file resulting from consolidating the Analytics Service’s audit files when they reach the maximum configured size.Logging
The Referenced Schema and Referenced Table lists in the Alias Data Source dialog are now alphabetically sorted and searchable by the schema or object name respectively.Schemas
Incorta has upgraded the Apache Tomcat version to 9.0.78.Security
3-digit y-axis values were abbreviated in 5.1.x and 5.2.x releases (for example, 240 was displayed as 0.24K) although they used to be shown as full values in 4.9.x releases. Starting with 5.2.9, these values are not abbreviated any longer and only values with 4 or more digits are abbreviated.Visualizations

Fixes

Issue resolvedArea
An issue with the Google Sheets connector caused errors when browsing to select a Google Sheet and when loading tables created based on Google Sheets in a shared folder.Connectors
Fusion table extraction intermittently failed with a Reached EOF, but there is no closing MIME boundary error.Connectors
BigQuery connector timed out during discovery.Connectors
Trying to download an insight in one tab while it was being downloaded from another browser tab or refreshing the current tab and trying to download again caused the second trial to fail and threw an error.Dashboards
Issues when downloading and sharing dashboards in PDF and HTML formats.Dashboards
Issues when drilling down into a dashboard or an insight.Dashboards
The Autocomplete feature was not working when using Notebook to create a materialized view.Notebook
Post-load failure when trying to commit compacted versions.Schemas
The Add New Join dialog didn’t show any columns from newly created aliases when trying to create a join between an alias and another table in the same schema.Schemas
After restarting the Loader Service, load jobs that were in progress showed as failed although tables were still being extracted.Schemas
A Null Pointer Exception error appeared when connecting to Incorta SQLi from DataGrip app or Java SpringBoot app.SQLi
Trying to connect to Incorta metadata database through external tools on SQLi port threw errors and returned no dataSQLi
In donut charts, number formatting was not working properly when the chart contained measure columns only.Visualizations
Hierarchy tables didn’t show aggregated values and only showed individual values.Visualizations