Jobs Getting Stuck in Processing Status in Table CMN_SCH_JOBS

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Some of the jobs get stuck in PROCESSING status in the CMN_SCH_JOBS table without having a corresponding record in CMN_SCH_JOB_RUNS.

This behavior causes no new jobs getting triggered for those that are stuck in Processing status. At the same time, it is also observed that records are left behind in CMN_SCH_JOB_LOGS.

Steps to Reproduce:

1. Schedule main Clarity jobs.
2. Ensure Remove Job Logs and Report Library entries job scheduled with below parameters and running every 5 min to allow to be reproduced quickly:
   JOB AGE FOR DELETE: 0
   REPORT AGE FOR DELETE: 0
3. Allow run as scheduled for some time.
4. Notice some jobs will get stuck in Processing status.

Expected Results: It should not leave jobs in Processing status.

Actual Results: It leaves jobs in Processing status.

Environment

Clarity 16.2.3, 16.3.0

Cause

DE160990

Resolution

This issue is fixed in Clarity 16.3.1 and 16.2.3.3 (16.2.3 Patch 3) 

Workaround: Restart BG service.