|
|
You're in the
sql server reporting services
group:rsErrorReadingNextDataRow
sql server reporting services:
Hi,
I'm getting the below error with my reports. Any help is appretiated much. Thanks... An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot read the next data row for the data set DataSet1. (rsErrorReadingNextDataRow) Get Online Help A severe error occurred on the current command. The results, if any, should be discarded.
I am having this issue too. Did you resolve this?
[quoted text, click to view] "eralper" wrote:
> Hi, > > I'm getting the below error with my reports. > Any help is appretiated much. > Thanks... > > An error has occurred during report processing. (rsProcessingAborted) Get > Online Help > Cannot read the next data row for the data set DataSet1. > (rsErrorReadingNextDataRow) Get Online Help > A severe error occurred on the current command. The results, if any, should > be discarded. > >
Hi,
I was using Linked Servers for the data source of the reports. And dynamically changing the database server name and database name by passing these values as parameters. On some of the servers I was using "." to map the database server to itself. I changed the passed value "." to database server name for the database server name parameter. This change worked. http://www.kodyaz.com/ShowPost.aspx?PostID=52#52 Eralper http://www.kodyaz.com [quoted text, click to view] "Kmistic" wrote:
> I am having this issue too. Did you resolve this? > > "eralper" wrote: > > > Hi, > > > > I'm getting the below error with my reports. > > Any help is appretiated much. > > Thanks... > > > > An error has occurred during report processing. (rsProcessingAborted) Get > > Online Help > > Cannot read the next data row for the data set DataSet1. > > (rsErrorReadingNextDataRow) Get Online Help > > A severe error occurred on the current command. The results, if any, should > > be discarded. > > > >
Thanks for replying. i am not using linked servers i am actually getting
this error from reporting services. [quoted text, click to view] "eralper" wrote:
> Hi, > > I was using Linked Servers for the data source of the reports. And > dynamically changing the database server name and database name by passing > these values as parameters. > > On some of the servers I was using "." to map the database server to itself. > I changed the passed value "." to database server name for the database > server name parameter. > > This change worked. > > http://www.kodyaz.com/ShowPost.aspx?PostID=52#52 > > Eralper > http://www.kodyaz.com > > > > "Kmistic" wrote: > > > I am having this issue too. Did you resolve this? > > > > "eralper" wrote: > > > > > Hi, > > > > > > I'm getting the below error with my reports. > > > Any help is appretiated much. > > > Thanks... > > > > > > An error has occurred during report processing. (rsProcessingAborted) Get > > > Online Help > > > Cannot read the next data row for the data set DataSet1. > > > (rsErrorReadingNextDataRow) Get Online Help > > > A severe error occurred on the current command. The results, if any, should > > > be discarded. > > > > > >
I would like to mention that this error only happens when non-adminstrators
try to view the report. I have the dataset being generated by a stored procedure that executes a dtspackage using xp_cmdshell. When i take the xp_cmdshell command out of the stored procedure it works fine. I pass the xp_cmdshell the dtsrun command using sa and its password. I don't understand what else i might need to do to enable the none admins to work. [quoted text, click to view] "Kmistic" wrote:
> Thanks for replying. i am not using linked servers i am actually getting > this error from reporting services. > > "eralper" wrote: > > > Hi, > > > > I was using Linked Servers for the data source of the reports. And > > dynamically changing the database server name and database name by passing > > these values as parameters. > > > > On some of the servers I was using "." to map the database server to itself. > > I changed the passed value "." to database server name for the database > > server name parameter. > > > > This change worked. > > > > http://www.kodyaz.com/ShowPost.aspx?PostID=52#52 > > > > Eralper > > http://www.kodyaz.com > > > > > > > > "Kmistic" wrote: > > > > > I am having this issue too. Did you resolve this? > > > > > > "eralper" wrote: > > > > > > > Hi, > > > > > > > > I'm getting the below error with my reports. > > > > Any help is appretiated much. > > > > Thanks... > > > > > > > > An error has occurred during report processing. (rsProcessingAborted) Get > > > > Online Help > > > > Cannot read the next data row for the data set DataSet1. > > > > (rsErrorReadingNextDataRow) Get Online Help > > > > A severe error occurred on the current command. The results, if any, should > > > > be discarded. > > > > > > > >
Hi,
I was successfully running the report from VS.Net but it was failing when I deploy it onto the report server. Do you have a similar behavior? [quoted text, click to view] "Kmistic" wrote:
> Thanks for replying. i am not using linked servers i am actually getting > this error from reporting services. > > "eralper" wrote: > > > Hi, > > > > I was using Linked Servers for the data source of the reports. And > > dynamically changing the database server name and database name by passing > > these values as parameters. > > > > On some of the servers I was using "." to map the database server to itself. > > I changed the passed value "." to database server name for the database > > server name parameter. > > > > This change worked. > > > > http://www.kodyaz.com/ShowPost.aspx?PostID=52#52 > > > > Eralper > > http://www.kodyaz.com > > > > > > > > "Kmistic" wrote: > > > > > I am having this issue too. Did you resolve this? > > > > > > "eralper" wrote: > > > > > > > Hi, > > > > > > > > I'm getting the below error with my reports. > > > > Any help is appretiated much. > > > > Thanks... > > > > > > > > An error has occurred during report processing. (rsProcessingAborted) Get > > > > Online Help > > > > Cannot read the next data row for the data set DataSet1. > > > > (rsErrorReadingNextDataRow) Get Online Help > > > > A severe error occurred on the current command. The results, if any, should > > > > be discarded. > > > > > > > >
hi
i am getting error msg in sqlservice report cannot read the next data row for the data set dataset1 in sql reporting service i need a solloution for this problem From http://www.developmentnow.com/g/115_2005_1_0_0_455079/rsErrorReadingNextDataRow.htm Posted via DevelopmentNow.com Groups
I am also getting this error intermittenly on some reports. It is text query not a stored procedure and sometimes it works for the same user. The database and table being queried have high activity. Could this be a colision or exclusive lock? Since it's intermittent it is hard to troubleshoot.
From http://www.developmentnow.com/g/115_2005_1_0_0_455079/rsErrorReadingNextDataRow.ht Posted via DevelopmentNow.com Groups
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |