Thread being aborted at subscription

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » Thread being aborted at subscription

Thread being aborted at subscription

Rate Topic

Display Mode

Topic Options

Author

Message

stanja-271190

Posted Monday, June 29, 2009 2:04 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, November 05, 2012 7:07 AM
Points: 40, Visits: 51

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

Post #743404

Vinny-262946

Posted Monday, March 11, 2013 1:42 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, May 10, 2013 12:31 PM
Points: 11, Visits: 301

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.

Post #1429465

Vinny-262946

Posted Monday, March 11, 2013 1:46 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, May 10, 2013 12:31 PM
Points: 11, Visits: 301

Restarting the SSRS service got everything back on track but I cannot trace the root cause of this

Post #1429466

davoscollective

Posted Tuesday, March 12, 2013 6:08 PM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 12:34 AM
Points: 408, Visits: 686

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.

Post #1430164

« Prev Topic | Next Topic »

Permissions