Hi All,
I despreatly need help on this!!
I have a number of reports which have multiple queries in but when I refresh some of them the query stops running after 220 seconds and states that it is diconnecting.
I have looked in the universe at the connection and it states that it’s connection is to stay open for the whole session.
Can anybody help me with this?
Many thanks!!
gordon_black 
(BOB member since 2008-05-30)
Welcome to B:bob:B!
Are these full-client (aka DeskI) reports? Which BO version do you use? And what database?
Marek Chladny 
(BOB member since 2003-11-27)
Sorry the reports are full client reports in version 5.1.8. The back end database is SQL Server 2000.
Many thanks
Gordon
gordon_black (BOB member since 2008-05-30)
Do you get partial results warning? If yes then it can be caused by a universe parameter “limit execution time to”. It’s in universe parameters, tab Controls.
If you do not get the partial results warning then it’s possible that the connection to the database is disconnected on a database side. Can you check with your DBA whether there is any automatic disconnection after some period of time?
Marek Chladny (BOB member since 2003-11-27)
Just u will copy in ur report query then check ur back end. And then compare ur report timing and backend timeing.
jgd.ramesh 
(BOB member since 2007-08-05)