How do I disable the prompt to update Java when viewing reports in Webtrends?

Products

Webtrends Analytics 8.1.x
Webtrends Analytics 8.0x

Cause

When attempting to view reports in Webtrends, Java displays a prompt to update.

Resolution

To disable the prompt to update follow the steps below.

Create a backup of your MySQL database by making a copy of the following directory:

\Webtrends\common\database\mysql\data

1. Open a command prompt.

2. Navigate to the following location:

\Webtrends\common\database\mysql\bin

3. Log into the MySQL database using the following syntax:

mysql -h localhost -u-p -Dwtmaster

…where is the name of the MySQL user account. Enter the password when prompted, then hit Enter.

4. Run the following Select statement, then hit Enter:

SELECT c.id, p.profile_name, s.section_name, t.key_name, c.data FROM wt_app_profiles AS p, wt_app_sections AS s, wt_app_tokens AS t, wt_app_confdata AS c WHERE p.id = c.profile_id AND s.Id = c.section_id AND t.id = c.key_id AND profile_name = “docutilcfg.ini” AND section_name = “default” AND key_name = “applet_classid” ORDER BY p.profile_name, s.section_name, t.key_name;

This will display an ID (possibly more than one).

5. Update the following field using the Select statement below. The id used will be the one found in step 4:

UPDATE wt_app_confdata SET data=”clsid:8AD9C840-044E-11D1-B3E9-00805F499D93″ WHERE id=

6. If multiple values are found in step 4, run step 5 for each value found.

7. Restart the WebTrends – User Interface service.

You should now be able to log in and view reports without being prompted to download Java.