Timeout

rbuser

Hi!

We are having trouble with timeout on one of our webreports. The error
'Timeout has expired' occurs after 30 seconds. I have used your demo
rbserver and webtier for webreports. All properties regarding timeout is set
to 600 seconds on both this applications and in webtier.ini. Timeout in
sql-sever is set to infinite, and IIS is set to 600. Any idea on how to fix
this problem?

Regards,
Terje

nardmoseley

My guess is that you are using ADO. The TADOConnection.CommandTimeout
property has a default value of 30 seconds. Try increasing that value.


--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

We have already tried that. The TADOConnection.CommandTimeout is set to 600.
We have also set the individual TADOQuery.CommandTimeout to 600 on all
querys.

Regards, Terje

nardmoseley

Check the following property values

Server.TimeOut
WebTier.ServerConnection.TimeOut
WebTier.SessionOptions.SessionTimeOut



--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

We have already done that with no luck. Is it possible that your
webreporting tool uses msxml3.dll? At one time we have encountered
a access violation in this dll, and according to some webpages this dll can
cause some timeout. Just a suggestion.

Best regards,
Terje

nardmoseley

RBServer does not use msxml.

As a test try running the windows client. Run the example installed to
RBServer\Demos\Clients\Client Explorer. Configure the time out propert for
the client report.

This is a real mystery.




--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

Hi Nard,

I have done that and set the timeout to different values. Even when i set it
to 5 secs. it timed out on 30 secs. I guess the computerghost is after me. I
have run out of options. I don't get a timeout if i run it from inside so it
can't be the sql-server. Any other suggestions?

Regards,
Terje