Long Running Reports Crash with “Failure of server APACHE bridge” Error after 5 Minutes

Dec 12, 2013

In Oracle Reports 11g (11.1.1.2.0+ and 11.1.2.x.0 (11gR2)), there is a known issue where all long-running reports that take more than 5 minutes to execute result in the error: “Failure of server APACHE bridge”.

By default in OHS, the Idempotent is turned on in OHS which results in a 5 minute timeout (even if the report job is being executed) by default. The parameters Idempotent and WLIOTimeoutSecs are not configured by default in OHS (within an Oracle Forms and Reports 11g installation). Due to this, Idempotent is turned ON with WLIOTimeoutSecs set to 300 (5 minutes).

To fix this problem, you can apply the following:

  1. Open httpd.conf located in %ORACLE_INSTANCE%\config\OHS\ohs1 ($ORACLE_INSTANCE/config/OHS/ohs1 in Unix). NOTE: Please make a backup first.
  2. Anywhere in the file, add the following two parameters:
    • Idempotent OFF
    • WLIOTimeoutSecs 1800 (NOTE: You can configure this for any value in seconds. For example setting this to 1800 represents 30 minutes.)
    • image
  3. Save and close the file.
  4. Restart OHS using OPMNCTL.

After applying the settings above, you should be able to run the long-running reports jobs that take more than 5 minutes.

Source: Oracle Support note 1122443.1