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

Document ID:  TEC1828221
Last Modified Date:  06/07/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Unified Communications Monitor

Releases

  • CA Unified Communications Monitor:Release:4.3

Components

  • NQUCM - UNIFIED COMMUICATION MONITOR:NQUCM
Symptoms:

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.

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >