Tools

When Searching a specific Ticket in the Web Help desk, the Console suddenly becomes sluggish and unresponsive

This article described when searching a specific ticket in the web help desk, and the console suddenly becomes sluggish and unresponsive.

First published date

10/20/2020 12:24 AM

Last published date

10/20/2020 12:24 AM

Overview

In this issue, the Request Detail (QUESTION_TEXT) column contains infinite white space and characters. The application was unable to return all data when searching from the console, leading to suddenly sluggish and become unresponsive.

Product section

Web Help Desk

Cause

Request Detail is having an infinite white space and characters causing the Web Console to crashed

Resolution

Set the Request Detail to blank, run the query below:
-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

UPDATE JOB_TICKET SET QUESTION_TEXT = '' WHERE JOB_TICKET_ID = <insertticketidhere>;

Legal Disclaimer
Scripts are not supported under any SolarWinds support program or service. Scripts are provided AS IS without warranty of any kind. SolarWinds further disclaims all warranties including, without limitation, any implied warranties of merchantability or of fitness for a particular purpose. The risk arising out of the use or performance of the scripts and documentation stays with you. In no event shall SolarWinds or anyone else involved in the creation, production, or delivery of the scripts be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the scripts or documentation.