When opening UCM reports, an error generates referencing full tables.

book

Article ID: 6981

calendar_today

Updated On:

Products

CA Unified Communications Monitor (NetQoS / UCM)

Issue/Introduction

When opening a UCM report, an error may occur.  It will reference the page and then a temp table that is created to process the data.  The error generated is that the temp table is full.  The error will look similar to the following:

An error occurred!
Control(80227): Calls Overview
System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> NetQoS.VoIP.Inspector.Database.DBConnectionException: w3wp :
Failed to execute SQL command after 1 attempts.
The table 'tmp_calls_raw' is full, Code=1114, ErrorCode=0x80004005. Length=2294  

Cause

In large environments, the MySQL my.ini settings for tmp_table_size and max_heap_table_size need to be increased to handle the larger sizes.

Environment

UCM 4.3

Resolution

Open the my.ini file located in the <install directory>\CA\MySql.

Search for and change the tmp_table_size and max_heap_table_size values to:

tmp_table_size=8G
max_heap_table_size=8G

Save the my.ini files and restart the CA UCM MySQL service.

Additional Information

If the values were already in place or if errors occur again, please contact CA Support.