BI Publisher Reports show gateway timeout error after 2 mins

Question

Summary

Content

Hi,

In our Production environment, we have BI Publisher integrated with OBIEE version 11.1.1.7.150120

The BI Publisher reports are timing out after 2mins. Below is the exact error message we could see in the screen.

All of the reports are using PL/SQL query in data-model.

Gateway Timeout

The proxy server did not receive a timely response from the upstream server.

This issue happens only when we login via SSO.

We are using Oracle IAM for authentication and request pass through APACHE webserver before hitting the OBIEE application server.

We have modified httpd.conf in APACHE to increase the session time-out value. But this has not resolved the issue.

This issue don't occur when we connect via. stand-alone URL for analytics, with weblogic ID. We could run the BIP reports for more than 45mins, if connected via stand-alone URL.

We are unable to locate the source of the error. If anyone has any suggestions, please help.

Thanks,

Deb

Debabrata Dash01 · Answer

Hi Tim, Thank you for your response. Please find the httpd.conf file details from the webserver. The session time out value has been set to 1500s in web servers. WLSRequest On SetHandler weblogic-handler WLIOTimeoutSecs 1500 Idempotent OFF WebLogicCluster dsprexrpt1.employeedirect.com:9704 WLSRequest On SetHandler weblogic-handler WLIOTimeoutSecs 1500 Idempotent OFF WebLogicCluster dsprexrpt1.employeedirect.com:9704 Also, I have one more observation to share. From the web-server, we have a web-service call, which invokes BI Publisher reports in reporting servers. We face the same time-out issue when reports are invoked via the web-service call. Will there be any cause related to firewall settings in the reporting servers?

timdexter · Answer

Hi Deb

If you can successfully run the report directly without the web server in the picture, then there is some issue in the web server configuration. That much is obvious I guess :0)

I'd need to take a looksee at the httpd.conf and depending on your set up the WLS conf file that contains the redirects to the internal BIP URLs, to be able to help further.

Regards

Tim