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

Products

• APPLICATION DELIVERY ANALYSIS
• SUPERAGENT

Issue/Introduction

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

Cause

Mysql database table corruption is the cause of this issue.

Environment

ADA 10.x / Windows 2008.

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.