IBM Support

QRadar Application (App) is locked with error "The application is currently locked by another request."

Troubleshooting


Problem

QRadar App is currently "locked" when attempting to upgrade, delete, or reinstall the App.

Symptom

Unable to upgrade, delete, or reinstall the App. You get an error "The application is currently locked by another request." 

Diagnosing The Problem

To confirm the App is locked:
  1. Using an SSH session log in to the Console as the root user.
  2. Type the command: psql -U qradar -c "select id,name,status,task_status,lock,errors from installed_application;"
Note: The 'lock' field has a timestamp of when the app was locked. The 'status' is "RUNNING".

Resolving The Problem

To unlock any of the Apps, which have a date and time stamp in their "Lock" column.
  1. Using an SSH session login to the Console as the root user.
  2. Type the command: psql -U qradar -c "update installed_application set lock=null where id=<application id>;"
Note: If there are multiple Apps that need to unlock you need to change the <application id> for each and run the command.
To check that the Apps have been unlocked successfully run the command: psql -U qradar -c "select id,name,status,task_status,lock,errors from installed_application;"

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSBQAC","label":"IBM Security QRadar SIEM"},"ARM Category":[{"code":"a8m0z000000GnbvAAC","label":"QRadar->Apps"}],"ARM Case Number":"","Platform":[{"code":"PF016","label":"Linux"}],"Version":"QRadar 7.3.3","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Document Information

Modified date:
03 April 2020

UID

ibm16152499