Release notes

Type Date App Description Ticket Number for SOC 2 Compliance
 Important August 21, 2020

Analytics 14.1

Analytics 14

Robots Agent 14.1

Robots Agent 14

Analytics Exchange 14.1

Analytics Exchange 14

SAP Connector issue related to licensing Using the SAP Connector in Analytics 14.0.x or 14.1.x may result in a "SapDriverLicenseInvalid" error. If you encounter this error, upgrading to Analytics 14.2.x will resolve the problem.

If you are experiencing the same issue with Robots or Analytics Exchange, contact Support for assistance.

 CS-10562
 General Comments August 2019 Analytics Exchange 14.1.2 The 14.1.2 patch corrects the following customer-reported issues

The patch updates the analytic engine to version 14.1.2. To install the patch update, see Update AX Server to Analytics 14.1.2.

  
 Fixed August 2019 Analytics Exchange 14.1.2 Delimited file import Characters were being omitted from the import of a delimited file if the file contained a delimiter character at the end of the line (end of the record). The issue has now been resolved. (AN-7700).  
 Fixed August 2019 Analytics Exchange 14.1.2 ACL connector for Oracle The ACL connector for Oracle was failing to import a portion of the specified data, resulting in blank values in some fields. An issue with the driver used by the connector was causing the problem. The issue has now been resolved. (AN-7653)  
 Fixed August 2019 Analytics Exchange 14.1.2 Oracle import WebSocket error Certain imports containing integer fields performed by the ACL connector for Oracle were failing with a WebSocket error. An issue with the driver used by the connector was causing the problem. The issue has now been resolved. (AN-7672)  
 General Comments May 19, 2018 Analytics Exchange 14.1

Rebranding and product name changes ACL Services is now Galvanize, and our cloud-based platform, ACL GRC, is now called HighBond. ACL Analytics is now simply Analytics.

How do these rebranding changes affect Analytics Exchange and Analytics? The short answer is that Analytics Exchange 14.1 and Analytics 14.1 continue to function in the same way as previous versions of the products, with the addition of the new features and enhancements described in these release notes.

Analytics scripts No change. Scripts authored in previous versions of Analytics continue to run in Analytics Exchange 14.1 and Analytics 14.1.

Release highlights Updated version of Java, support for new ACLScript functionality released with Analytics 14.1.

    
 Important May 19, 2018 Analytics Exchange 14.1 If your organization has made any changes to the AX Server configuration files in App\TomCat\conf, you need to back up the files before upgrading AX Server, and then manually restore the changes. Learn more  
 Important May 19, 2018 Analytics Exchange 14.1 Support added for Oracle 19c database server. Learn more  
 Important May 19, 2018 Analytics Exchange 14.1 Java updated to Amazon Corretto 8.212.04.2 (OpenJDK 8u212). Learn more  
 New May 19, 2018 Analytics Exchange 14.1 Support for new commands in Analytics 14.1:
  • TRAIN
  • PREDICT
  • IMPORT MULTIDELIMITED
  
 New May 19, 2018 Analytics Exchange 14.1
  • New ACL Connectors for importing data from the following external sources:
    • Rsam
    • RESTful APIs
    • SharePoint

    • For more information about the new commands and connectors, see the Analytics 14.1 release notes.

    		  
     Enhanced May 19, 2018 Analytics Exchange 14.1 Export to Excel field-length limit removed.  
     Enhanced May 19, 2018 Analytics Exchange 14.1 Classify key field length increased.  
     Enhanced May 19, 2018 Analytics Exchange 14.1 For information about additional enhancements, see the Analytics 14.1 release notes.  
     Fixed May 19, 2018 Analytics Exchange 14.1 Analytic script password values Encrypted password values saved with analytic parameter sets were lost on upgrade to AX 14.0. This issue has been resolved and stored password values are now preserved during an AX upgrade to 14.1. (AX-3820)  
     Fixed May 19, 2018 Analytics Exchange 14.1 Tomcat vulnerability addressed A moderate vulnerability with Tomcat Apache TomEE 7.0.5 (Tomcat version 8.5.32) was mitigated by an update to an AX configuration file. This mitigation approach was the one recommended in the Apache documentation. (AX-3827)  
     Fixed May 19, 2018 Analytics Exchange 14.1 Analytic job on an AX Engine Node Once an analytic job started on an AX Engine Node it could not be canceled. Canceling a job on an Engine Node now works correctly. (AX-3703)  
     Fixed May 19, 2018 Analytics Exchange 14.1 Domain name or user name with spaces AX users with a space in their domain name or their user name were unable to run analytic scripts. This issue has now been resolved. (AX-3780)  
     Fixed May 19, 2018 Analytics Exchange 14.1 Data Access not working after upgrade to AX 14.0 A mismatch of the required version of MoreLinq.dll could occur after an upgrade to AX 14.0. The mismatch prevented the ACCESSDATA command from working. This issue has now been resolved. (AX-3806)  
     Fixed May 19, 2018 Analytics Exchange 14.1 GET /activity in AX V1 REST API The GET /activity API request was not working in AX 14.0, and returning a 404 - page not found error. This issue has now been resolved. (AX-3875)  
     General Comments November 2018 Analytics Exchange 14 Analytics Exchange 14 includes upgrades to Apache TomEE and PostgreSQL, as well as support for new ACLScript functionality released with ACL Analytics 14.  
     Important November 2018 Analytics Exchange 14 If you are renewing an expired subscription, you must deactivate and then reactivate your instance of AX Server to complete the renewal process. Learn more    
     Important November 2018 Analytics Exchange 14 PostgreSQL upgraded to version 9.6. If you maintain PostgreSQL and AX Server on different machines, you must upgrade PostgreSQL first. Learn more  
     Important November 2018 Analytics Exchange 14 Support added for Oracle 18c database server. Learn more  
     Important November 2018 Analytics Exchange 14 Java updated to JRE version 8u181 (AX Server and AX Client). Learn more  
     Important November 2018 Analytics Exchange 14 Apache TomEE upgraded to version 7.0.5 (Tomcat version 8.5.32). Learn more  
     New November 2018 Analytics Exchange 14 New treemap chart displays hierarchical, tree-structured data as a set of nested rectangles. Learn more  
     New November 2018 Analytics Exchange 14 Support for new commands in ACL Analytics 14:
    • CLUSTER
    • OUTLIERS
    • FUZZYJOIN
    • SET RETRYIMPORT
    		  
     New November 2018 Analytics Exchange 14 New ACL Connectors for importing data from the following external sources:
    • JIRA
    • JSON
    • LDAP
    • Marketo
    • Open Exchange Rates
    • SAP
    		  
     New November 2018 Analytics Exchange 14 For more information about new commands, see the ACL Analytics 14 release notes.  
     Enhanced November 2018 Analytics Exchange 14 New chart selection dialog for visualizations. Learn more  
     Enhanced November 2018 Analytics Exchange 14 Support for enhancements to the following commands in ACL Analytics 14:
    • IMPORT MULTIEXCEL
    • APPEND
    • ACCESSDATA
    		  
     Enhanced November 2018 Analytics Exchange 14 For more information about enhanced commands, see the ACL Analytics 14 release notes.  
     Unresolved November 2018 Analytics Exchange 14 If you are using an Oracle database with AX Server and you require an encrypted connection using SSL, you must remove the following entry from the aclDatabase.xml configuration file and then restart the Analytics Exchange Service: 
    <entry key="connectionProperties">oracle.net.ssl_cipher_suites=(SSL_DH_anon_WITH_3DES_EDE_CBC_SHA,SSL_DH_anon_WITH_RC4_128_MD5)</entry>

    Learn more

    		  
     Unresolved November 2018 Analytics Exchange 14 If you are using an Oracle database with AX Server and you require an encrypted connection using SSL, you must run the provided Oracle database scripts manually instead of through the AX Server installation process. Learn more  
     Unresolved November 2018 Analytics Exchange 14 If you are upgrading to version 14 and you have manually customized the settings in the aclDatabase.xml configuration file, properties that contain spaces may cause errors during the upgrade process. If this occurs, you can recover your settings from the installation backup. For assistance, contact ACL Support.  
     Unresolved November 2018 Analytics Exchange 14 If you are trying to upgrade from version 5.0.0 to version 14.0.0, you cannot upgrade directly. First, upgrade version 5.0.0 to version 13.0.0. Then upgrade version 13.0.0 to version 14.0.0. For assistance obtaining the installer files required to do this, contact ACL Support.  
     General Comments September 2018 Aalytics Exchange 13.1.1 If you have not installed the 13.1 patch, running the 13.1.1 patch includes the 13.1 updates.  
     Fixed September 2018 Aalytics Exchange 13.1.1 The patch installer that updates the analytic engine to 13.1.1 corrects the following issue:
    • The SQL Server connector does not support named instances and you cannot use the format "serverName\instanceName" when establishing a connection.
    • After running the 13.1.1 patch installer, you can connect to named instances using the format "serverName\instanceName".
    		  
     Important August 2018 Analytics Exchange 13.1 The 13.1 engine update is a patch update to make the analytic engine that runs inside AX Server compatible with ACL Analytics version 13.1. This update does not include upgrades to core AX Server components.

    The patch installer is larger than a typical engine update installer due to the security enhancements in the ACL connectors. Download times and install times may be slightly longer due to increased size.

    If you run the 13.1 engine update installer and subsequently want to uninstall AX Server, do the following:

    1. Uninstall AX Server following the documented procedure. For more information, see Uninstall AX Server.
    2. Manually remove the ACL\ACL Connectors and ACL\App\Data Access folders from the machine.
    		  
     Important August 2018 Analytics Exchange 13.1 As part of the 13.1 engine update, components with known vulnerabilities are removed or identified. The following Microsoft components have known vulnerabilities and can be manually removed:
    • Microsoft Access Database Engine 2010
    • three files that are part of Microsoft Visual C++ 2008:
      • msvcm90.dll
      • msvcp90.dll
      • msvcr90.dll

      The .dll files are located in a subfolder in the C:\Windows\WinSxS directory.

      Analytics Exchange running the 13.1 analytics engine does not use these components and uninstalling them does not impact the application.

    Caution

    Only uninstall the Microsoft components if you know that they are not used by any other application on your server.

    		  
     Important August 2018 Analytics Exchange 13.1 The Concur connector no longer supports authentication without a Concur access token. Any scripts currently configured with user credentials that do not include a token must be updated to use a Concur access token.  
     Important August 2018 Analytics Exchange 13.1 The Concur connector now requires that you specify the host name of Concur's API server when connecting. As of the 13.1 patch update, this value is "https://www.concursolutions.com". Existing scripts that use the native Concur connector and an access token continue to work. However, if you are using a DSN connection, you must specify a host name in the Host field for the connection to succeed.  
     Important August 2018 Analytics Exchange 13.1 The 13.1 engine update is a patch update to make the analytic engine that runs inside AX Server compatible with ACL Analytics version 13.1. This update does not include upgrades to core AX Server components.

    The patch installer is larger than a typical engine update installer due to the security enhancements in the ACL connectors. Download times and install times may be slightly longer due to increased size.

    		  
     Enhanced August 2018 Analytics Exchange 13.1 The patch installer that upgrades the analytic engine to 13.1 updates the following components to more secure versions:
    • a more recent version of Microsoft Visual C++ 2010 Redistributable Package (10.0.40219.325 replaces 10.0.40219.1)
    • Microsoft Access Database Engine 2016 replaces Microsoft Access Database Engine 2010
    		  
     Enhanced Analytics Exchange 13.1 The patch installer that upgrades the analytic engine to 13.1 improves the security of the following connectors:
    • Amazon DynamoDB
    • Apache HBase
    • Concur
    • MongoDB
    • Amazon Redshift
    • Apache Hive
    • Couchbase
    • Oracle
    • Apache Cassandra
    • Apache Spark
    • Google BigQuery
    • Salesforce
    • Apache Drill
    • Cloudera Impala
    • Microsoft SQL Server
    • Teradata
    		  
     Fixed August 2018 Analytics Exchange 13.1 The patch installer that updates the analytic engine to 13.1 corrects the following customer-reported issues:
    • Python commands are running twice when called
    • Concur connector performance is improved when filtering data using '<', '>', and '>=' operators on the following fields: Last_Modified_Date, Create_Date, User_Defined_Date, Submit_Date, Processing_Payment_Date, Paid_Date. (ADA-1226)
    		  
     Fixed April 2018 Analytics Exchange 13.0.3

    The patch installer that updates the analytic engine to 13.0.3 corrects the following customer-reported issues:

    • Using the RECOFFSET( ) function on a table with an index applied can produce unreliable results
    • The SAVE TABLELIST command doesn't display all the tables after a manual import of multiple Excel worksheets
    • The UNMATCHED join type fails with certain combinations of data and ACLScript syntax

    • Garbled text appears when using the ACCESSDATA command to import Arabic data from an IBM AS/400 server

    You can run this patch against version 13.0.0 or 13.0.1 to upgrade your server to the latest version of the analytic engine. Note that there is no version 13.0.2.

    To install the patch update, see Update AX Server to Analytics 13.0.3

    		  
     Fixed December 2017 Analytics Exchange 13.0.1

    The patch installer that updates the analytic engine to 13.0.1 corrects the following customer-reported issues:

    • The APPEND command is duplicating a single record after every block of 10,000 records in the output table
    • The dialog box that appears when overwriting an index on a table is not showing the correct information
    • In the ACCESSDATA command, removing a system-generated space before the SOURCE or SQL_QUERY keywords causes the command to fail
    		  
     General Comments November 2017 Analytics Exchange 13 Analytics Exchange 13 includes upgrades to Apache TomEE and PostgreSQL, and includes support for new ACLScript functionality released with ACL Analytics 13.  
     Important November 2017 Analytics Exchange 13 If you are renewing an expired subscription, you must deactivate and then reactivate your instance of AX Server to complete the renewal process. Learn more  
     Important November 2017 Analytics Exchange 13 PostgreSQL upgraded to version 9.3.19. If you maintain PostgreSQL and AX Server on different machines, you must upgrade PostgreSQL first. Learn more  
     Important November 2017 Analytics Exchange 13 Java updated to JRE version 8u141. Learn more  
     Important November 2017 Analytics Exchange 13 Apache TomEE upgraded to version 7.0.3 (Tomcat version 8.5.11). Learn more  
     Important November 2017 Analytics Exchange 13 Central Authentication Service (CAS) upgraded to version 5.1.4  
     New November 2017 Analytics Exchange 13 New system variable AXRunByUser available in scripts and stores the user name of the account that runs the analytic in the format "domain\username".  
     New November 2017 Analytics Exchange 13 New settings in aclAuditExchange.xml that disable CSV exports from AX Web Client and table connections from Add-In for Excel. Learn more  
     New November 2017 Analytics Exchange 13 APPEND command that combines records from multiple tables into a new table.  
     New November 2017 Analytics Exchange 13 New ACL Connectors for importing data from the following external sources:
    • Active Directory
    • Email
    • Exchange
    • Twitter
    • ServiceNow
    • MySQL
    		  
     New November 2017 Analytics Exchange 13 Classical variables sampling (CVS) with stratified populations (CVSPREPARE, CVSSAMPLE, CVSEVALUATE)  
     New November 2017 Analytics Exchange 13 RCOMMAND that passes a list of fields to an external R script for analysis and creates a new table in ACL.  
     Enhanced November 2017 Analytics Exchange 13 You can now change the supported TLS versions that the ACL Connector for Analytics Exchange server component uses to connect with AX Server. Learn more  
     Enhanced November 2017 Analytics Exchange 13 Limited support for Python versions other than the default supported version 3.5.x. Learn more  
     Enhanced November 2017 Analytics Exchange 13 Import multiple Excel worksheets using a single IMPORT command.  
     Enhanced November 2017 Analytics Exchange 13 The ALLFIELDS parameter has been added to the IMPORT EXCEL command, allowing you to import all fields in an Excel worksheet without having to define them individually.  
     Enhanced November 2017 Analytics Exchange 13 The Presort option on the Join command now uses the specified-field approach to sorting introduced in ACL 12.5.  
     Enhanced November 2017 Analytics Exchange 13 Cross-tabulating now supports numeric key fields. Previously only character key fields were supported.  
     Enhanced November 2017 Analytics Exchange 13 R functions now accept variables when specifying the R script or R code to run.  
     Enhanced November 2017 Analytics Exchange 13 Connections to Concur now include a User Param setting that imports data from the expense module for specific user accounts, or for all accounts.  
     Fixed November 2017 Analytics Exchange 13 ACLCrystal.dll file removed from analytic_engine folder on AX Server.  
     Fixed November 2017 Analytics Exchange 13 CAS logging omits expected items so that cas.log file does not grow unnecessarily.  
     Fixed November 2017 Analytics Exchange 13 Notification that deactivation and reactivation required when renewing a subscription.  
     Fixed November 2017 Analytics Exchange 13 testOnBorrow = true setting added to AclAuditExchangeQuartzPool in ACL\App|Tomcat\conf\tomee.xml to avoid Quartz errors that require service restart.  
     Fixed November 2017 Analytics Exchange 13 Unused port 8009 disabled.  
     Fixed November 2017 Analytics Exchange 13 Re-activation when cloning an instance of AX Server can be accomplished through the AX Server Configuration web application and Launchpad.  
     Fixed November 2017 Analytics Exchange 13 Salesforce and Amazon Redshift connectors now support SSL version 1.0.2.  
     Unresolved November 2017 Analytics Exchange 13 If you are using an Oracle database with AX Server and you require an encrypted connection using SSL, you must remove the following entry from the aclDatabase.xml configuration file and then restart the Analytics Exchange Service: 
    <entry key="connectionProperties">oracle.net.ssl_cipher_suites=(SSL_DH_anon_WITH_3DES_EDE_CBC_SHA,SSL_DH_anon_WITH_RC4_128_MD5)</entry>

    Learn more

    		  
     Unresolved November 2017 Analytics Exchange 13 If you are using an Oracle database with AX Server and you require an encrypted connection using SSL, you must run the provided Oracle database scripts manually instead of through the AX Server installation process. Learn more  

    Historical release notes are available on request.

    Analytics Exchange 14.1 Server Admin Guide