Reports 11g : Duplicate Jobs Created Automatically for Long Running Reports
(Doc ID 1122443.1)
Last updated on NOVEMBER 17, 2019
Applies to:
Oracle Reports Developer - Version 11.1.1.2.0 and laterInformation in this document applies to any platform.
***Checked for relevance on 20-May-2014***
Symptoms
When a "long-running report" is executed, the request is successfully submitted to the "Reports Server" and the corresponding job is also visible in the "Current Jobs" option of the "Reports Server Queue".
Every 5 minutes, a "new duplicate job" is automatically created for the same report in the same 'Reports Server Queue', although no new request has been submitted to run that report (Reports job is re-submitted automatically).
The report output is successfully generated for all reports jobs.
The issue reproduces ONLY WHEN using Apache or the webcache URL:
or
The same can be encountered for srw.run_report when using rwservlet url with HTTP port. srw.run_report timesout after 30 minutes and for long running reports every 5 minutes a duplicate job is submitted to the Reports queue.
Also it is possible to see following error in the browser:
-------------------------------
WebLogic Bridge Message
--------------------------------Failure of server APACHE bridge:
No backend server available for connection: timed out after 10 seconds or idempotent set to OFF.
Build date/time: Oct 27 2009 13:34:24Change Number: 1013
------------------------------
The problem does NOT reproduce when using WLS_REPORTS URL:
Cause
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
Symptoms |
Cause |
Solution |
References |