NetIQ AppManager Control Center Command Queue Service (CQS) is stuck in “Warning” state in the Control Center Console (CCUI)

  • Document ID:7011666
  • Creation Date:21-Jan-2013
  • Modified Date:02-Apr-2013
    • Micro Focus Products:
      AppManager

Environment

NetIQ AppManager Enterprise 8.0.1
NetIQ AppManager Enterprise 8.0
NetIQ AppManager Enterprise 7.0.1

Situation

You receive a "Warning" notification in the Control Center Console for the Command Queue Service (CQS) after removing and re-adding a QDB from the Control Center Console's 'Manage Repositories' tool.

Resolution

In order to resolve this issue, please complete the following steps:

  1. Launch SQL Server Management Studio

  2. Run the following query against the NQCCDB:

    select * from HealthCheck

  3. From the results pane make note of the HealthCheckID or ID's that the modification time is not current for.

  4. Delete the HealthCheckID or ID's that the modification time is not current by running the following query against the NQCCDB:

    Delete Health Check where HealthCheckID = X

    Replace X with the HealthCheckID that you retrieved during Step 2 above.

  5. Re-start of the CQS service.

Cause

If you delete a QDB from Control Center, there is a process running in the background that cleans up all references to that QDB from the Control Center Database (NQCCDB).  If that process is not given enough time to clean-up after the QDB was removed, and the QDB is then re-added before the clean-up process can complete, this issue will occur.