Maintenance Packs for Release 4.5

Incorta encourages customers to upgrade to the most recent release. Here are maintenance packs notes for this minor release.

Maintenance Pack 4.5.14

What’s New?

Supporting using HTML email body and include images in sending dashboards to email
- Enabled by a checkbox option “Use HTML”
- Avoid using tags
- Some special characters might not be well rendered according to your mail server security like: + and $
- Increased character limit for the email body
Force reload columns is now done in parallel

Issues fixed

Fixed a deadlock condition on Analytics that caused some performance issues
Fixed a case where prompt filter list of values were not updated based on applied filters
Fixed a corner cases of failed synchronization
Fixed some metadata connection issues when frequently using send dashboard to email and exporting tables to CSV/XLSX
Fixed a rare case where join needs to be fully recalculated, instead of just updated, causing a data inconsistency issue
Fixed a wrong query plan that happens in case of level based measure
Minor UI fixes

Maintenance Pack 4.5.13

Issues fixed

Fix the email body to be in the body instead of inside the attached HTML file
Fix in selecting the status filter in the scheduled dashboard jobs screen.

Maintenance Pack 4.5.12

What’s New?

The snapshot writing operation is now enhanced to be atomic and lightweight.
Enhanced analytics query logs with more details about query processing.

Issues fixed

Fixed an issue that was displaying incorrect table records count during table load.
Resolved an issue that was preventing the creation of schema or table through the Schema Wizard due to an exception error.

Maintenance Pack 4.5.11

What’s New?

Added new functionality that lets you schedule and send a dashboard in a single HTML file over email.

Issues fixed

Resolved an issue to improve decimal precision in Business Objects’ measure rendering.
Fixed an issue that was causing a loading error when a load filter was added.
Fixed an issue that was causing the session variable to return an ‘Invalid Date’ error.
Resolved an issue that was failing materialized views after upgrading to a new Incorta version for one of our customers.

Maintenance Pack 4.5.10

This release is not available for customer download.

Issues fixed

Resolved issue where certain dashboards became corrupt when upgrading from 4.5.3.
Fixed issue with MS Excel export where grouping columns were not correctly aligned

Maintenance Pack 4.5.9

What’s New?

Added Enhanced Hive metadata discovery

Issues fixed

Resolved issue where schema wizard was not able to create a schema
Fixed internal error with array sizes being negative
Resolved issues with slow filtering

Maintenance Pack 4.5.8

Issues fixed

Initially released with 4.5.2, the beta PostgreSQL metadata handler is now disabled by default. To enable the beta PostgresSQL metadata handler for external query and visualization tools, add the sql.new.metadata.enabled=true property to the service.properties file for the Analytics Service node.

To identify the Unique Identifier (UUID) for the Analytics Service, view the services.index file, for example:

$ cat /home/incorta/IncortaAnalytics/IncortaNode/services/services.index

Replacing <UUID> with the Analytics Service value found in services.index, edit the service.properties file using vi or vim. The default path for the service.properties file is: /home/incorta/IncortaAnalytics/IncortaNode/services/<UUID>/incorta/service.properties

Resolved an issue that caused MIN, MAX and Distinct queries to fail over the SQL interface with external tools.
Resolved an issue with SQL formatting for SQL Tables defined in a schema. The auto-formatting feature for SQL is now disabled.
Resolved an issue that triggered a Microsoft Excel warning about unreadable content in an exported Pivot Table insight.
Resolved an issue where conditional formatting did not export to Microsoft Excel.
Resolved an issue with the Loader Service failing to load an Incorta Tables where the Max Groups setting was higher that 500,000.
Resolved an issue when running Spark SQL queries over the SQL interface where the SQL interface became unresponsive due to a lack of available connections. Now, if a user does not read the results of a Spark SQL query within 5 minutes, the statement terminates. If the Spark SQL results takes longer than 5 minutes, the user now receives a “Portal has timed out or not found” message.

Maintenance Pack 4.5.7

What’s New?

For a Pivot Table insight in a given dashboard, improved the MS Excel export feature. Now, each pivot table column is exported into its own column in MS Excel. In prior versions, the MS Excel export collapsed the pivot table columns into a single column.
For Gauge and Solid Gauge visualizations, for a measure in the measure tray, in the Properties Menu, you can now select the Drill Down tab and define a Dashboard drill down.
When loading a column which has multiple incremental parquet part files, the on-heap memory in both the Loader and Analytics Services is now reduced.
Enhancement to reduce off-heap memory footprints.

Issues fixed

Resolved an issue that allowed the Loader Service to incorrectly execute parallel schema loads beyond the configured schema pool size.
Resolved an issue in the Analytics Service where array sizes where calculated in a negative range.
Resolved an issue with Release 4.5.1 that incorrectly displayed the dates and times for dashboard schedules.

Maintenance Pack 4.5.6

Issues fixed

Fixed an issue where after starting an analytics service, a formula column that is based on an alias table does not return the correct values.
Resolved an issue with saving scheduled dashboard jobs after migration from Incorta Release 3.x to Incorta 4.5.
Fixed an issue where the schema and schema tables are not discoverable from external BI tools if there are formulas in business views or if a business view column references a physical table column that has been deleted.
Resolved an issue where a schema with a mix of large and small tables, the small table loads were taking longer to finish.
Fixed an issue with charts where coloring dimensions are based on a formula.

Maintenance Pack 4.5.5

Issues fixed

Resolved an error when exporting CSV/XSLX file from a dashboard containing a presentation variable.
Fixed an issue which was replacing spaces with invalid characters when downloading a table as CSV/XSLX.
Resolved an issue that was causing Insight crash on change of filter.
Fixed an issue in a multi-source table, where the SQL query of one source was overriding the records for the second source in the multi-source SQL table.

Maintenance Pack 4.5.4

What’s New?

Added an option to enable/disable ‘View as” regular/aggregated table button in Incorta Labs. It is toggled ON by default.

Issues fixed

Resolved an issue with discovering hierarchy tables via external BI tools. This issue was related to tables in Incorta with self joins.
Fixed a problem with memory leaks when using formulas in prompts.
Resolved an issue with a materialized Incorta table (via Spark) joining 2 base tables. The tables were loading fine without errors, but the values for a column (string formula in one of the base tables) were not being displayed on a dashboard insight.
Resolved an issue with connecting and discovering the Incorta metadata from Dundas data visualization as an external source.
Resolved an issue that at times prevented metadata initialization.
Resolved an issue which was inhibiting data refresh on bookmarks when using presentation variable as an applied filter.

Maintenance Pack 4.5.3

Issues fixed

Components	Release Notes
Schmemas	Resolved an issue with the slow response on the schema listing page with large number of schemas.
Materialized Views	Fixed an issue where a materialized view is not discovering and reading all columns when it’s built on top of a table that is sourced by using Incorta as a data source. The fix is resolved by adding the following property inside the `spark-defaults.conf file` and setting it to `true`: `spark.sql.parquet.mergeSchema`.
Analytics Service	Fixed an issue where the Analytics service evicted columns from an incrementally loaded materialized view.
SQLi	Prior to Release 4.5.3, the discovery of schemas and tables, views using SQL interface were case-sensitive. With 4.5.3, you can configure the SQL interface to be case-insensitive.
Dashboards & Insights	Fixed an issue where dashboard favorites are lost after upgrading to 4.5.2. With 4.5.3, you can export favorites from a prior version and import it into 4.5.3 as a manual step. For information on how, see Known issues In a future release, this will be supported natively without the need for manual import step.
Dashboards & Insights	Fixed an issue with formatting of KPI’s on dashboards.

Maintenance Pack 4.5.2

Upgrade Information

To ensure the new SQL interface changes work as expected perform the following process after you upgrade to 4.5.2:

Stop Spark.
Start Spark.
Restart the analytics node.

Issues fixed

Components	Release Notes
Analytics Service	Fixed an issue that caused the user interface to run slowly then shut down.
Analytics Service	Fixed a typo that displayed in an analytics error log file for data type mismatch issues: “Column type does match.” The error log now says, “Column type does not match.”
CMC	Fixed an issue where the description of the Max Cached Memory property in the Tenant Configuration of the CMC said that it included on- and off-heap memory, when it only includes off-heap memory.
Loader Service	In Release 4.5, loader service startup time was reduced by loading only a subset of columns into memory. Now, columns are only loaded when needed. As a result, the “Loaded Memory” column didn’t add up to the “Total” memory in the memory.jsp file. Now, the “Is In Memory” column has been updated to include a flag called “PARTIAL” to show which tables or schemas are loaded partially.
Schema	Schema page details now includes correct information about the loading state of a schema when it is waiting in the queue.
SQL Interface	In this release, the SQL interface was enhanced by increasing performance and reducing the number of configurations including, but not limited to better metadata handling, disabling throttling, and changing the default maximum row size for a SQL interface result to 1 MB (you can increase the size by using the sql.spark.bridge.max.row.size option.)
UI	Removed the non-functional “New” button in the dashboard scheduler screen.
UI	The “About” page in Incorta now contains hyperlinks to learn.incorta.com and docs.incorta.com.

Maintenance Pack 4.5.1

Upgrade Information

The following changes were made to the installation of Release 4.5, Maintenance Pack 1:

To use SQL Server 2008 with OpenJDK 11, you must update the JDBC driver to version 7.4.
For Windows installations only:
- Install Microsoft Visual C++ 2015 redistributable.
- Set the HADOOP_HOME environmental variable to <Incorta_installation_path>/IncortaNode/hadoop.
- Add to the PATH environmental variable: %HADOOP_HOME%/bin.
You must replace Spark with the new version bundled with Incorta and reapply any custom configurations you set to upgrade to Incorta release 4.5.
For Windows installations only:
- Install Microsoft Visual C++ 2015 redistributable.
- Set the HADOOP_HOME environmental variable to <Incorta_installation_path>/IncortaNode/hadoop.
- Add to the PATH environmental variable: %HADOOP_HOME%/bin.

Issues fixed

Component	Release Note
Charts	Incorta’s support of the world map did not include Cayman Islands. Updated the world map visualization to include the Cayman Islands GeoJSON.
CMC	Fixed an issue where you could not import a tenant from the CMC with Derby metadata.
Dashboard	Fixed an issue where a filter based on a presentation variable didn’t apply as expected.
Dashboard	Changed the default visualization from a bar chart to a table when users click “Explore Data” in business schema or physical schema and then navigate to the Analyzer UI.
Installer	Fixed an issue where the start-cmc.sh script did not work as expected after upgrading.
Loader Service	Prior to Release 4.5, two or more loader services could concurrently load two related schemas with joins. This could cause some of the joins to be overridden. Loading was enhanced across services by writing only one file at a time, when loading related schemas on separate loader services.
Loader Service	Fixed an issue where, after loading schema, a dashboard displays a system error, but after loading tables individually, the dashboard renders as expected.
Loader Service	Fixed an issue where the loading status hangs and you cannot stop loading the schema without restarting Incorta when the connection between the Incorta server and the metadata stops during a schema load.
Server	Fixed an issue where a loader job process produced an error that it was out of memory, but still showed a spinning circle after the loader job process was killed.
Server	Introduced a new setting in the Cluster Management Console to turn off auto-refresh of insights. Turning off auto-refresh at the tenant level allows you to disable queries while building and editing insights, so several users can edit multiple insights that return large volumes of data.
Server	Incorta now supports username for SMTP authentication for SMTP servers that use a non-email account to authenticate connections. Prior to Release 4.5.1, Incorta only supported sender email as SMTP user to authenticate SMTP server connection.
SSO	Fixed an issue where the rv parameter was missing in the server.xml file, causing the redirect login to log users out.
SQL Interface	Added the CMC option, Stream SQL interface with the tool tip “Stream SQL interface results between Spark and Incorta with no lag time.”