rsErrorReadingNextDataRow

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?
"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
"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.
"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.
"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?
"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 proble
From http://www.developmentnow.com/g/115_2005_1_0_0_455079/rsErrorReadingNextDataRow.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com|||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.h
Posted via DevelopmentNow.com Group
http://www.developmentnow.comsql