Scheduled Jobs do not appear in Backlog

Document ID : KB000100403
Last Modified Date : 06/06/2018
Show Technical Document Details
Issue:
Scheduled Jobs do not appear in Backlog but an Adhoc Request functions correctly.

Reviewing the RMI logs show the following error:

ErrorMsg: AwE-5001 Database Query Error
Details: aw5.submit_chains

jdbc:oracle:thin:@//hostname:1521/service_name:db_user
java.sql.SQLException: ORA-20999: Scheduling has encountered an exception - Scheduling will not continue until issue is resolved - [ORA-20001: Submit_chains job_seq=xxxx -ORA-20088: Agent <AGENT_NAME> is not valid for this module.- Submit <JOB/PROCESS_FLOW_NAME> sched=<SCHEDULE_NAME> seq=xxxx]

There are a number of possible scheduling exceptions. This particular error is "ORA-20088: Agent <AGENT_NAME> is not valid for this module", which indicates that there is an issue with the Agent that is assigned to the Job or Process Flow.

 
Resolution:
Edit the Job or Process Flow seen in error and make sure the Agent value is a valid in the Job/Process Flow definition and/or Schedule(s).