KnowledgeBase - Error: Unknown column 'placeholder' in "where" clause in installations using MS SQL Server 2008
Article

Error: Unknown column 'placeholder' in "where" clause in installations using MS SQL Server 2008

« Go Back
Products
Webtrends Analytics 9.2
Webtrends Analytics 8.7d
Symptoms
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.

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

 
Was this article helpful?

Please tell us how we can make this article more useful.

Characters Remaining: 255