rserrorreadingnextdatarow sql server 2008 R2
Hi All,
I am deploying the reports in to sharepoint 2010.
All the reports are working fine but some of the reports are getting the below error.
Cannot read the next data row for the dataset. (rsErrorReadingNextDataRow)
I tried with report processing time out increase and parameter data type changes, but the issue is not resolved.
Regards,
Mandava.
May 26th, 2011 9:05am
Are you using any olap cubes as data sources for the reports.
Also, check the log files to see if there is any furhter information regarding the error.
I had a similar error once using SSRS 2005 and it was resolved after installing the latest service pack.
The error you getting could be because of a completely different reason though, but i'd suggest you to check the log files for any further info first
Free Windows Admin Tool Kit Click here and download it now
May 26th, 2011 9:18am
Does the report work in BIDS?
May 26th, 2011 9:27am
Yes, Reports are working fine in BIDS and i am not using any olap cubes.
Regards,
Mandava.
Free Windows Admin Tool Kit Click here and download it now
May 26th, 2011 9:44am
Hi Mandavas7,
The error message could be caused by different factors. Basically, I would suggest you try follows,
1. Install the latest SQL Server 2008 R2 Cumulative Update,
Cumulative Update package 6 for SQL Server 2008 R2
http://support.microsoft.com/kb/2489376
2. The problem is mostly about permission issue. So, make sure that the users have rights to access the database of the report datasource, or, use the "Credentials stored securely in the report server" to the report datasource for a try.
If you have any question, please ask.
Thanks,
Eileen
May 30th, 2011 1:48pm