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

Document ID : KB000088432
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
java.sql.SQLException: ORA-20067: Job not found in back_log or history
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.