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.
| 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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
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 |
|
|
|
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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
vasu436
Starting Member
6 Posts |
Posted - 2013-07-10 : 04:44:20
|
| I do think the same but not sure what is happeningIt is happening in client side. So, he is asking why it is so...Can you please add some additional info...Regards,Srini |
|
|
|
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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
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 |
|
|
|
|
|
|
An error has occurred during report processing."