Skip to Content
0
Former Member
Nov 03, 2009 at 07:29 PM

WebI Query timeout issue

182 Views

We have a long running (about 10 mins) query as part of a WebI report. The WebI report will be scheduled and the output as Excel is expected. However, as of now, we can't get this query to finish along with the other ones on the report.

I get a Database Error: [Miscorsoft OLE DB] Timeout Expired message every time I try to run it or schedule it about 5-6 minutes into execution.

Here is what I have done so far:

a) InfoView session (web.xml) timeout is 60

b) WebI Report Server session timeout (CMC) is 60

c) WebI Job Server timeout (CCM) is 1200000 (20 mins).

d) Univ connection timeout (Designer) is 20 mins.

In this scenario, at what point would the query from WebI be failing (timeout)? I can run the SQL against the DB directly and it runs for 10 mins or so.

Any ideas? Thanks much!