search cancel

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

book

Article ID: 88432

calendar_today

Updated On:

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.