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


  • CA Unified Communications Monitor


  • CA Unified Communications Monitor:Release:4.3



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  

UCM 4.3

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.

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


Not what you were looking for?

Search Again >

Product Information

Support by Product >


Join a Community >

Chat with CA

Just give us some brief information and we'll connect you to the right CA ExpertCA sales representative.

Our hours of availability are 8AM - 5PM CST.

All Fields Required


We're matching your request.

Unfortunately, we can't connect you to an agent. If you are not automatically redirected please click here.

  • {{message.agentProfile.name}} will be helping you today.

    View Profile

  • Transfered to {{message.agentProfile.name}}

    {{message.agentProfile.name}} joined the conversation

    {{message.agentProfile.name}} left the conversation

  • Your chat with {{$storage.chatSession.messages[$index - 1].agentProfile.name}} has ended.
    Thank you for your interest in CA.

    Rate Your Chat Experience.


agent is typing