Data Driven Subscription Error

  • 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.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply