Active Alerts are not being displayed and cannot be acknowledged. Attempting to acknowledge displays the following error:
An internal error occurred -------------------------------------------------------------------------------- Message: Invalid column name 'placeholder'. -------------------------------------------------------------------------------- Information: The error ''Invalid column name 'placeholder'.'' occurred while running a SQL Query (see SQL in log file)
Cause
Resolution
To resolve this issue, follow the steps below:
1. Stop all Webtrends services except for the SQL Server service.
2. Connect to the system database using Microsoft SQL 2008 Management Studio.
3. Select the "New Query" button, then paste the following query into the query window and select the "Execute" button.
USE wt_sched; UPDATE wt_event SET profilename = NULL WHERE profilename = 'placeholder';
4. Close Management Studio and restart the Webtrends services.
5. Log into the Webtrends user interface and confirm that Active Alerts can now be viewed and acknowledged.