Jobs stop processing and get stuck in a QUEUED or a LAUNCH ERROR status.
search cancel

Jobs stop processing and get stuck in a QUEUED or a LAUNCH ERROR status.

book

Article ID: 90118

calendar_today

Updated On:

Products

CA Automic Applications Manager (AM)

Issue/Introduction

Jobs stop processing and get stuck in a QUEUED or a LAUNCH ERROR status.

Environment

CA Automic Applications Manager - All Versions

Resolution

Symptoms

Jobs stop processing and get stuck in a QUEUED or a LAUNCH ERROR status.

 

 

Cause

The table(s) displayed in the error message have been locked by another user other than the Applications Manager user.  In the example error message below the SYS user is locking the AW_JOB_QUEUE_ACTIVITY and the SO_JOB_QUEUE tables.

 

jdbc:oracle:thin:@MACHINE.COM:1527:user:APPWORX
java.sql.SQLException: ORA-20056: Could not lock jobid 12668026 in 30 seconds in 30 tries status=31-INITIATED AW_JOB_QUEUE_ACTIVITY is locked by OraUser=SYS,OSuser=spt, audsid=2222222222, ospid=12345, program=sqlplus@somemachine(TNS V1-V3). current audsid=12345678.

SO_JOB_QUEUE is locked by OraUser=SYS,OSuser=APPWORX, audsid=111111111, ospid=, program=JDBC Thin Client. currentaudsid=12345678.
ORA-06512: at "APPWORX.AW5", line 509

 

 

Resolution

Please have your DBA unlock the tables mentioned in error message and restart Applications Manager.

Powered by Wolken Software