Page 1 of 1

Server timeout

Posted: Tue Oct 16, 2012 7:15 pm
by terricide
Is there a limit to the amount of data you can have in a data source when previewing in the web designer?

I had a query that returned 23,000 rows and I keep getting server timeout. If I choose different dates with less data then I don't get the timeout.

I've changed the command-timeout in the datasource to 600 and changed the ServerTimeout of the webdesigner control to 1 hour.

Any ideas?

Re: Server timeout

Posted: Wed Oct 17, 2012 9:40 am
by Alex K.
Hello,

Try to set the CommandTimeout property for datasource.

Thank you.

Re: Server timeout

Posted: Wed Oct 17, 2012 12:23 pm
by terricide
Yeah I did that. It didn't make a difference.

Re: Server timeout

Posted: Wed Oct 17, 2012 1:15 pm
by Alex K.
Hello,

Try to set the following property:
StiWebViewerFxOptions.Connection.ClientRequestTimeout = 60; (in seconds)

Thank you.

Re: Server timeout

Posted: Wed Oct 31, 2012 3:15 pm
by terricide
That seemed to help. Thanks :)

Re: Server timeout

Posted: Thu Nov 01, 2012 4:42 am
by Andrew
Hello,

Great!

Let us know if you need any help in this regard.
Thank you.