How do I change the default port for scheduled reports in Webtrends Analytics 8.5x and later?


Webtrends Analytics 9.x
Webtrends Analytics 8.7
Webtrends Analytics 8.5


Webtrends uses port 7099 as its default port when exporting scheduled jobs. You want to change the port number to something other than 7099.


Execute the following queries:

UPDATE wtmaster.dbo.wt_globalsettings SET SettingValue= ‘http://servername:port’ WHERE SettingID=’37’;
UPDATE wtmaster.dbo.wt_app_confdata SET data=’http://servername:port’ WHERE data=’http://servername:7099′;
UPDATE wt_sched.dbo.wt_parameter
SET wt_sched.dbo.wt_parameter.value = ‘http://servername:port’
FROM wt_sched.dbo.wt_parameter
LEFT JOIN wt_sched.dbo.wt_parametertoken
ON wt_sched.dbo.wt_parameter.parametertokenid = wt_sched.dbo.wt_parametertoken.parametertokenid
WHERE wt_sched.dbo.wt_parametertoken.description = ‘serverurl’;

…where ‘http://servername:port’ is the name of your server and the port you want to change.

In the case of multiple servers for which only one server needs to be changed, replace the last line in the sequence above with the following line:

WHERE wt_sched.dbo.wt_parametertoken.description = ‘serverurl’ AND wt_sched.dbo.wt_parameter.value=’http://servername:7099′;

…where ‘http://servername:7099’ is the name of the specific server whose port you want to change.