Error: Unknown column ‘placeholder’ in “where” clause in installations using MS SQL Server 2008


Webtrends Analytics 9.x
Webtrends Analytics 8.x


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)


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 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.

Further Information
How do I install the stand-alone version of SQL Server 2008 Management Studio