Customer is unable to login to the super agent web console.

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

Products

  • CA Application Delivery Analysis
  • CA Application Delivery Analysis Multi-Port Monitor

Releases

  • CA Application Delivery Analysis:Release:10.0
  • CA Application Delivery Analysis:Release:10.1
  • CA Application Delivery Analysis:Release:10.2
  • CA Application Delivery Analysis:Release:10.3
  • CA Application Delivery Analysis:Release:10.4
  • CA Application Delivery Analysis:Release:9.2
  • CA Application Delivery Analysis:Release:9.2 SP1
  • CA Application Delivery Analysis:Release:9.3

Components

  • NQSPRA
Symptoms:

When the customer tries to login to SuperAgent web console he/she sees the following error.

Server Error in '/SuperAgent' Application.

Can't open file: 'combinations.MYI' (errno: 144)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: CoreLab.MySql.MySqlException: Can't open file:
'combinations.MYI' (errno: 144)

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Cause - 'combinations.MYI' Table is corrupt in the database

Environment:
ADA 10.x / Windows 2008.
Cause:

Mysql database table corruption is the cause of this issue.

Resolution:

Solution:

    1. Open Command Prompt

    2. Login to Mysql

      mysql -P3308 super

    3. desc combinations - This command should tell you that the table is corrupt

    4. repair table combinations:

      repair table combinations;
      +--------------------+--------+----------+----------+
      | Table              | Op     | Msg_type | Msg_text |
      +--------------------+--------+----------+----------+
      | super.combinations | repair | status   | OK       |
      +--------------------+--------+----------+----------+
      1 row in set (0.03 sec)



  1. Exit

Try logging into the web console again.

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 >

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

connecting

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.

    {{chat.statusMsg}}

agent is typing