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 >