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

Document ID : KB000006981
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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  

Environment:
UCM 4.3
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.

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.