Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Content Management (Extended ECM)
API, SDK, REST and Web Services
LiveReport CGI Timeout
Cliff_Smithson_(lockmaradmin_-_(deleted))
We have one LiveReport that periodically exceeds the CGI timeout parameter (which seems to be 5 minutes). Where is this parameter set?The big problem is that when the timeout occurs, Oracle continues happily along, holding an open session, and eating up resources...
Find more posts tagged with
Comments
Steven_Osborn_(sosborn@opentext.com_(Delete)_43869
Message from Steven Osborn via eLinkHi,I'm not certain, but I think you can alter the CGI timeout period inyour webserver.Not sure if you have the WebReports module (its an optional one) but ifyou do, you could avoid the CGI timeout issue altogether by asking thereport to run in the background and save the results to a document inLivelink. This releases the user's browser immediately. You could evenhave the report run automatically once an hour / day or something andsave the results as an HTML document that many users could accesswithout causing a hit on your DB / resources every time someone visitedit.Regards,Steve.-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 16 March 2006 19:40To: eLink RecipientSubject: LiveReport CGI TimeoutLiveReport CGI TimeoutPosted by Smithson, Cliff on 03/16/2006 02:36 PMWe have one LiveReport that periodically exceeds the CGI timeoutparameter (which seems to be 5 minutes). Where is this parameter set?The big problem is that when the timeout occurs, Oracle continueshappily along, holding an open session, and eating up resources...[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussion
https://knowledge.opentext.com/knowledge/livelink.exe/open/2249677Livelink
Server:
https://knowledge.opentext.com/knowledge/livelink.exeTo
Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.
Lindsay_Davies
Message from Lindsay Davies via eLinkThe CGI timeout value is set on the web server.In IIS (5.0) manager console for example, On the Web Site level (above "default" web site) Home Directory tab Configuration button Process Options tab = last tab on right setting is CGI script timeout - defaultis 300 seconds (5 Mins).It is bound to be somewhere different (but similar) in IIS 6.For Apache, iplanet, etc, check their documentation.A word of warning! You should not be running SQL that takes as long 300 seconds to run andformat its information back to a web page!!Creation of Livereports is normally restricted in Livelink for tworeasons... 1 - security - you can query things regardless of permissions2 - you might do something that is too large a unit of work for thesystem and so cause a loss of service to all users.For example, select * from dtree - you may have millions of rows indtree.Imagine how big that page would be. Also, even if you have set a results limit of 100 in your Livereport, itonly applies that limit in the page formatting after the full resultsset is obtained from the DB.Your Livereport is running in a thread.If you click stop in the browser, the Livereport still runs tocompletion, you merely prevented your browser waiting for the results.You or another user may submit the same report again during this timeand therefore take out 2 threads.Are you sure you want to up this CGI timeout limit?Have you tried running the same query in an external took first (QueryAnalyzer or SQL*Plus) to see the execution plan and determine how longit takes to execute?Good luck.LindsayOpen Text UK Support-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 16 March 2006 19:40To: eLink RecipientSubject: LiveReport CGI TimeoutLiveReport CGI TimeoutPosted by Smithson, Cliff on 03/16/2006 02:36 PMWe have one LiveReport that periodically exceeds the CGI timeoutparameter (which seems to be 5 minutes). Where is this parameter set?The big problem is that when the timeout occurs, Oracle continueshappily along, holding an open session, and eating up resources...[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussion
https://knowledge.opentext.com/knowledge/livelink.exe/open/2249677Livelink
Server:
https://knowledge.opentext.com/knowledge/livelink.exeTo
Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.
