Gateway Timeout between BI Publisher and Report Database

User_QPYCU

Summary

Gateway Timeout between BI Publisher and Report Database

Content

Hello All,

We have an SQL query (ran from PL/SQL) that calls an OBIEE web services (XMLP/PublicReportService) to generate a report. This is a huge report and is expected to take more than 45 minutes. When the scenario is executed, PL/SQL shows a gateway timeout error at 30 minutes but the report gets generated in the background at OBIEE level. Looks like PL/SQL or database is timing out waiting for the response from OBIEE server and throwing a gateway timeout exactly after 30 minutes.

There are no timeouts set to 30 minutes at OBIEE and Weblogic configurations. However we have increased the below mentioned timeouts to a higher values to troubleshoot the issue. 

Session-timeout on  xmlpserver deployment – set to 240 minutes

<NewCursorWaitSeconds>**</NewCursorWaitSeconds> -- set to 12600 seconds

<ConnectionExpireMinutes>210</ConnectionExpireMinutes> -- set to 210 minutes

<ClientSessionExpireMinutes> 210</ClientSessionExpireMinutes> -- set to 210 minutes

<LogOnExpireMinutes>210</LogOnExpireMinutes>  -- set to 210 minutes

-Dsun.net.client.defaultReadTimeout=3600000 -Dsun.net.client.defaultConnectTimeout=3600000

Even after increasing the timeout values at weblogic and OBIEE level, PL/SQL still throws a gateway timeout at 30 minutes.

Which timeout needs to be configured to overcome this concern?

Product details:

Oracle Business Intelligence 11.1.1.9.0 sits on Weblogic 10.3.6.0 with jdk1.7.0_80.

Thanks,

Avinash