search cancel

Datamart Extraction Job Fails with ORA-00054 Error

book

Article ID: 188379

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

The Datamart Extraction job fails with the following error if it is initiated while a team record is in the process of being deleted: 

ORA-20000: Error in NBI_EXTRACT_SP - : ORA-20000: Error in NBI_CLEAN_DATAMART_SP: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

Environment

Release : 15.7.1

Component : CA PPM SAAS APPLICATION

Cause

The issue occurs because while the team and associated assignment records are being deleted, the system holds a lock on the NBI_EVENTS table. One of the first steps that the Datamart Extraction job attempts to complete is to truncate the corresponding NBI tables. If the Datamart Extraction job kicks off while the lock in the NBI_EVENTS table is still in place, it cannot truncate it and the the job fails. 

Resolution

Run the Datamart Extraction job again after the deletion of the team record completes.