Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BI Publisher Reports show gateway timeout error after 2 mins

Received Response
126
Views
2
Comments
Debabrata Dash01
Debabrata Dash01 Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

Summary

BI Publisher Reports show gateway timeout error after 2 mins

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

Answers

  • timdexter
    timdexter Rank 6 - Analytics Lead

    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

  • Debabrata Dash01
    Debabrata Dash01 Rank 2 - Community Beginner

    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.

    <Location /xmlpserver>

           WLSRequest On

           SetHandler weblogic-handler

           WLIOTimeoutSecs 1500

           Idempotent OFF

           WebLogicCluster dsprexrpt1.employeedirect.com:9704

    </Location>

    <Location /analytics>

           WLSRequest On

           SetHandler weblogic-handler

           WLIOTimeoutSecs 1500

           Idempotent OFF

           WebLogicCluster dsprexrpt1.employeedirect.com:9704

    </Location>

    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?