Looping Exception - Resource Busy And Acquire With NOWAIT Specified Or Timeout Expired (Doc ID 1564918.1)

Last updated on JUNE 05, 2016

Applies to:

Oracle Communications Order and Service Management - Version 7.2.0 to 7.2.0 [Release 7.2]
Information in this document applies to any platform.

Symptoms

There are many repeated exceptions in OSM WebLogic Servers log files - Resource busy and acquire with NOWAIT specified or timeout expired

Customer finding "timeout" exception looping in the server logs of the Production Environment.

ERROR
-----------------------

Excerpt from the log below,

java.sql.SQLException: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)

 

BUSINESS IMPACT
-----------------------
Currently, the throughput on production is low and orders seem to be completing normally. However customer concerned that this will cause a performance degradation at higher throughput.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms