SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 An error has occurred during report processing."
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

vasu436
Starting Member

India
6 Posts

Posted - 07/10/2013 :  02:41:47  Show Profile  Reply with Quote
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

Edited by - vasu436 on 07/10/2013 02:51:21

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 07/10/2013 :  03:02:05  Show Profile  Reply with Quote
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

India
6 Posts

Posted - 07/10/2013 :  03:26:32  Show Profile  Reply with Quote
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

Edited by - vasu436 on 07/10/2013 03:27:44
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 07/10/2013 :  03:37:33  Show Profile  Reply with Quote
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

India
6 Posts

Posted - 07/10/2013 :  04:44:20  Show Profile  Reply with Quote
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

India
52309 Posts

Posted - 07/10/2013 :  05:03:59  Show Profile  Reply with Quote
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

India
6 Posts

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

Regards,
Srini




Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000