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) > Java.exe*32 100% CPU Utilization - Email Looping

Java.exe*32 100% CPU Utilization - Email Looping

Table of contents

Overview

This article provides steps on how to fix when Java.exe*32 CPU Utilization spikes to 100% rendering WHD unusable.

Environment

WHD version 12.3

Steps

1. Run the query below to check for looping ticket:
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;

 

If ticket(s) are found..the following query must be executed in order to break the loop behavior:
UPDATE JOB_TICKET SET MERGED_PARENT_TICKET_ID = NULL WHERE JOB_TICKET_ID = <parentID>

 

2. Log in to the mailbox associated with WHD.

3. Move emails from Inbox to Temp folder.

4. Start Web Help Desk.

 

Last modified
09:39, 28 Mar 2017

Tags

Classifications

Public