Over 3000 Jobs In The Reports Queue Why? (Doc ID 1202993.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Clinical Remote Data Capture Option - Version: 4.5.3 and later   [Release: 4.5 and later ]
Information in this document applies to any platform.

Goal

Examining the reports queue it appears that a user somehow submitted over 3000 jobs to the reports queue and you can't kill them. To clear out these jobs you have logged into the report queue manager with the admin login but it appears to hang when you try to kill them.

To fix this you had to reboot the reports server and then restart the reports service. This seems to have been successful in helping you to delete the jobs in batches.
(See also <> )

Why are so many jobs getting generated? Is this normal functionality or is there something wrong which should be corrected?


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms