Products
Webtrends Analytics 8.7
Issue
When upgrading the product, the following message displays:
Error 1920. Webtrends-Data Retention Service failed to start.
The options are to “Retry” or “Cancel” but selecting “Retry” is never successful, and clicking “Cancel” causes the upgrade to fail. The upgrade then rolls back and removes the services, crippling the installation.
Error 1920. Webtrends-Data Retention Service failed to start.
The options are to “Retry” or “Cancel” but selecting “Retry” is never successful, and clicking “Cancel” causes the upgrade to fail. The upgrade then rolls back and removes the services, crippling the installation.
Cause
This results from three tables not populating in the wtmaster database when the upgrade scripts are run.
The tables missing data are as follows (all three are typically empty):
wt_Database
wt_DatabaseInstance
wt_DatabaseInstanceModule
Resolution
The following SQL queries will add the tables to the database. As each installation may potentially be different, the highlighted text may need to be modified to conform to the affected installation. Note also that if the first attempt at running the query fails, the first record record will increment in the wt_DatabaseInstance table, causing the DatabaseInstanceID to automatically increment. If this happens, this value in the second query set will need to be incremented prior to attempting the query again.
When the error occurs, leave the error on the screen and open SSMS. It can be opened from a remote system if preferred. Run the queries, verify the tables populated successfully, close Managment Studio, then click “Retry” in the error dialog box.
use wtmaster
INSERT INTO wt_DatabaseInstance (ServerID, InstanceName, Description, ServerDataDirPath, ServerIndexDirPath, ServerLogDirPath)
VALUES (‘1’, ‘WTSYSTEMDB’, ‘System Database’, ‘C:\Program Files\WebTrends\common\database\SQLExpress\MSSQL10.WTSYSTEMDB\MSSQL\DATA’, ‘C:\Program Files\WebTrends\common\database\SQLExpress\MSSQL10.WTSYSTEMDB\MSSQL\DATA’, ‘C:\Program Files\WebTrends\common\database\SQLExpress\MSSQL10.WTSYSTEMDB\MSSQL\DATA’)
SET IDENTITY_INSERT wt_DatabaseInstanceModule ON
INSERT INTO wt_DatabaseInstanceModule (DatabaseInstanceModuleID, ModuleID, DatabaseInstanceID, IsDefault)
VALUES (‘1′, ’16’, ‘1’, ‘True’)
INSERT INTO wt_DatabaseInstanceModule (DatabaseInstanceModuleID, ModuleID, DatabaseInstanceID, IsDefault)
VALUES (‘2′, ’19’, ‘1’, ‘True’)
INSERT INTO wt_DatabaseInstanceModule (DatabaseInstanceModuleID, ModuleID, DatabaseInstanceID, IsDefault)
VALUES (‘3′, ’22’, ‘1’, ‘True’)
SET IDENTITY_INSERT wt_DatabaseInstanceModule OFF
SET IDENTITY_INSERT wt_Database ON
INSERT INTO wt_Database (DatabaseID, DatabaseInstanceModuleID, DatabaseName)
VALUES (‘1’, ‘3’, ‘wtMaster’)
INSERT INTO wt_Database (DatabaseID, DatabaseInstanceModuleID, DatabaseName)
VALUES (‘2’, ‘2’, ‘wtMaster’)
INSERT INTO wt_Database (DatabaseID, DatabaseInstanceModuleID, DatabaseName)
VALUES (‘3’, ‘1’, ‘wt_sched’)
When the error occurs, leave the error on the screen and open SSMS. It can be opened from a remote system if preferred. Run the queries, verify the tables populated successfully, close Managment Studio, then click “Retry” in the error dialog box.
use wtmaster
INSERT INTO wt_DatabaseInstance (ServerID, InstanceName, Description, ServerDataDirPath, ServerIndexDirPath, ServerLogDirPath)
VALUES (‘1’, ‘WTSYSTEMDB’, ‘System Database’, ‘C:\Program Files\WebTrends\common\database\SQLExpress\MSSQL10.WTSYSTEMDB\MSSQL\DATA’, ‘C:\Program Files\WebTrends\common\database\SQLExpress\MSSQL10.WTSYSTEMDB\MSSQL\DATA’, ‘C:\Program Files\WebTrends\common\database\SQLExpress\MSSQL10.WTSYSTEMDB\MSSQL\DATA’)
SET IDENTITY_INSERT wt_DatabaseInstanceModule ON
INSERT INTO wt_DatabaseInstanceModule (DatabaseInstanceModuleID, ModuleID, DatabaseInstanceID, IsDefault)
VALUES (‘1′, ’16’, ‘1’, ‘True’)
INSERT INTO wt_DatabaseInstanceModule (DatabaseInstanceModuleID, ModuleID, DatabaseInstanceID, IsDefault)
VALUES (‘2′, ’19’, ‘1’, ‘True’)
INSERT INTO wt_DatabaseInstanceModule (DatabaseInstanceModuleID, ModuleID, DatabaseInstanceID, IsDefault)
VALUES (‘3′, ’22’, ‘1’, ‘True’)
SET IDENTITY_INSERT wt_DatabaseInstanceModule OFF
SET IDENTITY_INSERT wt_Database ON
INSERT INTO wt_Database (DatabaseID, DatabaseInstanceModuleID, DatabaseName)
VALUES (‘1’, ‘3’, ‘wtMaster’)
INSERT INTO wt_Database (DatabaseID, DatabaseInstanceModuleID, DatabaseName)
VALUES (‘2’, ‘2’, ‘wtMaster’)
INSERT INTO wt_Database (DatabaseID, DatabaseInstanceModuleID, DatabaseName)
VALUES (‘3’, ‘1’, ‘wt_sched’)