Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Thread being aborted at subscription Expand / Collapse
Author
Message
Posted Monday, June 29, 2009 2:04 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 5, 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
Posted Monday, March 11, 2013 1:42 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 6, 2014 9:17 AM
Points: 11, Visits: 331
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
Posted Monday, March 11, 2013 1:46 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 6, 2014 9:17 AM
Points: 11, Visits: 331
Restarting the SSRS service got everything back on track but I cannot trace the root cause of this
Post #1429466
Posted Tuesday, March 12, 2013 6:08 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 7:35 AM
Points: 471, Visits: 874
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 »

Add to briefcase

Permissions Expand / Collapse