Clarity PPM: Job fails with error ORA-00054: resource busy and acquire with NOWAIT specified

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When executing a job, sometimes the following error message appears in the BG logs:

ORA-00054: resource busy and acquire with NOWAIT specified

 

Environment

All Clarity versions

Cause

The NOWAIT keyword forced a return to the command prompt because a resource was unavailable for a LOCK TABLE or SELECT FOR UPDATE command.
The error message that is displayed in the log file indicates that a table is locked. 

Resolution

1. Be sure to cancel and delete jobs having this error message.This should clear out the database session associated with the job.
2. Rerun the job