Version 2020.2 Patches
This section details the fixes and enhancements in patch releases for Axiom Software version 2020.2. For assistance with any patch, you can contact Support using Syntellis Central.
Axiom Software patches are cumulative. All fixes and enhancements included in prior patches are included in the current patch.
IMPORTANT: This is not the most recent major version of Axiom. Contact Axiom Support to upgrade to the current version.
This patch includes an updated publisher certificate for Axiom Software signed by Kaufman Hall, to replace the previous certificate signed by Kaufman Hall. Note the following:
-
If your organization has configured Microsoft Excel to require add-ins to be signed by a trusted publisher, then you must install the new certificate on client machines in order to run the Axiom Excel Client. Axiom Support can provide this certificate to clients on request.
-
When installing this client update, some users may encounter the Windows SmartScreen prompt due to an unknown publisher. If this occurs, you can click More Info to verify that the publisher is Syntellis, then click Run Anyway to install.
No platform-specific changes were made in this patch. See the separate product release notes for information on any product-specific changes.
This patch contains updates to the data query engine.
No platform-specific changes were made in this patch. See the separate product release notes for information on any product-specific changes.
This patch contains back-end changes intended to improve performance for cloud systems.
This patch contains back-end changes intended to improve performance for cloud systems.
The following issues were fixed in this patch:
-
61012: In certain situations, File Processing and Process Plan File tasks with heavy loads may fail with a "schema changed" error.
-
61761: Model processing for Axiom Intelligence reporting may fail with a timeout error when processing large partitioned tables.
This patch contains some model processing improvements for Axiom Intelligence reporting.
The following issues were fixed in this patch:
- 57094: The Delete Rows transform step in imports may fail if the target table for the transform is a reference table that other tables have lookups to.
The following issues were fixed in this patch:
- 56336: The "Advanced Options" section is no longer visible in certain File Processing Scheduler tasks.
This patch contains some system configuration enhancements intended to improve performance when refreshing data for an Axiom Intelligence Reporting model.
The following issues were fixed in this patch:
- 54961: Newly created Axiom Intelligence reports cannot be saved.
- 55264: Performance may be slow for certain Axiom queries that use column filters.
- 55280: An ambiguous column error may occur when running an Axiom query with a configuration that includes column filters and a table with multiple lookups to the same reference table.
The following issues were fixed in this patch:
- 53445: Executing Save Type 3 causes table caches to be unnecessarily invalidated.
- 53470: An error may occur when running an Axiom query if the query references a calculated field in the filter and the calculated field consists of more than 400 columns.
The following issues were fixed in this patch:
- 52122: When using the Filter Wizard in the Web Client, if you attempt to filter the values of a selected column, the filter is not applied and instead the filter text displays in the values area.
- 52390: If a calculation in a Data Grid component references a column that has no matching data, the calculation returns zero instead of the expected results.
- 52405: If a calculated field is used in the data filter of a Fixed Report component, an error occurs attempting to fetch the data.
- 52613: An object reference error may occur when attempting to run an import in an Axiom Cloud system after upgrading the Cloud Integration Service to 2020.2.13.
- 52593: After changing the SAML authentication configuration for an Axiom Cloud system, an error may occur trying to log into the system via SAML.
NOTE: If you are currently running the 2020.2.13 version of the Axiom Cloud Integration Service, you should upgrade the service as part of installing this patch.
The following issues were fixed in this patch:
- 51429: Numbers in formatted grids may display incorrectly if the grid uses lightweight auto-submit and an edited cell is fully scrolled off-screen and then scrolled back.
Additionally, Swedish translations were updated in the software.
The following enhancements are in this patch:
-
A new system configuration setting, DefaultOracleFetchSizeKb, is now available to control the fetch size when importing data from an Oracle database. By default, this is set to 1024KB (1MB). If this setting is changed, IIS should be reset on the Axiom Application Server to ensure that the cached value is not used.
The following issues were fixed in this patch:
- 51344: A "method not found" error may occur when running a 2019.x product version in platform version 2020.2.
Additionally, French and Dutch translations were updated in the software.
The following enhancements are in this patch:
-
You can now optionally display process tasks in the Process task pane by description instead of by plan code. This option is configured per step in the Display Settings for Process Task Pane section, using the new option Sort by Dimension Description. By default, this option is disabled, so tasks will continue to display by plan code for any existing processes.
New option to display tasks by description
Process task pane showing tasks by description instead of plan code
NOTE: If this option is enabled, it only affects the display of tasks in the Process task pane. When you complete a task from the task pane, the Process Action dialog continues to display tasks by plan code and description.
-
The task listings in the Process task pane now have the option to expand the list when the number of available process tasks exceeds the default height of the list. When you click Expand, the list expands to up to three times the default height, so that you can see more tasks without scrolling. You can then click Collapse to return the list to the default height.
New option to expand the list of tasks
Expanded list of tasks
The following issues were fixed in this patch:
- 50680: If an Axiom query uses a column filter such as 1=2, the query fails with an error about a bad conditional expression instead of returning zeros.
- 50685: Exporting a very large formatted grid from an Axiom form to Excel takes much longer in versions 2019.4 and up.
- 50706: If a calculated field is listed in both the data filter and the field definition of an Axiom query, an "ambiguous column" error occurs.
- 50788: If a sheet name in the File Processing settings is configured to only use a token—such as
[Current_Value]—the configuration is erroneously flagged as invalid.
