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

rsErrorOpeningConnection

Hi,
I really really need some help with the problem below. I

am having problems trying to run reports from a VB.Net application. The problem

is as follows:

SQL Server 2005, SQL Server Reporting Services and the VB

.NET application called ‘risk-op’ are on a server.

A user tries to access the application from a remote

computer. The application is displayed and the user is able to do everything.

However when the user tries to click ‘Go’ for one of the reports the following

error is displayed:

An

error has occurred during processing (rsProcessingAborted)
Cannot

create a connection to data source ‘risk-op’ (rsErrorOpeningConnection)

This error occurs

because the user is not a user on the SQL server database. However if I add the

user to the database the user is able to then view the report.

The

reason for this is because reporting services is configured to use windows

authentication as shown below. As a result when the user presses ‘Go’ to view a

report, reporting services tries to connect to the database using windows authentication

and if that user is not setup as a user on the database the user is then not

able to view the report.

I need to get around this problem. I don’t want to have to

manually add users to the database every time (that maintenance for a couple of

hundred people would be a disaster!)

I believe that a way around this would be to use ‘Credentials

stored securely in the report server’ in SQL Server Reporting Services. Is this

the way to do it and if so, where do I add these credentials to the report

server?

I came across an article that said “Credentials are stored in

reversible encryption in the report server database. You can specify one set of

stored credentials for each data source used in a report. The credentials you

provide retrieve the same data for every user who runs the report.”

How do I add these credentials and is this the answer to my

problem?

Do I have to change something in the RSreportserver.config

file?
Any help would be much appreciated, thanks!
Ian

No you can simply switch that in the data source section by specifying a custom data source for the report. By switching, you will use SQL Server Authentication instead of Windows Authentication.

If you want to do that on a server level and you want to use Windows authentication rather than SQL Server authentication, you could use one Windows User for Reporting Services, enable Anynomous authentication on the Web Server and specify the use under the IIS context for Anonymous Authentication.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Hi Jens,

Thanks for your reply.
You said,
“No you can simply switch that in the data source section by specifying a custom data source for the report. By switching, you will use SQL Server Authentication instead of Windows Authentication.

If you want to do that on a server level and you want to use Windows authentication rather than SQL Server authentication, you could use one Windows User for Reporting Services, enable Anynomous authentication on the Web Server and specify the use under the IIS context for Anonymous Authentication.”

Ok so in the web front end of SQL Server Reporting Services I just untick Windows auth and tick SQL Server auth instead? I tried doing this but it didn’t work. (presumably because I hadn’t created the SQL Server user to authenticate? Is it just a case of creating a user on the database?)

You then say “you could use one Windows User for Reporting Service”, how do I do this?

“enable Anynomous authentication on the Web Server” – I have that done in IIS on the web server for the folder ‘risk-op’ which is where my application is but do I actually have to allow anonymous access somewhere else?
Thanks again, your help is much appreciated,
Ian

|||Has there ever been a final resolution to this? I am having a similar problem.

rsErrorOpeningConnection

Hi,
I really really need some help with the problem below. I am having problems trying to run reports from a VB.Net application. The problem is as follows:

SQL Server 2005, SQL Server Reporting Services and the VB .NET application called ‘risk-op’ are on a server.

A user tries to access the application from a remote computer. The application is displayed and the user is able to do everything. However when the user tries to click ‘Go’ for one of the reports the following error is displayed:

An error has occurred during processing (rsProcessingAborted)
Cannot create a connection to data source ‘risk-op’ (rsErrorOpeningConnection)

This error occurs because the user is not a user on the SQL server database. However if I add the user to the database the user is able to then view the report.

The reason for this is because reporting services is configured to use windows authentication as shown below. As a result when the user presses ‘Go’ to view a report, reporting services tries to connect to the database using windows authentication and if that user is not setup as a user on the database the user is then not able to view the report.

I need to get around this problem. I don’t want to have to manually add users to the database every time (that maintenance for a couple of hundred people would be a disaster!)

I believe that a way around this would be to use ‘Credentials stored securely in the report server’ in SQL Server Reporting Services. Is this the way to do it and if so, where do I add these credentials to the report server?

I came across an article that said “Credentials are stored in reversible encryption in the report server database. You can specify one set of stored credentials for each data source used in a report. The credentials you provide retrieve the same data for every user who runs the report.”

How do I add these credentials and is this the answer to my problem?

Do I have to change something in the RSreportserver.config file?
Any help would be much appreciated, thanks!
Ian

No you can simply switch that in the data source section by specifying a custom data source for the report. By switching, you will use SQL Server Authentication instead of Windows Authentication.

If you want to do that on a server level and you want to use Windows authentication rather than SQL Server authentication, you could use one Windows User for Reporting Services, enable Anynomous authentication on the Web Server and specify the use under the IIS context for Anonymous Authentication.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Hi Jens,

Thanks for your reply.
You said,
“No you can simply switch that in the data source section by specifying a custom data source for the report. By switching, you will use SQL Server Authentication instead of Windows Authentication.

If you want to do that on a server level and you want to use Windows authentication rather than SQL Server authentication, you could use one Windows User for Reporting Services, enable Anynomous authentication on the Web Server and specify the use under the IIS context for Anonymous Authentication.”

Ok so in the web front end of SQL Server Reporting Services I just untick Windows auth and tick SQL Server auth instead? I tried doing this but it didn’t work. (presumably because I hadn’t created the SQL Server user to authenticate? Is it just a case of creating a user on the database?)

You then say “you could use one Windows User for Reporting Service”, how do I do this?

“enable Anynomous authentication on the Web Server” – I have that done in IIS on the web server for the folder ‘risk-op’ which is where my application is but do I actually have to allow anonymous access somewhere else?
Thanks again, your help is much appreciated,
Ian

|||Has there ever been a final resolution to this? I am having a similar problem.sql

rsactivate issues

After installation of ReportingService (dev edition), I get a note that the
server is not activated. I try to activate via command below and get an
exception about unable to connect to the database. I've attached the log
file as well.
One of the messages said to look for MDAC version, this machine has SQL 2000
SP3 installed so using cc.exe came up with 2.8 MDAC version. Wondering what
else I can do. This is one of several RS installations but none of the
other installations have had this error. Any clue?
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer>rsactivate -c "C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config" -t
Failure starting the web service:
System.Exception: Unable to connect to the database (-2147159551)
0x800700
7f --> System.Exception: 0x8007007f
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32
clientType)
at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
Bas
eCmdLine instance)
Log File______________________
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
tent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
w3wp!crypto!948!10/05/2004-19:23:43:: i INFO: Initializing crypto as user:
NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!948!10/05/2004-19:23:43:: i INFO: Exporting public key
w3wp!crypto!948!10/05/2004-19:23:43:: w WARN: Web Service not activated
w3wp!crypto!948!10/05/2004-19:23:43:: i INFO: Client is a local admin.
Activating web service via RPC.
w3wp!library!948!10/05/2004-19:23:43:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information. -->
System.Runtime.InteropServices.COMException (0x80004005): -2147159551 -->
System.Exception: 0x8007007f
at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
Int32 extendedError)
at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID, Int32
clientType)
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --
w3wp!webserver!948!10/05/2004-19:23:43:: e ERROR: Reporting Services error
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information. -->
System.Runtime.InteropServices.COMException (0x80004005): -2147159551 -->
System.Exception: 0x8007007f
at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
Int32 extendedError)
at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID, Int32
clientType)
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --I am having the exact same error. Any help would be much appreciated.
In case it helps... my server is Windows 2k Server SP4, MDAC 2.8, SQL 2000 SP3
"Sam" wrote:
>
> After installation of ReportingService (dev edition), I get a note that the
> server is not activated. I try to activate via command below and get an
> exception about unable to connect to the database. I've attached the log
> file as well.
> One of the messages said to look for MDAC version, this machine has SQL 2000
> SP3 installed so using cc.exe came up with 2.8 MDAC version. Wondering what
> else I can do. This is one of several RS installations but none of the
> other installations have had this error. Any clue?
>
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer>rsactivate -c "C:\Program Files\Microsoft SQL
> Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config" -t
> Failure starting the web service:
> System.Exception: Unable to connect to the database (-2147159551)
> 0x800700
> 7f --> System.Exception: 0x8007007f
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32
> clientType)
> at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
> at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
> Bas
> eCmdLine instance)
>
> Log File______________________
>
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
> tent()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> w3wp!crypto!948!10/05/2004-19:23:43:: i INFO: Initializing crypto as user:
> NT AUTHORITY\NETWORK SERVICE
> w3wp!crypto!948!10/05/2004-19:23:43:: i INFO: Exporting public key
> w3wp!crypto!948!10/05/2004-19:23:43:: w WARN: Web Service not activated
> w3wp!crypto!948!10/05/2004-19:23:43:: i INFO: Client is a local admin.
> Activating web service via RPC.
> w3wp!library!948!10/05/2004-19:23:43:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information. -->
> System.Runtime.InteropServices.COMException (0x80004005): -2147159551 -->
> System.Exception: 0x8007007f
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID, Int32
> clientType)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> -- End of inner exception stack trace --
> w3wp!webserver!948!10/05/2004-19:23:43:: e ERROR: Reporting Services error
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information. -->
> System.Runtime.InteropServices.COMException (0x80004005): -2147159551 -->
> System.Exception: 0x8007007f
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID, Int32
> clientType)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> -- End of inner exception stack trace --
>
>|||I am having the exact same error. Any help would be much appreciated.
In case it helps... my server is Windows 2k Server SP4, MDAC 2.8, SQL 2000
SP3, and Reporting Services SP1
"Sam" wrote:
>
> After installation of ReportingService (dev edition), I get a note that the
> server is not activated. I try to activate via command below and get an
> exception about unable to connect to the database. I've attached the log
> file as well.
> One of the messages said to look for MDAC version, this machine has SQL 2000
> SP3 installed so using cc.exe came up with 2.8 MDAC version. Wondering what
> else I can do. This is one of several RS installations but none of the
> other installations have had this error. Any clue?
>
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer>rsactivate -c "C:\Program Files\Microsoft SQL
> Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config" -t
> Failure starting the web service:
> System.Exception: Unable to connect to the database (-2147159551)
> 0x800700
> 7f --> System.Exception: 0x8007007f
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32
> clientType)
> at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
> at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
> Bas
> eCmdLine instance)
>
> Log File______________________
>
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
> tent()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> w3wp!crypto!948!10/05/2004-19:23:43:: i INFO: Initializing crypto as user:
> NT AUTHORITY\NETWORK SERVICE
> w3wp!crypto!948!10/05/2004-19:23:43:: i INFO: Exporting public key
> w3wp!crypto!948!10/05/2004-19:23:43:: w WARN: Web Service not activated
> w3wp!crypto!948!10/05/2004-19:23:43:: i INFO: Client is a local admin.
> Activating web service via RPC.
> w3wp!library!948!10/05/2004-19:23:43:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information. -->
> System.Runtime.InteropServices.COMException (0x80004005): -2147159551 -->
> System.Exception: 0x8007007f
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID, Int32
> clientType)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> -- End of inner exception stack trace --
> w3wp!webserver!948!10/05/2004-19:23:43:: e ERROR: Reporting Services error
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information. -->
> System.Runtime.InteropServices.COMException (0x80004005): -2147159551 -->
> System.Exception: 0x8007007f
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID, Int32
> clientType)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> -- End of inner exception stack trace --
>
>sql