Products
Webtrends Analytics 9.x
Issue
In the Webtrends user interface, under Administration > Monitoring > Alerts, Active Alerts are not displayed. Instead, the following error is shown:
Unknown column ‘placeholder’ in “where” clause.
Resolution
For installations using Microsoft SQL server as the database, perform the steps below:
1. Stop all Webtrends services except the SQL server database service.
2. Log into MS SQL Management Studio and connect to the Webtrends system database.
3. Select “New Query” and paste the following query into the query pane, then press the “Execute” button.
USE wt_sched;UPDATE wt_event SET profilename = NULL WHERE profilename = ‘placeholder’;
4. Restart the Webtrends services and log into the Webtrends user interface to confirm that Active Alerts are now available.
For installations using MySQL as the database, perform the steps below:
1. Stop all Webtrends services except for the MySQL database.
2. Open a command line window and navigate to the following folder:
Webtrends\common\database\mysql\bin\
3. Execute the following command, then hit Enter:
mysql -u -p
4. Enter the MySQL password when prompted, then enter the following command and hit Enter:
use wt_sched;
5. Enter the query below, followed by Enter:
UPDATE wt_event SET profilename = NULL where profilename = ‘placeholder’;
6. Type quit to exit the MySQL command shell.
7. Restart the Webtrends services and log into the Webtrends user interface to confirm that Active Alerts are now available.
Microsoft SQL Server Management Studio can be downloaded from Microsoft at the following URL:
https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms