In Oracle Reports 11g (22.214.171.124.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:
- Open httpd.conf located in %ORACLE_INSTANCE%\config\OHS\ohs1 ($ORACLE_INSTANCE/config/OHS/ohs1 in Unix). NOTE: Please make a backup first.
- Anywhere in the file, add the following two parameters:
- Save and close the file.
- 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