My Oracle Support Banner

BILLING Batch Few Thread Went In To Error With Error Of ORA-04021: Timeout Occurred While Waiting (Doc ID 2818998.1)

Last updated on NOVEMBER 19, 2021

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.8.0.0.0 and later
Information in this document applies to any platform.

Goal

Monthly billing batch's few thread failed with below error when the batch was running. We verified that only BILLING batch running when the error occured. It Looks like Billing threads somehow stepped over each other at some point, as no other job is running at that time. Attaching the awr report and log files for reference. Please let us know the root cause of this issue.

Caused by: java.sql.SQLException: ORA-04021: timeout occurred while waiting to lock object

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:441) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:436) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4C7Ocommoncall.processError(T4C7Ocommoncall.java:86) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]

What is the cause of this error?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.