Load Data Warehouse job fails

Article Id: 4219
Status: Published
Updated On: 14-02-2018 08:19
Legacy Id: TEC1035172
Products:
CLARITY PPM FOR ITG , CA Project & Portfolio Management , CLARITY PPM FEDERAL , CA Project & Portfolio Management SAAS , STARTER PACK-CLARITY PPM
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