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

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

For products:
Webtrends Analytics 9.2a
Webtrends Analytics 8.7d

Last modified: 12/16/2010

Situation:
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)

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

    • Related Articles

    • "Authentication failed. Webtrends server error ID: 116"

      For products: Webtrends Analytics 9.2a Webtrends Analytics 8.x Webtrends Enterprise 7.x Webtrends Professional 7.x Webtrends Small Business 7.x Last modified: 8/6/2010 Situation: When attempting to export reports to e-mail, the following error ...

    • WebTrends server error ID: 100 on Scheduled Export

      For products: Webtrends On Demand Webtrends Analytics 9.2x Webtrends Analytics 8.x Last modified: 5/4/2011 Situation: This error will sometimes occur when performing a scheduled export and the text of the email will include this error number as well ...

    • Scheduled export fails and returns WebTrends server error ID: 98

      For products: Webtrends Analytics 9.2x Webtrends Analytics 8.x Last modified: 7/27/2010 Situation: A notification is received containing the following error message: Your WebTrends scheduled report could not be generated. The below error occurred ...

    • The Pages report shows secure pages using http, not https

      For products: Webtrends On Demand Webtrends Analytics 9.2x Webtrends Analytics 8.x Last modified: 3/1/2011 Situation: The pages report shows secure pages with the "http" protocol, when "https" is the expected protocol. Solution: By default, Webtrends ...

    • What are the advantages of using the v10 tag?

      Products Webtrends On Demand Question What are the advantages of using the v10 tag? Answer     Webtrends Streams This only works with the v10 tag.     Social analytics features built-in Webtrends is the leader in social analytics: in addition to our ...