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

Document ID : KB000004001
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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.