Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Timeout in OHS server

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.
Answers
-
Team,
Any inputs or suggestions for this query?
Thanks in advance..
0 -
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
0 -
@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.
0