Datamart Extraction Job Fails with ORA-00054 Error
Article ID: 188379
Clarity PPM SaaS
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
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.
Release : 15.7.1
Component : CA PPM SAAS APPLICATION
Run the Datamart Extraction job again after the deletion of the team record completes.