Reports 11g : Duplicate Jobs Created Automatically for Long Running Reports

(Doc ID 1122443.1)

Last updated on JUNE 07, 2016

Applies to:

Oracle Reports Developer - Version 11.1.1.2.0 and later
Information 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:

http://server:8888/reports/rwservlet?report=sleep.rdf&P_SLEEP_DURATION=1000000&destype=file&desformat=PDF&desname=test1000000.pdf

or

http://server:8090/reports/rwservlet?report=sleep.rdf&P_SLEEP_DURATION=1000000&destype=file&desformat=PDF&desname=test1000000.pdf

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:24

Change Number: 1013
------------------------------

 


The problem does NOT reproduce when using WLS_REPORTS URL:

http://server:9002/reports/rwservlet?report=sleep.rdf&P_SLEEP_DURATION=1000000&destype=file&desformat=PDF&desname=test1000000.pdf

 

Cause

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