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

    Error: SFXAdmin is not accessible, the database is being updated

    • Product: SFX
    • Product Version: 4
    • Relevant for Installation Type: Local

    Description

    When trying logging into the SFXAdmin, the following message is being displayed:

    “SFXAdmin is not accessible, the database is being updated Please try again later.”

    Resolution

    Check if any process that locks the Admin is currently running on the server using the following commands:

    ps -ef | grep rev-up
    ps -ef | grep rollback
    ps -ef | grep backup
    ps -ef | grep publish
    


    Is one of these processes currently running?

    If yes, the SFXAdmin should be locked until the end of the process.


    If not, search for the lock file and removed it:

    1. Move to tmp directory:
    cd /exlibris/sfx_ver/sfx4_1/tmp
    ls -lrta
    
    1. Search for the lock file (starts with .revision_lock) and remove it.

    Is the SFXAdmin still locked?

    1. Check if there is a lock in the database:
    mysql -usfxglb41 -p<mysql_password> sfxglb41 (for example: mysql -usfxglb41 -psfxglb41 sfxglb41)
    
    select * from CONTROL where CONTROL_GROUP='sfx_admin';
    

     

    1. If the CONTROL_VALUE=1, change it to 0:
    update CONTROL set CONTROL_VALUE=0 where CONTROL_GROUP='sfx_admin';
    
    1. After the above steps you should be able to access the SFXAdmin.

     


    • Article last edited: 27-Nov-2016