Novell Home

My Favorites

Close

Please to see your favorites.

How to update the AMPP Alarm link generated by the AnalyticsAlarm_ProcessTrustedAlarms Knowledge Script

This document (7010480) is provided subject to the disclaimer at the end of this document.

Environment

NetIQ AppManager 7.0.x
NetIQ AppManager 8.0.x
NetIQ AppManager Performance Profiler 4.1.x
NetIQ AppManager Performance Profiler 4.5

Situation

The hyperlink generated by the AnalyticsAlarm_ProcessTrustedAlarms Knowledge Script is incorrect and shows a link that is broken.

Resolution

The link is generated from values within the AMPP Database. This will need to be manually updated by accessing the AMPP database from SQL Server Management Studio.
 
On the machine hosting the database, or other machine that has SQL Server Management Studio installed perform the following:
 
  1. Open SQL Server Management Studio
  2. Click New Query
  3. Set the database context to the AMPP database (amppdb by default)
  4. Run the following query:

    SELECT N_VALUE FROM N_APPLICATION_PROPERTY
    WHERE N_KEY = 'WebappBaseUrl'
  5. You will see a URL with "http" in the results. To update the value to reflect a servername change or protocol change use the following update query. Replace the Question Mark (?) with the desired link to the AMPP console.

    UPDATE N_APPLICATION_PROPERTY
            SET N_VALUE = '?'
            WHERE N_KEY = 'WebappBaseUrl'
 
Example:
 
The Servername needs to be changed to amppdb.tbd.corp
Update statement with example:
 
UPDATE N_APPLICATION_PROPERTY
        SET N_VALUE = 'http://amppdb.tbd.corp:8080/ampp'
        WHERE N_KEY = 'WebappBaseUrl';
If a protocol change is needed from http to https then the following update would apply:
 
UPDATE N_APPLICATION_PROPERTY
        SET N_VALUE = 'https://w2k5-sql05.tbd.corp:443/ampp'
        WHERE N_KEY = 'WebappBaseUrl';

Cause

This is caused when the tomcat service hosting the AMPP console is moved to another machine, or a small change like enabling / disabling SSL cases the link to change.

Disclaimer

This Support Knowledgebase provides a valuable tool for NetIQ/Novell/SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.

  • Document ID:7010480
  • Creation Date:18-JUL-12
  • Modified Date:18-JUL-12
    • NetIQAppManager

Did this document solve your problem? Provide Feedback