SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSRS 2005 - Cannot read the next data row for the data set.


SSRS 2005 - Cannot read the next data row for the data set.

Author
Message
windows_mss
windows_mss
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1972 Visits: 186
Hi,

I'm working on SSRS 2005 and new to reports, I have developed a report and deployed in one of our environment. For the few days we are able to see the report without any issues but suddenly I'm getting the following exception in the reports,

An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot read the next data row for the data set "MYDATASETNAME". (rsErrorReadingNextDataRow) Get Online Help
For more information about this error navigate to the report server on the local server machine, or enable remote errors[size="1"][/size]


Report doesn't have any parameters in it & SP which used in the report also doesn't have any parameters.

Please guide me on this issues.

___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming
:-)
doug.brown
doug.brown
SSCertifiable
SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)

Group: General Forum Members
Points: 5049 Visits: 23363
The ReportServer logs should be able to give you a more verbose error description. When I get this error the most common reason is the query is hitting a deadlock.
windows_mss
windows_mss
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1972 Visits: 186
Thanks Doug.Brown, But I'm using NOLOCK in my select query.

___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming
:-)
Joie Andrew
Joie Andrew
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: General Forum Members
Points: 25168 Visits: 2133
That is why the Report Server logs are so important. One can guess that it is a deadlock issue but that is only a guess. The logs will have have more detailed information.

Joie Andrew
"Since 1982"
windows_mss
windows_mss
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1972 Visits: 186
Thanks a lot Doug.Brown & Joie Andrew, I Fixed this issue by going through log file.

Root Cause : I have missed the "GO" between my SP Script & GRANT EXECUTE Script. Crazy

___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming
:-)
Suresh B.
Suresh B.
SSC-Insane
SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)

Group: General Forum Members
Points: 20766 Visits: 5337
Thanks windows_mss
Your reply helped me.
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