Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

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

WHD error: Unable to obtain lock for Ticket

Created by Jesus Relingado, last modified by MindTouch on Jun 23, 2016

Views: 13 Votes: 1 Revisions: 4

Updated June 20, 2016

Overview

This article provides steps to resolve the following WHD 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. When you have found the Ticket number, delete the row.

 

  • If you did not find it:

a. Run the following SQL statement below:

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;

b. Look for the Ticket number in question and delete it if listed. 

If not, go to Setup > Tickets > Options and change When an attempt is made to edit a Ticket already being edited in another session from Warn to Allow.

c. Save your changes. 

 

 

 

Last modified
05:13, 23 Jun 2016

Tags

Classifications

Public