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

Data Driven Subscription Error Expand / Collapse
Author
Message
Posted Friday, May 03, 2013 12:33 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, December 04, 2013 2:36 AM
Points: 28, Visits: 78
Hello Friends,

I'm getting following error during Data Driven Subscripion on SQL Sever 2008 R2, can you please help me on this:

Log file details:

library!WindowsService_24!140c!05/07/2013-11:27:08:: i INFO: Schedule 07182ea3-9553-4dff-a21e-76a710cce2cc executed at 05/07/2013 11:27:08.
schedule!WindowsService_24!140c!05/07/2013-11:27:08:: Creating Time based subscription notification for subscription: cde3ed53-93fe-4080-8994-cf5b235ab67c
library!WindowsService_24!140c!05/07/2013-11:27:08:: i INFO: Schedule 07182ea3-9553-4dff-a21e-76a710cce2cc execution completed at 05/07/2013 11:27:08.
library!WindowsService_24!14ec!05/07/2013-11:27:08:: i INFO: Handling data-driven subscription cde3ed53-93fe-4080-8994-cf5b235ab67c to report /Retail Management Reports/Amit test/Top Sellers Report (inc VAT)_Prod, owner: VFCORP\JOSHIM, delivery extension: Report Server Email.
library!WindowsService_24!14ec!05/07/2013-11:27:09:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
library!WindowsService_24!14ec!05/07/2013-11:27:09:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
notification!WindowsService_24!14ec!05/07/2013-11:27:09:: i INFO: Handling subscription cde3ed53-93fe-4080-8994-cf5b235ab67c to report Top Sellers Report (inc VAT)_Prod, owner: VFCORP\JOSHIM, delivery extension: Report Server Email.
library!WindowsService_24!14ec!05/07/2013-11:27:09:: i INFO: RenderForNewSession('/Retail Management Reports/Amit test/Top Sellers Report (inc VAT)_Prod')
library!ReportServer_0-38!3fc8!05/07/2013-11:27:10:: Call to GetPermissionsAction(/Retail Management Reports/Amit test/Top Sellers Report (inc VAT)_Prod).
library!ReportServer_0-38!3fc8!05/07/2013-11:27:10:: Call to GetSystemPropertiesAction().
library!ReportServer_0-38!3fc8!05/07/2013-11:27:10:: Call to GetPropertiesAction(/Retail Management Reports/Amit test/Top Sellers Report (inc VAT)_Prod, PathBased).
library!ReportServer_0-38!3fc8!05/07/2013-11:27:10:: Call to GetPropertiesAction(/Retail Management Reports/Amit test/Top Sellers Report (inc VAT)_Prod, PathBased).
library!ReportServer_0-38!360c!05/07/2013-11:27:11:: Call to GetItemTypeAction(/Retail Management Reports/Amit test/Top Sellers Report (inc VAT)_Prod).
library!ReportServer_0-38!360c!05/07/2013-11:27:11:: Call to GetReportParametersAction(/Retail Management Reports/Amit test/Top Sellers Report (inc VAT)_Prod).
library!ReportServer_0-38!3fc8!05/07/2013-11:27:11:: Call to GetSystemPermissionsAction().
library!ReportServer_0-38!3fc8!05/07/2013-11:27:11:: Call to GetItemTypeAction(/Retail Management Reports/Amit test/Top Sellers Report (inc VAT)_Prod).
library!ReportServer_0-38!3fc8!05/07/2013-11:27:11:: Call to ListSubscriptionsAction(/Retail Management Reports/Amit test/Top Sellers Report (inc VAT)_Prod, null).
library!ReportServer_0-38!3fc8!05/07/2013-11:27:11:: Call to GetPropertiesAction(/Retail Management Reports/Amit test/Top Sellers Report (inc VAT)_Prod, PathBased).
library!ReportServer_0-38!3fc8!05/07/2013-11:27:11:: Call to GetItemDataSourcesAction(/Retail Management Reports/Amit test/Top Sellers Report (inc VAT)_Prod).
library!ReportServer_0-38!3fc8!05/07/2013-11:27:11:: Call to GetItemTypeAction(/Retail Management Reports/Amit test/Top Sellers Report (inc VAT)_Prod).
library!ReportServer_0-38!3fc8!05/07/2013-11:27:11:: Call to GetReportItemReferencesAction(/Retail Management Reports/Amit test/Top Sellers Report (inc VAT)_Prod).
library!ReportServer_0-38!360c!05/07/2013-11:27:11:: Call to GetSystemPropertiesAction().
httpruntime!ReportManager_0-39!3fc8!05/07/2013-11:27:11:: e ERROR: Failed in BaseWorkerRequest::SendHttpResponse(bool), exception=System.AppDomainUnloadedException: Attempted to access an unloaded appdomain. (Exception from HRESULT: 0x80131014)
at System.StubHelpers.StubHelpers.GetCOMHRExceptionObject(Int32 hr, IntPtr pFrame, Object pThis)
at Microsoft.ReportingServices.HostingInterfaces.IRsHttpPipeline.SendResponse(Void* response, Boolean finalWrite, Boolean closeConn)
at ReportingServicesHttpRuntime.BaseWorkerRequest.SendHttpResponse(Boolean finalFlush)
library!ReportManager_0-39!3fc8!05/07/2013-11:27:11:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: RsWorkerRequest::FlushResponse., Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportManager_MSSQLSERVER_0-39-130123889993312881. ---> System.AppDomainUnloadedException: Attempted to access an unloaded appdomain. (Exception from HRESULT: 0x80131014)
at ReportingServicesHttpRuntime.BaseWorkerRequest.SendHttpResponse(Boolean finalFlush)
at ReportingServicesHttpRuntime.RsWorkerRequest.FlushResponse(Boolean finalFlush)
--- End of inner exception stack trace ---;
library!WindowsService_24!14ec!05/07/2013-11:27:15:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
emailextension!WindowsService_24!14ec!05/07/2013-11:27:15:: e ERROR: Error sending email. System.Runtime.InteropServices.COMException (0x80040213): The transport failed to connect to the server.

at ReportingServicesCDOInterop.MessageClass.Send()
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
notification!WindowsService_24!14ec!05/07/2013-11:27:15:: e ERROR: Error occured processing subscription cde3ed53-93fe-4080-8994-cf5b235ab67c: Failure sending mail: The transport failed to connect to the server.

Post #1449061
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse