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:
- Using an SSH session log in to the Console as the root user.
- 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.
- Using an SSH session login to the Console as the root user.
- 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"}}]
Was this topic helpful?
Document Information
Modified date:
03 April 2020
UID
ibm16152499