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

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

2. Search for the lock file (starts with .revision_lock) and remove it.

Is the SFXAdmin still locked?

3. 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';

4. If the CONTROL_VALUE=1, change it to 0:

update CONTROL set CONTROL_VALUE=0 where CONTROL_GROUP='sfx_admin';

5. After the above steps you should be able to access the SFXAdmin.

• Article last edited: 27-Nov-2016