java.sql.SQLException: ORA-20067: Job not found in back_log or history

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

java.sql.SQLException: ORA-20067: Job not found in back_log or history

Environment

Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:

Resolution

Applicable to Applications Manager Versions:  v7.1, v8.0

Detailed Description and Symptoms

 

Error messages like the following pop up in the GUI:

 

ErrorMsg: AwE-5501 Error executing AwServer statement (1/21/14 8:30 AM)
Details: 37 API_GEN FUNCTION 10000 0 23 exec_fn_in exec_fn_out

java.sql.SQLException: ORA-20067: Job not found in back_log or history. Jobid 3227821.00
ORA-06512: at "APPWORXMD.AWAPI2", line 473

 

 

Solution

 

You may have to stop the processes and restart them in order to get rid of these messages.
stopso rmi
startso rmi

 

If this can't be done in production or it doesn't help, please contact Support to get a query to correct jobs with incorrect status in the history table.