Acorn Advanced Analytics Version 3 - 2018.1 Release Notes

Introduction

We are happy to share the release notes for the Acorn Advanced Analytics Version 3 (AAA 2018.1).

Summary

This release includes several enhancements aimed at improving system stability and functionality, alongside fixing identified issues from previous versions.

New Features

The key highlights of the new features in this release include:

• Support for SQL Server 2016 compatibility.
• Improved performance and memory usage for Excel uploads, especially when handling large volumes of data.
• Enhanced validation procedures post database upgrade, ensuring data consistency.
• Support for HTTPS on IIS 8.0 and later, bolstering security measures.

Bug Fixes

Numerous bugs have been addressed in this release:

• Fixed regression issues related to configuration tools on SQL Server 2012 and 2014.
• Resolved errors that prevented the downloading of failed records from the General Ledger upload screen.
• Corrected AUC loading failures caused by deadlocks, ensuring UI responsiveness.
• SQL join issues leading to discrepancies in AAA Cube values were rectified.
• Warnings added for critical actions like deleting Global records to prevent data loss.

Release Notes

Ignite Release Notes PA5G AAA 2018.1

Upgrade and Installation Notes

The upgrade process involves various steps to ensure successful installation and migration:

• Check SQL Server firewall ports (e.g., TCP port 1433 must be open).
• Set the database compatibility level to SQL Server 2012 (110).
• Unzip the installer package before running the installation.
• Run installers with elevated permissions to avoid access issues.

Best Practices for Usage

It is recommended to validate the upgraded database thoroughly after migration to ensure that the results align with expected outputs.