June 29, 2009 at 2:04 am
Hi ,
I receive very often the error message 'Thread being aborted' at several subscriptions of different reports.
The strange thing is that it's not always the same subscription/report .
Sometimes there's no problem at all . Wen i run the report again everything goes well.
Can anyone help how to avoid this in the future ?
tx a lot for helping
regards stanja
This i found at the logfile
... brary!WindowsService_7!298!06/29/2009-07:30:03:: i INFO: Schedule 2c673706-ea18-427e-a52a-265287cea633 execution completed at 06/29/2009 07:30:03.
library!WindowsService_7!5bc!06/29/2009-07:30:09:: i INFO: RenderForNewSession('/Hoboken Reporting/Management - Weekly sales giftvouchers')
runningjobs!WindowsService_7!298!06/29/2009-07:30:47:: i INFO: Adding: 1 running jobs to the database
library!WindowsService_7!98!06/29/2009-07:37:06:: i INFO: Schedule 5a4df516-c48e-4496-b86c-4624fef0d9d0 executed at 06/29/2009 07:37:06.
schedule!WindowsService_7!98!06/29/2009-07:37:06:: Creating Time based subscription notification for subscription: 87c92bdb-9614-4c5b-af47-a6263b26f871
library!WindowsService_7!98!06/29/2009-07:37:06:: i INFO: Schedule 5a4df516-c48e-4496-b86c-4624fef0d9d0 execution completed at 06/29/2009 07:37:06.
runningjobs!WindowsService_7!298!06/29/2009-07:37:20:: i INFO: CancelableJobExecution.Execute caught some other thread abort exception
notification!WindowsService_7!298!06/29/2009-07:37:20:: e ERROR: Error occured processing notification. Thread was being aborted.
appdomainmanager!DefaultDomain!ae4!06/29/2009-07:38:01:: w WARN: Shrink notification failed due to Thread Abort.
appdomainmanager!DefaultDomain!ae4!06/29/2009-07:38:02:: w WARN: Shrink notification failed due to Thread Abort.
appdomainmanager!DefaultDomain!ae4!06/29/2009-07:38:08:: w WARN: Shrink notification failed due to Thread Abort.
appdomainmanager!DefaultDomain!ae4!06/29/2009-07:38:08:: w WARN: Shrink notification failed due to Thread Abort.
appdomainmanager!DefaultDomain!ae4!06/29/2009-07:38:09:: w WARN: Shrink notification failed due to Thread Abort.
appdomainmanager!DefaultDomain!ae4!06/29/2009-07:38:42:: w WARN: Shrink notification failed due to Thread Abort.
library!WindowsService_7!98!06/29/2009-07:38:45:: i INFO: Call to CleanBatch()
library!WindowsService_7!98!06/29/2009-07:38:45:: i INFO: Cleaned 0 batch record
March 11, 2013 at 1:42 pm
I'm having a similar problem. Anyone run into this? We are running SSRS 2008 R1
e ERROR: Error sending email. System.Threading.ThreadAbortException: Thread was being aborted.
at ReportingServicesCDOInterop.MessageClass.set_HTMLBody(String pHTMLBody)
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
notification!WindowsService_175!9d8!03/09/2013-06:01:18:: e ERROR: Error thrown by delivery provider: System.Threading.ThreadAbortException: Thread was being aborted.
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
at Microsoft.ReportingServices.Library.NotificationQueueWorker.HandleNotification(QueueItem item)
notification!WindowsService_175!2994!03/09/2013-06:01:18:: i INFO: Handling subscription 2f3gg4ca-2104-4256-ac89-95e7b178630a to report CustomerInventory, owner: DOMAIN\USER, delivery extension: Report Server Email.
library!WindowsService_175!2994!03/09/2013-06:01:18:: i INFO: RenderForNewSession('/Folder/CustomerInventory')
library!WindowsService_175!3a20!03/09/2013-06:01:19:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
emailextension!WindowsService_175!3a20!03/09/2013-06:01:19:: e ERROR: Error sending email. System.Threading.ThreadAbortException: Thread was being aborted.
at ReportingServicesCDOInterop.MessageClass.set_HTMLBody(String pHTMLBody)
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
notification!WindowsService_175!3a20!03/09/2013-06:01:19:: e ERROR: Error thrown by delivery provider: System.Threading.ThreadAbortException: Thread was being aborted.
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
at Microsoft.ReportingServices.Library.NotificationQueueWorker.HandleNotification(QueueItem item)
notification!WindowsService_175!1270!03/09/2013-06:01:21:: i INFO: Handling subscription bfsssec-8c09-425e-89c4-bcde7788d5c1 to report Summary, owner: DOMAIN\USER, delivery extension: Report Server Email.
library!WindowsService_175!1270!03/09/2013-06:01:21:: i INFO: RenderForNewSession('/Folder/Summary')
library!WindowsService_175!2994!03/09/2013-06:01:25:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
March 11, 2013 at 1:46 pm
Restarting the SSRS service got everything back on track but I cannot trace the root cause of this
March 12, 2013 at 6:08 pm
Take a look at this for troubleshooting reporting services logs http://blogs.msdn.com/b/deanka/archive/2010/02/16/troubleshooting-subscriptions-part-ii-using-the-report-services-trace-log-file.aspx
These both look like different issues.
Stanja appears to be related to the SQL Agent, Vinny looks to be an email server issue.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply