ORMB V2.9 Upgrade - PUPL Batch Is Constantly Giving "ORA-00060: Deadlock Detected.." Error
(Doc ID 2751404.1)
Last updated on FEBRUARY 12, 2021
Applies to:
Oracle Financial Services Revenue Management and Billing - Version 2.9.0.0.0 and laterInformation in this document applies to any platform.
Goal
On : 2.9.0.0.0 version, ENV - Environment
ORMB v2.9 upgrade - PUPL batch is constantly giving "ORA-00060: deadlock detected.." error.
After ORMB v2.9 upgrade we are finding that the PUPL batch is giving the below error constantly. The batch and one of the threads remains in "In progress" status and does not error out.
*****************************************************************************************
java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource
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:446) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) ~[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]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
*****************************************************************************************
How can this be resolved?
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 |