Reports 11g : Duplicate Jobs Created Automatically for Long Running Reports (Doc ID 1122443.1)

Last updated on NOVEMBER 17, 2019

Applies to:

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

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

 

The problem does NOT reproduce when using WLS_REPORTS URL:

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.