Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

SSRS timeout Expand / Collapse
Author
Message
Posted Saturday, February 13, 2010 3:15 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 27, 2010 1:31 PM
Points: 132, Visits: 101
Comments posted to this topic are about the item SSRS timeout
Post #865176
Posted Sunday, February 14, 2010 11:57 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 7:17 PM
Points: 5,332, Visits: 25,261
From the question
under timeout (in dataset):


Sorry to say this but the page referenced in the explanation does not match the Microsoft page:

SQL Server 2008 Books Online (November 2009)
How to: Create a Dataset (Reporting Services)

at:
http://technet.microsoft.com/en-us/library/ms160345.aspx

6. In Timeout, type the number of seconds that the report server waits for a response from the database. The default value is 0 seconds. When the time out value is 0 seconds, the query does not time out.


The above page does not correspond to the authors statement that 30 seconds is the default value......hmmmm

Now:
http://technet.microsoft.com/en-us/library/ms160345(SQL.90).aspx

SQL Server 2005 Books Online (November 2008)
How to: Create a Dataset (Report Designer)
Updated: 14 April 2006

It Says:
6. In Timeout, type the number of seconds that the report server waits for a response from the database.
The default value is 30 seconds. Timeout must contain a value greater than zero or be left empty.
If it is empty, the query does not time out
.


Here we go again another big arguement/discussion on the quality of the QOD .... OH WELL


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #865299
Posted Sunday, February 14, 2010 2:24 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 19, 2014 2:26 AM
Points: 2,953, Visits: 439
Sorry, your explanation and answer is only valid for SQL 2000. SQL 2008 requires the time out value to be 0 for the query not to time out. Whilst I appreciate you taking time to create the QotD, next time please specify the SQL version to avoid confusion. Furthermore, I never knew SQL 2000 reporting is also referred to as SSRS, as far as I know (but I know I have limited knowledge), the term SSRS started in SQL 2005 onwards.

Reference for SQL 2008: http://msdn.microsoft.com/en-us/library/ms160345.aspx



Urbis, an urban transformation company
Post #865312
Posted Sunday, February 14, 2010 3:03 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 7:17 PM
Points: 5,332, Visits: 25,261
Iggy-SQL

Check out this link:

SQL Server 2005 Books Online (November 2008)
Reporting Services Enhancements
http://technet.microsoft.com/en-us/library/ms170438(SQL.90).aspx

This may clear up some of the confusion then again it may not


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #865317
Posted Sunday, February 14, 2010 3:41 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:05 AM
Points: 17,710, Visits: 15,580
d'oh

I missed this question due to going with documentation stating that 0 is the value that should be set.

Most people have missed it so far - and that is kind of interesting. The reason for that happening seems to be differences found in documentation.


hmmm....




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #865320
Posted Sunday, February 14, 2010 11:33 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 5:13 AM
Points: 3,983, Visits: 5,230
I must regrettably add to the confusion...
this is, once again, a version issue.
in 2000, the tool was only called Reporting Service
SSRS 2005 requires the timeout to be left blank,
SSRS 2008 requires the timeout to be 0,

Please include which version is being referred to in the QotD.


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #865373
Posted Monday, February 15, 2010 1:25 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, March 27, 2014 8:16 AM
Points: 534, Visits: 282
Until I read the posts here I was going to write "Good Question".

I had to search around a bit until I found the answer.
Looking at the MS web page http://msdn.microsoft.com/en-us/library/ms160345(SQL.90).aspx (to which I navigated after doing a search on MSDN), I found the "correct" answer.

I think I'll still say "Good Question" anyway


Kelsey Thornton
MBCS CITP
Post #865404
Posted Monday, February 15, 2010 1:44 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 4:21 AM
Points: 999, Visits: 870
Should have read the question better. The defining clue was in "(in dataset)".
Once you start looking into controling the timeouts in the Dataset, then you find the answer quoted in the documentation.

Another lesson in reading the question more carefully :)



Post #865407
Posted Monday, February 15, 2010 3:30 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 5:15 AM
Points: 348, Visits: 468
A somewhat ambiguous question again - as in even knowing the answer still left 2 answers as valid. If you leave the timeout box empty and click ok (SSRS 2008) it will have a zero in it when you reopen it - or you can just put a zero in there. Needless to say I was unlucky and got it "wrong".
Post #865433
Posted Monday, February 15, 2010 3:36 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 5:53 AM
Points: 217, Visits: 532
I have to agree with those who have asked for the version of SQL Server to be specifed in future. SQL 2008 clearly states a value of 0 as the "never time out" value; SQL 2000 and 2005 state a value of blank or greater than 0.

It's surely not a surprise that the majority of those who answered this question assuming that the unstated version meant the question referred to the latest version of SQL Server?
Post #865436
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse