Maintenance Packs

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

Important

When upgrading, please review and follow the procedures outlined in the Upgrade to Incorta 5.0 documentation.


Maintenance Pack 5.0.5

What’s New?

  • A new setting to enable or disable data sampling in the Analyzer
  • Grand Totals feature in the Analyzer to use groups and respect aggregated filters

Issues fixed

Dashboard

  • Fixed an error that resulted from entering search values in the filters search bar
  • Fixed an issue that caused a dashboard rendering error
  • Fixed a case where sharing a dashboard without sharing the underlying schema caused an insight with hierarchy configuration to display an error

Analyzer

  • Fixed an issue with displaying the Data Sampling hint message in the Analyzer
  • Fixed an issue that caused incorrect aggregations for columns using an Average formula

Visualizations

  • Fixed an issue with displaying URLs in Advanced Map visualization when opening Manage Filters and Prompts

SQLi

  • Resolved a performance issue with SQLi when running different simultaneous queries
  • Fixed an issue that caused queries to fail during analysis in the 5.0.3 release

Miscellaneous

  • Fixed an issue that caused slow performance of ADLS when reading data from parquet
  • Fixed an issue with the JDBC driver in handling Incorta-on-Incorta tables
  • Fixed an issue with race condition that prevented the update of a task state
  • Fixed an issue that caused the schema notification logs not to display the schema name nor the alert name

Maintenance Pack 5.0.4

What’s New?

  • Improved performance of the Spark Materialized View
  • SharePoint Connector now also supports SharePoint Online
  • Applied drill-down filters are now maintained between dashboard tabs
  • Update the Data Agent version
  • Users with View Only access can now use the “Create Email Notification” for a schema
  • Improved performance of Parquet when loading table segments
  • Improved performance of the Metadata schema update
  • Improved the performance of several processes when reading columns
  • Timeout settings added to cluster configuration
  • Improved schema retrieval performance when opening the Analyzer

Issues fixed

Dashboard

  • Fixed an issue that caused inconsistent behavior when applying string filters using Contains or IN
  • Resolved an issue where a directory search would display results outside the desired search parameters
  • Resolved an issue where double values would not be rounded when using a rounded currency format
  • Fixed an issue that could occur in some when applying filters to a dashboard

Business Schema

  • Fixed an issue where Business Schemas would sometimes not be displayed

Physical Schema

  • Fixed an issue that would occur when reading a schema during the startup phase of a load
  • Fixed an issue with Materialized Views using Python when upgrading from Incorta versions before 5.0.2
  • Fixed an issue that would cause a delayed failure of schema loads from the Salesforce connector
  • Fixed an issue that would cause a table to lock resources during a load
  • Fixed an issue that could cause failed load of tables when connecting to an MS SQL source
  • Fixed an issue that could occur when extracting data due to a caching expiration
  • Fixed an issue where incremental loads would not display the correct number of rows in some conditions
  • Fixed an issue with data lake sources input stream during data load
  • Fixed an issue where a data agent disconnect would occur when loading data lake sources
  • Fixed an issue where users could create Materialized Views with duplicate column names
  • Fixed an issue where frequent schema loads could cause performance issues

SQLi

  • Fixed an issue with the STR function when used within a Case-When expression
  • Fixed an issue where data displayed in Tableau would have missing rows

Miscellaneous

  • Fixed a formatting issue when exporting for CSV and XLSX
  • Fixed a date format issue when exporting to CSV
  • Fixed an issue that could occur when parsing a service on Zookeeper

Maintenance Pack 5.0.3

What’s New?

  • Enhanced the Incorta Service to support a Loader Service warmup mode and an Analytics Service warmup mode
  • Enhanced the Azure® Data Lake Store (ADLS) file system to use Hadoop by default
  • Enhanced the unique and primary key index read and write to support the same buffer size as the data column
  • Created an add_months User Defined Function (UDF) in Apache Spark™ 2
  • Supporting telemetry logs upon failures
  • Supporting connection reset for ADLS file system

Issues fixed

Dashboard

  • Fixed an issue where creating a dashboard with two longitude or latitude layers resulted in an incorrect map rendering

Schema

  • Fixed an issue that caused the failure of the Sealink Big Table schema
  • Fixed some ADLS and DataLake issues related to schema load failure

SQLi/Notebook

  • Fixed an issue in the Notebook template to permit reading files with more than 8192 characters
  • Fixed an issue where SQLi was not working due to a memory size limit

Miscellaneous

  • Fixed some Mapbox issues related to string dimensions, static zoom, and fit bounds for an initial load
  • Fixed an issue that caused ADLS Hadoop API slow compaction
  • Introduced a workaround for Azure native libraries memory issue
  • Fixed an issue that caused an incremental load failure for data stored on ADLS due to an ArrayIndexOutOfBounds exception
  • Fixed a performance issue in stopping the Analytics Services
  • Fixed an issue where enabling reading columns in groups resulted in a disordered log context

Maintenance Pack 5.0.2

What’s New?

  • Support for CData connectors, including the following:

  • Self-Sync Setup without backend access - Phase 1
  • Support SSL and SASL configurations for Apache Kafka connector from the Incorta Direct Data PlatformTM
  • Support for shared drives and folder on the Google Drive connector
  • Enhanced the default Spark shuffling configurations
  • Increased the default schema pool size to 5
  • Enhanced the ADLS file system support
  • Supporting OAuth for some connectors
  • Honored date and numerical formats in CSV and XLSX downloads and email delivery

Issues fixed

Dashboard

  • Fixed an issue where selecting a dashboard from a search result list with multiple dashboards that share the same name displayed the wrong dashboard
  • Fixed an issue where selecting a default value for a prompt resulted in an error due to prompt dependency
  • Fixed an issue where drill down to a date part was not working
  • Fixed an issue where insights broke after upgrade due to some insight settings
  • Fixed an issue where removing the file name from a scheduled job prevented editing the scheduled job afterwards
  • Fixed the dashboard search result panel orientation on the mobile view
  • Fixed an issue in the dashboard search where failure to load needed joins caused the search to fail
  • Fixed caching for tabular insights
  • Fixed an issue where trying to sort table data did not work in the dashboard view after scrolling down through the insight
  • Fixed an issue with dashboard prompts with date variables that caused wrong evaluation of the date variable when the dashboard consumer was in a timezone different from that of Incorta Server
  • Fixed an issue with insight measure filter where default boolean operator was not saved properly when using a formula
  • Fixed an issue that caused the failure of downloading embedded insights through VPN special setup
  • Fixed a problem where dashboard drill down option did not appear if the user had a filter on the same dimension that the user was drilling into
  • Stopped caching time-based session variables

Schema

  • Fixed an issue in extracting List and User Defined Type (UDT) column types in Cassandra
  • Fixed an issue in ADLS source extraction when using non-primitive data types
  • Fixed an intermittent issue in compaction on Google Cloud Storage (GCS)
  • Fixed an issue where a formula depending on a join that was not loaded into memory caused schema update to fail

Administration

  • Fixed an issue that caused exporting tenants to fail on GCS
  • Fixed an issue where performing an upgrade prevented users from using their SSO providers to sign in and required manual steps to allow it

SQLi/Notebook

  • Some fixes for failing queries if subqueries did not have an alias name

Miscellaneous

  • Fixed a case where restoring a version when Backup frequency was set to 5 minutes didn’t display the Current Version
  • Fixed a case that caused the failure of sending to Google Sheets using data destinations when Prompt Selections in Excel Export was enabled
  • Enhanced some error messages
  • Minor ML library fixes
  • Fixed an issue with schema notification scheduler that caused it to halt after long running time
  • Some logging optimizations

Maintenance Pack 5.0.1

What’s New?

  • Supported DataLake connector in Data Agent
  • Supported business view formula columns in aggregate filters
  • Honored subtotal flags in XLSX and HTML downloads and sending to email
  • WAF compliance changes to the exporting tenant endpoint
  • Encrypted credentials provider for cloud file systems
  • Enhanced dashboard search to show the relevant results according to the keywords

Issues fixed

Dashboard

  • Fixed an issue where table rows failed to render on scroll after upgrading to Chrome Version 88.0.4324.96
  • Fixed an issue in aggregate insights where subtotals were displayed although they were disabled in the insight settings
  • Fixed an issue with flat table showing extra invalid record if subtotals were enabled
  • Fixed an issue with Dynamic Hierarchy drill down that prevented it working
  • Fixed a case where extra empty columns were displayed on Pivot tables
  • Fixed an issue that caused the failure of rendering a dashboard with a presentation variable that depended on a session variable that started or ended with +, -, /, *, %, ^, =, >, <, or !
  • Fixed query plan rendering issue when there were Japanese characters in the schema or table names
  • Fixed an issue that caused charts with no dimensions to be sent in emails with color formats other than Incorta’s

Schema

  • Fixed an issue where schema loads stuck on ADLS

Administration

  • Increased the public APIs query endpoint pagination range to include Long range

SQLi/Notebook

  • Fixed a case where Spark-SQL Query got stuck in Spark SQL Materialized Views (MVs)
  • Allowed static MV configurations for Zeppelin with Spark 3
  • Fixed an issue where a Tableau service user was able to see all schema and tables
  • Fixed an issue with SQLi on Spark 3 where the executors were not terminated when the application shut down
  • Fixed a Tableau connector issue where tables were discovered without showing schema name

Others

  • Fixed some Azure Data Lake Store (ADLS) and Google Cloud Storage (GCS) performance issues
  • Fixed an issue with session invalidation with SSO users when they opened new Incorta tabs
  • Fixed some Data Agent issues and enhancements

© Incorta, Inc. All Rights Reserved.