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.
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.
If the values were already in place or if errors occur again, please contact CA Support.