Performance Analyzer 5G AAA 2019.1 Release Notes

Introduction

We are happy to share the release notes for the Performance Analyzer 5G | Acorn Advanced Analytics Version 3.0 (PA5G AAA 2019.1).

Summary

This release includes several significant enhancements and bug fixes aimed at improving stability and functionality for our users. Key highlights include:

New Features

• Retry mechanism implementation when connectivity to SQL Server is lost during AUC import.
• Improved validation for CSV file uploads, with user-friendly error messages for limit violations.
• Enhanced performance for loading transactions on impacted databases.

Bug Fixes

• Fixed orphan records issue in the AAA v3 datamart when altering scenario time periods.
• Resolved upload failures for data transactions under specific modes.
• GL amounts have been updated to allow billions worth of data entries now.

Release Notes

PA5G AAA 2019.1 Release Notes

Platforms Supported

The release supports multiple platforms including:

• Database Server:
• Microsoft SQL Server 2017 and 2016 (with Service Pack 1), both in Compatibility mode 130.
• Application Server:
• Windows Server 2012 R2 and 2016.
• Client Configuration:
• Windows 7 (SP2), 8.1 (Update 2), and Windows 10.
• Compatible web browsers include Internet Explorer 11 and Mozilla Firefox (v35 or newer).

Upgrade and Installation Notes

• Ensure SQL Server instances are configured to allow specific firewall ports (e.g., TCP port 1433).
• Follow best practices during the upgrade to avoid discrepancies in database migrations.
• Both AAA and PA5G installers require elevated permissions during installation.

Key Bug Fixes with Detailed Descriptions

• Orphan Records: Addresses the issue of orphan records left in the AAAv3 datamart upon changing a scenario's time period.
• CSV Upload Errors: Enhanced error handling during CSV file uploads to prevent SQL Server errors when data exceeding character limits is uploaded.
• Statistics Update: Time Period input tables now correctly update statistics during AUC imports.

Known Issues

• Cost allocation issues may occur when corporate and facility costs are mixed in the same process.
• SSAS permissions may reset after reprocessing cubes.
• Timeout may occur during time period deletions for extensive periods.