Job Remains at Submitted or Executing

If a job does not progress beyond a status of Submitted or Executing, try the steps in this section.

1. Log in as Apps.
2. Run the following SQL script:

   SELECT  q.JOB_PROCESSING_FLAG_RC,  q.LOG_MESSAGE_ID,TO_CHAR(q.LOG_STAMP),q.message  FROM cdr_job_queues_log q ORDER BY q.LOG_STAMP DESC
   

3. Check the resulting message. If the message is similar to the following, proceed to Step 4:
   • dequeued from control Q: _JOBCONTROL_STOP
   • Caught Exception (-20200) (ORA-20200: *** ERROR: cdr_exe_owb_execution.startedJob: SQL error: ORA-06508: PL/SQL: could not find program unit being called ORA-25228: timeout or end-of-fetch during message
4. Stop the OWB service.
   To do this, connect as cdr_rtrepos and run stop_service.sql. (For more information, see Stopping the OWB Service.)
5. Stop the job queue.

   To do this, connect as apps and run stopq.sql. (For more information, see Stopping the Job Queue.)

6. Start the OWB service.

   To do this, connect as cdr_rtrepos and run start_service.sql. (For more information, see Starting the OWB Service.)

   You should get a message that the service is available.

7. Start the job queue.

   To do this, connect as apps and run startq.sql. (For more information, see Starting the Job Queue.)

8. Rerun the query given in Step 2.

   You should get a message:

   dequeued from control Q: _JOBCONTROL_ENABLE

   It may take some time for the message to appear.

9. Rerun the job.