DWH_SYNC job is set to Cancelled by Scheduler

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Scheduler Orphan Cleanup script will set DWH SYNC job to Cancelled after BG restart, maintenance or sometimes in Clarity in some update operations as part of race condition. This causes Load DWH job to remain stuck in Waiting and data is not updated

STEPS TO REPRODUCE:

1. On a large dataset where DWH SYNC is enabled
2. Restart BG when DWH_SYNC is in Processing State

Alternate steps:

< This only happens on very large dataset where Project Create from Template is very slow. >

1. Go to MUX – Project Tiles
2. Create a new project from Template
3. Check DWH SYNC job status

 

Expected Results: DWH SYNC to not be set to Cancelled – let dwh initializer handle the job state

Actual Results: DWH SYNC is moved to Cancelled state. Load DWH is stuck in Waiting. DBA / Hosting team will be required to fix the issue

Environment

Clarity 16.4.0, 16.4.1, 16.4.2

Cause

DE204553

Resolution

In Review by Engineering

Workaround:

1. Disable feature DE176444_CLEANUP_ORPHAN_JOB_RUNS by running the command:
   admin toggle-feature DE176444_CLEANUP_ORPHAN_JOB_RUNS  0
2. Restart services