Timeout in OHS server

UnitedNations · Feb 7, 2017 6:18AM

Team,

OBIEE 11g server was front ending by OHS 11g server (Proxy), when tried to export excel report from analytics client which takes more than 15 mins, getting error out.

So found the parameter in httpd.conf file, "Time Out" based on the error message in saw file:

[2017-02-07T08:24:43.000+01:00] [OBIPS] [ERROR:31] [] [saw.subsystem.portal.office] [ecid: 005HyhvppDSD8h45VVS4yc0006ks0057D8,0:2:1] [tid: 1611040512] Client no longer there.[[

File:sawserverstream.cpp

I have changed default value of Time out parameter from 300 secs to 2000 secs, now able export the report without any issues.

Just wanted to know the significance or implication of "Time out" Parameter in httpd.conf file, already refereed "OHS performance" guide but not fruitful information.

Same report, if invoked directly without OHS able to export successfully.

UnitedNations · Mar 15, 2017 1:13AM

Team,

Any inputs or suggestions for this query?

Thanks in advance..

FTisiot · Mar 15, 2017 8:49AM

Hi,

If I read it wright you are basically asking what TimeOut mans: the timeout is the time after which the session is closed by OHS.

If you invoke the report without OHS, then only the timeouts defined in OBIPS are taken into consideration

For a timeout definition have a look at https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Linux/3/html/Reference_Guide/s1-apache-config.html

Gianni Ceresa · Mar 15, 2017 8:56AM

@FTisiot pointed you in the right direction, it's the apache timeout setting.

OHS act as a proxy: you (the user) ask OHS, OHS asks OBIEE. OBIEE reply to OHS, OHS take it and use it to reply to you (the user) (https://en.wikipedia.org/wiki/Proxy_server )

So you have 2 timeouts to manage: the OBIEE one which was fine as you said a direct export was ok, the OHS one is the one you changed.

Oracle Analytics Cloud and Server

Categories

Timeout in OHS server

Answers