ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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


Article ID: 6981


Updated On:


CA Unified Communications Monitor (NetQoS / UCM)


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  


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.


UCM 4.3


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:


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.