Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Issue Time Duration Report

web-app

When I attempt to run the issue Time Duration report for a project with thousands of issues, I get a report timed out error.

Is there a sql definition for this report available so that I can examine the plan, tweak indices, or run it via SQL Mgmt Studio to get an idea how long it'll take my data to run (so I can adjust my server's timeout setting, etc)?

Thanks

JBroome
· 1
JBroome
Replies (4)
helpful
0
not helpful

I suspect that this is an HTTP timeout and not sql, can you post the exact error?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Server Error in '/' Application.

        <h2> <i>Request timed out.</i> </h2></span>

        <font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">

        <b> Description: </b>An

unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

        <b> Exception Details: </b>System.Web.HttpException: Request timed out.<br><br>

        <b>Source Error:</b> <br><br>

        <table bgcolor="#ffffcc" width="100%">
           <tbody><tr>
              <td>
                  <code>

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

              </td>
           </tr>
        </tbody></table>

        <br>

        <b>Stack Trace:</b> <br><br>

        <table bgcolor="#ffffcc" width="100%">
           <tbody><tr>
              <td>
                  <code></code><pre>[HttpException (0x80004005): Request timed out.]<br></pre></td></tr></tbody></table></font>

JBroome
· 1
JBroome
helpful
0
not helpful

This is an HTTP timeout, set it in the web.config:

<httpRuntime executionTimeout="90" maxRequestLength="44096" useFullyQualifiedRedirectUrl="false"/>


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

I had to quadruple my timeout value to 6 minutes, but finally got results.  Thanks.


JBroome
· 1
JBroome