Single Clarity Job is Stuck in Processing State

Products

• Clarity PPM SaaS

Issue/Introduction

We have a single Clarity job that is stuck in Processing for very long time. This can happen with Load Data Warehouse or Create Jaspersoft Users job
We canceled and delete from UI but still the new job will go to Waiting. 
Other jobs of different type may or may not be running. 

Environment

Release : All Supported Clarity releases

Resolution

Connect to the database. 
1. Identify the record stuck in CMN_SCH_JOB_CURR_RUNS, for this query the table:

select * from CMN_SCH_JOB_CURR_RUNS

2. Find the job that's stuck, the time you had started it. Note the ID in the first column, copy it. 

3. Now run the query:

Delete from CMN_SCH_JOB_CURR_RUNS where job_definition_id != -1;
Commit

4. Now you should be able to run the job again. No restart for BG is required. 

Additional Information

Note: Keep in mind that some jobs such as Time Slicing during rollover could take long time and this can be normal. They can appear to be Processing in UI for too long and truly be processing.