Over 3000 Jobs In The Reports Queue Why?
(Doc ID 1202993.1)
Last updated on DECEMBER 04, 2019
Applies to:Oracle Clinical Remote Data Capture Option - Version 4.5.3 and later
Information in this document applies to any platform.
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 Note 110112.1 SRW.RUN_REPORT FAILS WHEN RUNNING A REPORT )
Why are so many jobs getting generated? Is this normal functionality or is there something wrong which should be corrected?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document