Reporting Service Timeout Issue.

Question

Post reply

Reporting Service Timeout Issue.

Sandeep Aparajit

SSC Enthusiast

Points: 188
More actions
September 26, 2006 at 1:17 am

#192385

I am generating reports using SSRS. The report uses a Stored Procedure. The stored procedure executes for about 2-3 hours (Due to huge data and processing) . But when I use web services to generate the report, the Web service timout after few minutes. Can any body guide me to solve this issue efficiently ?
Thanks in Advance
Sandeep

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Prasad Bhogadi SSCrazy Eights Points: 9235 More actions · Answer 1

MyWebService ws = new MyWebService()

ws.TimeOut = time in milli seconds (This value should be set to the approximate SP execution time)

then invoke ws.MyReportFunction(params....)

However you may want to work on optimizing your stored procedure.

Prasad Bhogadi
www.inforaise.com

Martin N Ten Centuries Points: 1216 More actions · Answer 2

I'd use the sproc to build a permanent table in your database over night. ie pre process the data, then use the report to query the results.

Kindest Regards,

Martin

Sandeep Aparajit SSC Enthusiast Points: 188 More actions · Answer 3

Thanks a lot ! The Web service Timeout concept worked !

If we give the WebService Timeout = -1 , then it is assumed to be infinite timeout.

-Sandeep

jmichaud SSC-Addicted Points: 462 More actions · Answer 4

I am new to this and I also have what I suspect to be a timeout issue - I have a report kicking off a SP and sometimes it takes 20 minutes to run sometimes over 30; when it is over 30 we end up with an error that says:

An error has occurred during report processing.

Cannot read the next data row for the data set [dataset name].

Operation cancelled by user.

How do you increase the timeout as I do not see anywhere to do this? Any help would be greatly appreciated. Thanks ahead.

jbarker4682 SSC Journeyman Points: 90 More actions · Answer 5

jmichaud (2/17/2009)
I am new to this and I also have what I suspect to be a timeout issue - I have a report kicking off a SP and sometimes it takes 20 minutes to run sometimes over 30; when it is over 30 we end up with an error that says:
An error has occurred during report processing.
Cannot read the next data row for the data set [dataset name].
Operation cancelled by user.
How do you increase the timeout as I do not see anywhere to do this? Any help would be greatly appreciated. Thanks ahead.

Just curious, but are you working with any large binary or text values? I've run into this issue before when using ADO .Net to retrieve large values via a DataReader. If I undestand correctly, it has something to do with the buffer used between SQL Server and the client running out of space. The work-around in ADO .Net from a code perspetive is to use the DataReader's GetXXX method to retrieve each column value seperately...

Does that help?