Database stuck in the "Unloading" state

Products

• ISG Proxy

Issue/Introduction

The affected database appears to be in either a hung state or has experienced some form of corruption, hence its inability to load.

Resolution

To fix the reported issue, stop the Reporter from the SSH, and that should force the database to completely unload. This will ensure all the databases/log sources, including the affected one unloads completely.

Note 1: To not break/corrupt the preference.cfg file, ensure to wait until the Reporter completely stops and returns the "<Reporter> #" mode/prompt.

Start the Reporter again and wait until it's fully started and the databases and log sources and loaded again. If the affected database does not load but is in the "unload" state, attempt to load the database manually, following the guidance in the Tech. Doc. below.

https://techdocs.broadcom.com/us/en/symantec-security-software/web-and-network-security/reporter/11-0/rpac-intro/RPAC-Administration/Manage-Reporter-System-Settings/managedb.html

Note 2: Should the affected database still fail to load, the other options would be the below.

• Delete and recreate the database from scratch. Please see the guidance in the Tech. Docs. with the URLs below. 
  • https://techdocs.broadcom.com/us/en/symantec-security-software/web-and-network-security/reporter/11-0/app_deploy/delete-db.html
  • https://techdocs.broadcom.com/us/en/symantec-security-software/web-and-network-security/reporter/11-0/rpac-intro/Configuration/RPAC-Add-Database.html 
• Restore the Reporter to the last know good config. This restore will be to a last date when the affected database was known to be loaded and working well. For guidance, refer to the Tech. Article with the URL below.
  • https://techdocs.broadcom.com/us/en/symantec-security-software/web-and-network-security/reporter/11-0/ts_landing/ts_restoreconfig.html