First of all, check the content status of the installed_application db using this command:
psql -U qradar -c “Select id,name,hub_id,content_status,file_location from content_package;”
Then, change the faulty entires to content_status=6 using this command:
psql -U qradar -c ” update content_package set content_status=6 where id=XXX;”
If we’re talking about a large number of failed install in the extension management logs:
We will first see all of the logs with content_status=5 (failed status code):
psql -U qradar -c “Select id,name,content_status from content_package where content_status=5;”
Store all the IDs in a text file.
Check to see if it works:
for i in cat /root/ids.txt; do psql -U qradar -c “Select id,name,content_status from content_package where id=$i” ; done
Set the content_status to 6 for all the faulty entries:
for i in ‘cat /root/ids.txt’; do psql -U qradar -c “update content_package set content_status=6 where id=$1” ; done
Check to see if it was updated:
for i in cat /root/ids.txt; do psql -U qradar -c “Select id,name,content_status from content_package where id=$i” ; done