Load Data Warehouse is Cancelled after upgrade to 16.3.2

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

After upgrade to 16.3.2, the Load Data Warehouse Scheduled jobs get cancelled. After upgrade, the admin has to reschedule them manually

STEPS TO REPRODUCE:

1. Get a 16.3.1 Clarity on PostgreSQL 
2. Note Load Data Warehouse job is scheduled
3. Note down the CMN_SCH_JOBS.ID for the instance
4. Upgrade Clarity to 16.3.2

Expected Results: Load Data Warehouse jobs to remain Scheduled or Paused as they were prior to upgrade

Actual Results: Load DWH jobs are Cancelled and the admin has to reschedule them

Environment

Clarity 16.3.2

Cause

DE171026

Resolution

• Working as expected. This is expected change due to the fact there is a change in job definition
• This is expected for all jobs with change in job definition upon upgrade

Workaround: Reschedule the Load DWH jobs manually in UI

Best Practices:

• Check job status before and after upgrade in Home - Reports and Job
• If you notice any Cancelled jobs after upgrade, reschedule them