dcsimg

Workarounds for installing the Data Retention service

Products

Webtrends Analytics 8.7

Issue

Attempts at installing or upgrading the product fail when installing the Data Retention component.

Resolution

At the time of writing, no permanent solution exists to guarantee consistent success when installing the product, however the following steps may be helpful in making this possible.

1. When performing a fresh installation or installing other components on a server with an existing SQL Server 2005 or 2008 database, if the system database is not being installed on an instance, or the port isn’t being specified, ensure that in the “System Database Connection” step of the installation, the Connection Information specifies to “Use an existing Microsoft SQL Server 2005 or 2008 installation” and the “Instance:” and “Port:” fields are left empty. Only the Host field should be populated, and it will be greyed out.

2. When performing an upgrade, and Data Retention has caused a problem in the past, run the upgrade as follows:

Open a command line window and navigate to the extracted setup files.

Type the following command:

Setup SKIP_BETAS

This will launch the installer but omit the Data Retention service.

3. Install Data Retention manually.

If an attempt to install the product with the Data Retention service has already been made, resulting in failure, then there should be a setup.log within the installation folder with information relevant to performing a successful manual installation.

The needed information will appear in a line similar to the one below:

Setup [14:24:57]: Installing Data Retention Service: C:\WINDOWS\system32\msiexec.exe /i “C:\DOCUME~1\bocekp\LOCALS~1\Temp\1\Webtrends_8.7.4.122\msi\WebTrends Data Retention Services.msi” /qb! /l*v “C:\Program Files\WebTrends\logs\install\Data Retention Service 10-23-2009 14-24-57.log” INSTALLDIR=”C:\Program Files\WebTrends” SCHED_INSTANCE=”” SCHED_DB=”wt_sched” SCHED_PORT=”” SCHED_HOST=”PDXBOCEKP01″ WEBSERVICES_URL=”http://PDXBOCEKP01:7799″ RUN_TIME=”1/1/2009 01:00:00 AM” RUN_AFTER_START=”True” LOG_LEVEL=5 LOG_DIR=”C:\Program Files\WebTrends\logs” SERVICEACCT=****** SERVICEDOMAIN=”WEBTRENDS” SERVICEPASS=****** IGNORE_SYSTEMCHECK=TRUE REBOOT=ReallySuppress

The key portion of the above text is the following command. Pull the portion out of the above string that contains the following to ensure that you have the correct environmental settings. This will provide you with the command line process to install Data Retention manually. Thepaths, machine name, and port will need to be changed if necessary, andthe hashed username and password will require manual input.

C:\WINDOWS\system32\msiexec.exe /i “C:\DOCUME~1\bocekp\LOCALS~1\Temp\1\Webtrends_8.7.4.122\msi\WebTrends Data Retention Services.msi” /qb! /l*v “C:\Program Files\WebTrends\logs\install\Data Retention Service 10-23-2009 14-24-57.log” INSTALLDIR=”C:\Program Files\WebTrends” SCHED_INSTANCE=”” SCHED_DB=”wt_sched” SCHED_PORT=”” SCHED_HOST=”PDXBOCEKP01″ WEBSERVICES_URL=”http://PDXBOCEKP01:7799″ RUN_TIME=”1/1/2009 01:00:00 AM” RUN_AFTER_START=”True” LOG_LEVEL=5 LOG_DIR=”C:\Program Files\WebTrends\logs” SERVICEACCT=****** SERVICEDOMAIN=”WEBTRENDS” SERVICEPASS=****** IGNORE_SYSTEMCHECK=TRUE REBOOT=ReallySuppress