COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: JFalletti on 19 Nov 2008 09:53:07 AM

Title: Query timeout
Post by: JFalletti on 19 Nov 2008 09:53:07 AM
What is the default query timeout and how can it be changed?

I have a rpeort that ha sso far been running for 37 minutes and would like it to time out in 20 minutes.

We are running Cognos 8 BI. We use the 60 minute idle application timeout and want to set a max time allowed for reports to run.  We do not want to make any changes at the database level we strictly want to change the Cognos tool.

Thank you
Title: Re: Query timeout
Post by: DustPanMan on 20 Nov 2008 01:57:42 PM
Within Report Studio you can set a timeout for each query as well as a maximum number of rows to retrieve.  In addition, you can set that properties default globally from Administration.
Title: Re: Query timeout
Post by: JFalletti on 25 Nov 2008 12:37:54 PM
Hello dustPanMan;

You mentioned that the timeout setting can be changed globally within the administration tool. I have searched each admin webpage for thet property setting and have not found it. could you please me exactly where it is.

Thank you