Query execution failed for data set ''RS_MeterReading

Hi,

We are using SQL 2005 server for generating reports.When we ran the reports it taking so much time after some time it shows this error:

ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set > System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.

Can you help me out.

Thanks,

--Amit

Hi AMITMEENA

Can you check the Report Query whether it contains all valid columns and tables.

This type of Error may Occur when we are trying to Query the Columns that are not related the tables present in the Query

|||

Hi

This looks like Sql query/procedure error. Check the dataset query/procedure in Sql Query analyzer.

Senthil

|||

Yes ,I did this thing also.But When we ran the " StoreProcedure in Queranalyzer it is working fine ..I am getting the data within 10 sec. for all system.But When we ran the same report from reportviewer..we are getting this eror "ERROR: An exception has occurred in data source . Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set . > System.Data.SqlClient.SqlException: A severe error occurred on the current command"

Can give some inputs.

Your inputs would be appreciated.

|||

Could this be a permissions problem? IOW, does the identity executing the query through RS have the permissions it needs to execute the proc?

>L<

|||

can you give me some detail expaination.I didn't understand what does it?

Thanks,

Amit

|||

What didn't you understand? Checking the permissions for a sproc? Or something else in this thread?

>L<

|||

I have also increase the SesionTimeOut upto 6000sec. but still am getting that error.So i am sending the log files of system.here we want to run the Performancereport,it works fine when we ran this report in QueryAnalyzer but when i ran that report in WebReorting am getting that error log files.:--

|||

Does the report run under the credentials of the user or (as probably has to be for a snapshot) are you storing the credentials with/in report server?

It looks like you're creating a snapshot here.

So, under what credentials is that running? And does that identity have permissions to execute this stored procedure in the appropriate database?

(going to bed now, won't see your reply immediately)

>L<

|||I need some more explaination|||

Hi moderator,

Can you delete my all threads from your system.

Thanks

A

|||

My team is also facing similar problem. The RS trace logs report:

w3wp!processing!13!9/26/2007-15:31:23:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'msdb'., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'msdb'. > System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.
Operation cancelled by user.

In our system, Report Server and Database are on different machines. Report Server access database using a service account who has stored proc execute permissions on database.

Problem comes only if the query execution time exceeds 5 mins. Otherwise the report gets generated successfully.

I suspected this to be some timeout issue. But I have checked that all timeout settings in rs config files are as default.

Any pointers?

Thanks

puns

pun_iit@.hotmail.com