Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register now.

Home > Success Center > Web Help Desk (WHD) > WHD - Knowledgebase Articles > WHD error: Unable to obtain lock for Ticket

WHD error: Unable to obtain lock for Ticket

Updated January 4, 2018

Overview

Web Help Desk generates the following error: 

Unable to obtain lock for Ticket

Environment

WHD 12.0 and later

Resolution

Check the JOB_TICKET_ACTIVE_SESSION table for the Ticket number in the error. After you locate the ticket number, delete the row.

If you cannot locate the ticket number, run the following SQL statement:
SELECT F.JOB_TICKET_ID AS FIRST_TICKET_ID,F.MERGED_PARENT_TICKET_ID AS FIRST_TICKET_PARENT_ID,S.JOB_TICKET_ID AS SECOND_TICKET_ID, S.MERGED_PARENT_TICKET_ID AS SECOND_PARENT_ID, HE.ENTRY_TEXT, HE.ENTRY_DATE FROM JOB_TICKET as F JOIN JOB_TICKET as S ON S.MERGED_PARENT_TICKET_ID=F.JOB_TICKET_ID AND F.MERGED_PARENT_TICKET_ID = S.JOB_TICKET_ID JOIN HISTORY_ENTRY AS HE on F.JOB_TICKET_ID = HE.JOB_TICKET_ID WHERE HE.ENTRY_TEXT LIKE 'Merged in%' ORDER BY HE.ENTRY_DATE DESC;

Locate the ticket number and delete it (if listed).

If you cannot find the ticket number:

  1. Log in to Web Help Desk as an administrator.
  2. Click Setup > Tickets > Options.
  3. Under Tech Options, locate the following field:
    warn-to-allow.png 
  4. Click Allow, and then click Save. 

 

 

 

Last modified

Tags

Classifications

Public