Applications Manager error java.sql.SQLException: ORA-04021: timeout occurred while waiting to lock object

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

The following error is seen in the Agent or RMI log alongside one or more Jobs Aborting or going to Launch Error

XXXXX15_OAE_SJ2: .DBAccess: checkError 4021
XXXXX15_OAE_SJ2: AwE-5001
XXXXX15_OAE_SJ2: SQL Error: 4021
XXXXX15_OAE_SJ2: .AxOptions: NoErrorMsgProperties=false
ErrorMsg: AwE-5001 Database Query Error 
Details: getConnection
 null
java.sql.SQLException: ORA-04021: timeout occurred while waiting to lock object 

 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)
 at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:675)
 at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:448)
 at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
 at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
 at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:383)
 at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:776)
 at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:432)
 at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:553)
 at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:254)
 at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
 at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
 at java.sql.DriverManager.getConnection(DriverManager.java:664)
 at java.sql.DriverManager.getConnection(DriverManager.java:208)
 at com.appworx.server.sql.AxConnectionPool.getConnection(AxConnectionPool.java:369)
 at com.appworx.server.sql.DBAccess.getConnection(DBAccess.java:1537)
 at com.appworx.server.sql.DBAccess.A(DBAccess.java:1444)
 at com.appworx.server.sql.DBAccess.getLoginConnection(DBAccess.java:1427)
 at com.appworx.server.sql.DBAccess.getProcedureData(DBAccess.java:1052)
 at com.appworx.server.sql.CommonDB.getProcedureData(CommonDB.java:377)
 at com.appworx.agent.generic.D.A(Procedure.java:88)
 at com.appworx.agent.generic.B.A(GenericAgent.java:465)
 at com.appworx.agent.generic.B.R(GenericAgent.java:550)
 at com.appworx.agent.generic.B$_A.B(GenericAgent.java:960)
 at com.appworx.agent.AbstractSpawnJob.doRun(AbstractSpawnJob.java:102)
 at com.uc4.be.threading.AbstractWorker.run(AbstractWorker.java:367)
 at java.lang.Thread.run(Thread.java:748)

Environment

Release : 9.3

Component : APPLICATIONS MANAGER

Cause

Oracle specific error

Resolution

Please refer error message and information such as time of error, DB host/IP, and login information to DBA team for further review. The database admin should be able to review and resolve the error or contact Oracle if needed.