dcsimg

Address is not Valid when accessing the Webtrends user interface

Products

Webtrends Analytics 8.x
Webtrends Analytics 9.x

Issue

When trying to access the Webtrends user interface using Internet Explorer, you are redirected to http:/// and receive an error that “the address is not valid”. Accessing the ui in Firefox returns an error that “the url is not valid and cannot be loaded”.

Cause

This problem is caused by an invalid entry within the ProductInfoUrl field of the dbo.wt_accountsettingoverride table inside of the wtmaster database.

Resolution

To resolve the problem, you will need to delete all entries from this table.

1. Log in to the sql database with Microsoft SQL Server Management Studio
2. Select “New Query” from the upper left menu bar.
3. Paste the following into the new query window DELETE FROM [wtmaster].[dbo].[wt_AccountSettingOverride]
4. Click “Execute” in the menu above the new query window.
Once these actions have been performed, you should now be able to access the user interface without being redirected to an invalid url.

Further information:
Webtrends Analytics 8.5 and 8.5a use MS SQL Server Express 2005 by default:
Webtrends Analytics 9.x and 8.7d use MS SQL Server Express by default:
https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms