Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSRS timeout


SSRS timeout

Author
Message
agrawal.prakriti
agrawal.prakriti
SSC-Enthusiastic
SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)

Group: General Forum Members
Points: 132 Visits: 101
Comments posted to this topic are about the item SSRS timeout
bitbucket-25253
bitbucket-25253
SSCertifiable
SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)

Group: General Forum Members
Points: 5695 Visits: 25280
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
Iggy-SQL
Iggy-SQL
SSCrazy
SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)

Group: General Forum Members
Points: 2963 Visits: 440
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
bitbucket-25253
bitbucket-25253
SSCertifiable
SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)

Group: General Forum Members
Points: 5695 Visits: 25280
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
SQLRNNR
SQLRNNR
SSC-Insane
SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)

Group: General Forum Members
Points: 21105 Visits: 18259
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, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

Stewart "Arturius" Campbell
Stewart "Arturius" Campbell
SSCertifiable
SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)

Group: General Forum Members
Points: 5804 Visits: 7137
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”
Kelsey Thornton
Kelsey Thornton
Mr or Mrs. 500
Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)

Group: General Forum Members
Points: 559 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
Andeavour
Andeavour
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1002 Visits: 932
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 Smile



ohack
ohack
SSC-Addicted
SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)

Group: General Forum Members
Points: 411 Visits: 629
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".
anna.ellis@getronics.com
anna.ellis@getronics.com
SSC Veteran
SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)

Group: General Forum Members
Points: 219 Visits: 584
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?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search