Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register Now.

Home > Success Center > Web Help Desk (WHD) > Error when searching WHD tickets on an SQL Server database

Error when searching WHD tickets on an SQL Server database

Updated July 5, 2017

Overview

When you run a basic or advanced ticket search on a Web Help Desk deployment integrated with a Microsoft® SQL Server® database, the Web Help Desk Admin Console displays errors and the console becomes unresponsive. 

Environment

All Web Help Desk version

Cause

Web Help Desk is configured to fetch and display too many tickets in response to a query.

This issue can occur when using the LIKE search parameter, which uses wildcard characters and returns more responses than the system can process. .

Steps

Install the latest Web Help Desk hotfix (if available) through the through the SolarWinds Customer Portal. When completed, configure Web Help Desk and SQL Server to implement a full text search that uses the Contains search parameter, replacing the LIKE parameter.

Enable full-text search in Web Help Desk 

  1. Log in to the Web Help Desk server as an administrator. 
  2. Navigate to the Web Help Desk conf directory.
    Apple® OS X: /Library/WebHelpDesk/conf    
    Microsoft® Windows®: \Program Files\WebHelpDesk/conf    
    Red Hat®/CentOS™/Fedora Linux: /usr/local/webhelpdesk/conf
  3. Open the wrapper_template.conf file (for Windows systems) or whd.conf file (for OS X and Linux systems) in a text editor (such as Notepad).
  4. Add the following parameter to the file:
    DWHDSqlServerFulltextSearchEnabled=true
  5. Save and close the file.

Enable full-text search in SQL Server

  1. Follow the procedure in Adding SQL Full-Text Search to an existing SQL Server (© 2017 CBS Interactive, available at http://www.techrepublic.com/, obtained on February 17th, 2017.)
  2. Create full text indexes for the database tables.
  3. Log in to SQL Server Management Studio.
  4. Create full-text indexes for the database tables. 
    1. Select Full-Text Index > Define Full-Text Index.
    2. In the wizard, select the columns to include in the index.
    3. Save your changes and close SQL Server Management Studio.  

See the following resources for more information: 

 

Disclaimer: Any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.  You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.

Last modified

Tags

Classifications

Public