Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 An error has occurred during report processing."

Author  Topic 

vasu436
Starting Member

6 Posts

Posted - 2013-07-10 : 02:41:47
Hi,

While running a report, mostly the report got completed successfully but some times i am receiving the following ERROR in my log file while exporting to CSV.

[Info] DeliverToSure : Rendering Report (CSV)
[Error] Microsoft.ReportingServices.ProcessingCore : ProcessingAbortedException : An error has occurred during report processing.
[Error] Microsoft.ReportingServices.ProcessingCore : ReportProcessingException : Query execution failed for dataset 'dataset_ilt_roster_by_course_and_user'.
[Error] .Net SqlClient Data Provider : SqlException : A severe error occurred on the current command. The results, if any, should be discarded.
Operation cancelled by user.

Please help me.

Regards,

Srini

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-07-10 : 03:02:05
looks like proble is with query for dataset_ilt_roster_by_course_and_user dataset. See executing the query/procedure directly in SSMS and see if you're getting any result.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

vasu436
Starting Member

6 Posts

Posted - 2013-07-10 : 03:26:32
Yes i did the same. But the Query is returning empty result set successfully in 9min through SSMS.

And more about the error that i have mentioned is not frequent. It is happening at a frequency of once in a week. And in remaining days it is completing successfully.

I didn't understand why it is so.

Please suggest what might be the reason.

Regards,
Srini
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-07-10 : 03:37:33
hmm...check if there's some blocking happening at that time. it may that its waiting for some other process to finish and eventually getting timed out

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

vasu436
Starting Member

6 Posts

Posted - 2013-07-10 : 04:44:20
I do think the same but not sure what is happening

It is happening in client side. So, he is asking why it is so...

Can you please add some additional info...

Regards,
Srini
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-07-10 : 05:03:59
not much with current available info. I would just see other activities that happened on db at time of failure and make sure there are no mutual interferences

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

vasu436
Starting Member

6 Posts

Posted - 2013-07-10 : 05:27:43
Thanks visakh16 for your valuable suggestions.
Please post if you identified any further solutions.

Regards,
Srini




Go to Top of Page
   

- Advertisement -