AMAdmin_DBHealth generating an error stating the Management Service is not connected (NETIQKB73394)

  • 7773394
  • 29-Feb-2012
  • 02-Mar-2012

Environment

NetIQ AppManager 7.0.x

Situation

AMAdmin_DBHealth is generating a false positive stating the Management Service is not connected to the repository event though an SP_WHO2 or SQL Activity monitor shows it is running and connected.

Resolution

To update the DSN within the ODBC tool:

  1. Launch the ODBC Data Source Administrator
    1. On 32bit systems you can use Start > Administrative Tools > Datasources ODBC
    2. On 64bit systems, you should launch the tool from %windir%\SysWOW64\odbcad32.exe
  2. Click on QDBms, then click the Configure button, then click Next
  3. If the DSN is configured for Windows, click Next otherwise provide a SQL username and password with access to the QDB then click Next
  4. Make sure the checkbox for "Change the default database to:" is checked
  5. From the dropdown select your QDB
  6. Click Next, Finish then OK
  7. Restart the NetIQ AppManager Management Service

The issue should now be resolved.

Cause

This occurs because the default database for the Management Service's DSN, QDBms, is set for a database other than the QDB.

Additional Information

Formerly known as NETIQKB73394