Environment
NetIQ AppManager 7.0.x
NetIQ AppManager 8.0.x
NetIQ AppManager 8.0.x
NetIQ AppManager Performance Profiler 4.1.x
NetIQ AppManager Performance Profiler 4.5
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:
-
Open SQL Server Management Studio
-
Click New Query
-
Set the database context to the AMPP database (amppdb by default)
-
Run the following query:
SELECT N_VALUE FROM N_APPLICATION_PROPERTY
WHERE N_KEY = 'WebappBaseUrl' -
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:
Prior link is http://w2k5-sql05.tbd.corp:8080/ampp
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';
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';
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.