timing problem issue

P

Paul

Hi, I have some kind of timing problem, not sure how to address it yet. I
have a stored procedure that can take from 10 seconds to 2 minutes to return
data to a dataset depending on its input parameters. I have the
da.selectcommand.CommandTimeout = 0 but still when I run it for longer
processing time I get the error object not set to an instance of an object
when I try
document.close method where document is ReportDocument. The data is being
displayed in a Crystal report.
 
P

Paul

Thanks for the response. I added <httpRuntime executionTimeout="1000"/>
to the web config just under the complitation close tag. It builds without
errors but I am still getting the runtime error like the timeout is not
working, still using default?
The query takes 1:45 to complete so it is greater than the default timeout
for .net 2.0.
--
Paul G
Software engineer.


Eliyahu Goldin said:
What you are observing is the default timeout for http requests. For 1.1 it
is 90sec and from 2.0 it is 110sec. You can control it with

<httpRuntime executionTimeout="xxx"

in web.config file.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
Click to expand...
 
B

brianedow

What you are observing is the default timeout for http requests. For 1.1 it
is 90sec and from 2.0 it is 110sec. You can control it with

<httpRuntimeexecutionTimeout="xxx"

in web.config file.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]http://msmvps.com/blogs/egoldinhttp://usableasp.net


Hi, I have some kind of timing problem, not sure how to address it yet. I
have a stored procedure that can take from 10 seconds to 2 minutes to
return
data to a dataset depending on its input parameters. I have the
da.selectcommand.CommandTimeout = 0 but still when I run it for longer
processing time I get the error object not set to an instance of an object
when I try
document.close method where document is ReportDocument. The data is being
displayed in a Crystal report.
Click to expand...
Click to expand...

What is the error that is being thrown from IIS? Are you trapping the
error?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crystal Report Error : the maximum report processing jobs limitconfigured by your system administrat 1
Program create xsd for Crystal Report and provide all data on repo 2
Crystal Reports Export Problem 1
How to put timing code in around ViewState parsing 1
Sessions timing out quickly despite very high timeout set in web.config 7
Trouble with slide timing... 2
Copy Timing Issue? 4
properly close crystal report object? 1

Top