Load Data Warehouse job fails

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Problem:

Load Data Warehouse job fails with database lock ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired  

 

Steps to Reproduce:

This is an intermittent issue that occurs on multiple environments, usually on Incremental Load:

1. Schedule an Incremental Load Data Warehouse job few times per day
2. Check the job status in the Jobs - Log page 

 

Expected Result:

The Load Data Warehouse job completes every time.

 

Actual Result: 

The Load Data Warehouse job fails intermittently (sometimes once per month) with error ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired. Any Full or Incremental Load after this will also fail until the lock is removed

 

 

 

Cause

Cause: 

Reported as defect CLRT-81011

 

Environment

Release: 451-101-14.4-Clarity-Creator User License
Component:

Resolution

 

Resolution:

Resolved in PPM 15.2

Workaround:

Manual only: Contact the DBA to manually remove the lock from the specified table, then run Load Data Warehouse job - Full Load