Metasys Advanced Reporting cache refresh or report execution may fail with 'Out of memory' or 'Memory pressure' messages in the SQL Server log - Metasys - LIT-1201645 - MS-ADSxxx-x - MS-ADXxxx-x - Server - ADS Server - ADX Server - 13.0

ADS/ADX Commissioning Guide

Product
Building Automation Systems > Databases and Data Servers > ADS Server
Building Automation Systems > Application Servers > ADX Server
Document type
Commissioning Guide
Document number
LIT-1201645
Version
13.0
Revision date
2023-10-12
Product status
Active

When running a report with the Metasys Advanced Reporting system, an out of memory or memory pressure message appears in the SQL Server log. This issue only occurs on a 32-bit system that uses the /pae parameter in the boot.ini file to enable SQL Server access to more than 4 Gb memory.

Enable the Address Windowing Extensions (AWE) option. For details, refer to this Microsoft article: https://technet.microsoft.com/en-us/library/ms190961(v=sql.105).aspx