Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Cannot execute error appearing instead of SFX menu

    • Article Type: General
    • Product: SFX
    • Product Version: 4

    Problem Symptoms:
    Server ran out of disk space but now has sufficient space
    Error message appearing instead of menu:
    DBLayer::Base::DBEngine::_execute_single_update: Cannot execute INSERT INTO
    VALUES (?,NOW())
    Table './sfxlcl41/SFX_REQUEST' is marked as crashed and should be repaired

    SFX_REQUEST table is corrupt

    To repair the SFX_REQUEST table:
    1. Log in to the UNIX environment as the affected local instance user
    2. Type: da
    3. ./server_admin_util
    4. Select menu option 4 Database maintenance
    5. Select menu option 3 REPAIR MySQL tables
    6. At the prompt for which tables, enter SFX_REQUEST

    Category: Server Administration (SFX)

    Subject: SFX

    • Article last edited: 10/17/2013