Error in email delivery!

DiegoH · March 7th, 2005, 04:52 PM

Hi, this is my configuration:
Server1: Windows Server 2003 as report server with SP1.
Server 2: Windows Server 2003 Database server (SQL authentication) with SQL 2000 SP3.

I'm gettin' next error when using email suscriptions: Failure sending mail: An unexpected error occurred in Report Processing.

File share extension is working just fine.

I've checked log files and changed RsReportServer.config configuration, but I canÂ´t fix it. I've included log file, and RsReportServer config below.

Thanks in advance.

Diego H.

---------------------------------------------------------------------
<RSEmailDPConfiguration>
<SMTPServer>my_smtp_server</SMTPServer>
    <SMTPServerPort>25</SMTPServerPort>
    <SMTPAccountName></SMTPAccountName>
    <SMTPConnectionTimeout>60</SMTPConnectionTimeout>
    <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
    <SMTPUseSSL></SMTPUseSSL>
    <SendUsing>2</SendUsing>
    <SMTPAuthenticate></SMTPAuthenticate>
    <From>[email protected]</From>
    <EmbeddedRenderFormats>
        <RenderingExtension>MHTML</RenderingExtension>
    </EmbeddedRenderFormats>
    <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
    <ExcludedRenderFormats>
        <RenderingExtension>HTMLOWC</RenderingExtension>
        <RenderingExtension>NULL</RenderingExtension>
    </ExcludedRenderFormats>
    <SendEmailToUserAlias>True</SendEmailToUserAlias>
    <DefaultHostName></DefaultHostName>
    <PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>

---------------------------------------------------------------------

ReportingServicesService!library!137c!02/18/2005-12:19:57:: i INFO: Call to RenderFirst( '/Lista Empleados DYG' )
ReportingServicesService!library!137c!02/18/2005-12:19:57:: i INFO: Initializing SessionTimeout to '600' second(s) as specified in Server system properties.
ReportingServicesService!library!137c!02/18/2005-12:19:57:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!library!137c!02/18/2005-12:19:57:: i INFO: Initializing SessionAccessTimeout to default value of '600' seconds because it was not specified in Server system properties.
ReportingServicesService!library!a38!02/18/2005-12:19:58:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!library!848!18/02/2005-12:19:58:: i INFO: Initializing SqlStreamingBufferSize to default value of '64640' Bytes because it was not specified in Server system properties.
ReportingServicesService!library!848!18/02/2005-12:19:58:: i INFO: Initializing SnapshotCompression to 'SQL' as specified in Server system properties.
ReportingServicesService!library!848!18/02/2005-12:19:58:: Using folder C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\RSTempFiles for temporary files.
ReportingServicesService!session!137c!02/18/2005-12:19:58:: i INFO: LoadSnapshot: Item with session: mvzo0fuaap4oqa45pgi4kp2t, reportPath: /Lista Empleados DYG, userName: DYG\biuser not found in the database
ReportingServicesService!session!a38!02/18/2005-12:19:58:: i INFO: LoadSnapshot: Item with session: jdacns4543yu00jse0pssrzw, reportPath: /Finanzas/AnÃ¡lisis de VariaciÃ³n de Gastos, userName: DYG\biuser not found in the database
ReportingServicesService!chunks!a38!02/18/2005-12:19:58:: i INFO: ### GetReportChunk('AnÃ¡lisis de VariaciÃ³n de Gastos_style', 1), chunk was not found! this=6d432576-b08f-459d-8d31-312f4450aa9f
ReportingServicesService!chunks!a38!02/18/2005-12:19:58:: i INFO: ### GetReportChunk('Main', 0), chunk was not found! this=6d432576-b08f-459d-8d31-312f4450aa9f
ReportingServicesService!processing!a38!02/18/2005-12:19:58:: a ASSERT: Assertion failed! Call stack:
    Microsoft.ReportingServices.ReportProcessing.Persi stence.f.b(Boolean A_0)
    Microsoft.ReportingServices.ReportProcessing.Persi stence.f.a(Stream A_0)
    Microsoft.ReportingServices.ReportProcessing.Persi stence.f..ctor(Stream A_0)
    Microsoft.ReportingServices.ReportProcessing.Repor tProcessing.a(GetReportChunk A_0, CreateReportChunk A_1, Hashtable& A_2, a& A_3, Boolean& A_4)
    Microsoft.ReportingServices.ReportProcessing.Repor tProcessing.RenderSnapshotStream(CreateReportChunk createChunkCallback, String streamName, RenderingContext rc, GetResource getResourceCallback)
    Microsoft.ReportingServices.Library.RSService.Inte rnalGetReportImageLive(ClientRequest session, CatalogItemContext itemContext, String imageId)
    Microsoft.ReportingServices.Library.RSService.Inte rnalGetReportImage(ClientRequest session, CatalogItemContext itemContext)
    Microsoft.ReportingServices.Library.RSService.GetR eportImage(ClientRequest session, CatalogItemContext itemContext)
    Microsoft.ReportingServices.Library.RenderedOutput FileImpl.GetRsStream()
    Microsoft.ReportingServices.Library.RenderedOutput FileImpl.get_FileName()
    Microsoft.ReportingServices.EmailDeliveryProvider. EmailProvider.EmbedReport(IMessage message, RenderedOutputFile[] reportData, Notification notification, SubscriptionData data)
    Microsoft.ReportingServices.EmailDeliveryProvider. EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
    Microsoft.ReportingServices.EmailDeliveryProvider. EmailProvider.CreateMessage(Notification notification)
    Microsoft.ReportingServices.EmailDeliveryProvider. EmailProvider.Deliver(Notification notification)
    Microsoft.ReportingServices.Library.NotificationQu eueWorker.HandleNotification(QueueItem item)
    Microsoft.ReportingServices.Library.NotificationQu eueWorker.QueueWorker(QueueItem item)
    Microsoft.ReportingServices.Library.QueuePollWorke r.WorkItemStart(Object state)

ReportingServicesService!chunks!137c!02/18/2005-12:19:58:: i INFO: ### GetReportChunk('Lista Empleados DYG_style', 1), chunk was not found! this=582c64ef-d2e5-4e23-8630-209ff0556b50
ReportingServicesService!chunks!137c!02/18/2005-12:19:58:: i INFO: ### GetReportChunk('Main', 0), chunk was not found! this=582c64ef-d2e5-4e23-8630-209ff0556b50
ReportingServicesService!processing!137c!02/18/2005-12:19:58:: a ASSERT: Assertion failed! Call stack:
    Microsoft.ReportingServices.ReportProcessing.Persi stence.f.b(Boolean A_0)
    Microsoft.ReportingServices.ReportProcessing.Persi stence.f.a(Stream A_0)
    Microsoft.ReportingServices.ReportProcessing.Persi stence.f..ctor(Stream A_0)
    Microsoft.ReportingServices.ReportProcessing.Repor tProcessing.a(GetReportChunk A_0, CreateReportChunk A_1, Hashtable& A_2, a& A_3, Boolean& A_4)
    Microsoft.ReportingServices.ReportProcessing.Repor tProcessing.RenderSnapshotStream(CreateReportChunk createChunkCallback, String streamName, RenderingContext rc, GetResource getResourceCallback)
    Microsoft.ReportingServices.Library.RSService.Inte rnalGetReportImageLive(ClientRequest session, CatalogItemContext itemContext, String imageId)
    Microsoft.ReportingServices.Library.RSService.Inte rnalGetReportImage(ClientRequest session, CatalogItemContext itemContext)
    Microsoft.ReportingServices.Library.RSService.GetR eportImage(ClientRequest session, CatalogItemContext itemContext)
    Microsoft.ReportingServices.Library.RenderedOutput FileImpl.GetRsStream()
    Microsoft.ReportingServices.Library.RenderedOutput FileImpl.get_FileName()
    Microsoft.ReportingServices.EmailDeliveryProvider. EmailProvider.EmbedReport(IMessage message, RenderedOutputFile[] reportData, Notification notification, SubscriptionData data)
    Microsoft.ReportingServices.EmailDeliveryProvider. EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
    Microsoft.ReportingServices.EmailDeliveryProvider. EmailProvider.CreateMessage(Notification notification)
    Microsoft.ReportingServices.EmailDeliveryProvider. EmailProvider.Deliver(Notification notification)
    Microsoft.ReportingServices.Library.NotificationQu eueWorker.HandleNotification(QueueItem item)
    Microsoft.ReportingServices.Library.NotificationQu eueWorker.QueueWorker(QueueItem item)
    Microsoft.ReportingServices.Library.QueuePollWorke r.WorkItemStart(Object state)

ReportingServicesService!processing!137c!02/18/2005-12:19:58:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.Repor tProcessingException: An unexpected error occurred in Report Processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.Repor tProcessingException: An unexpected error occurred in Report Processing.
ReportingServicesService!emailextension!137c!02/18/2005-12:19:58:: Error sending email. Microsoft.ReportingServices.ReportProcessing.Repor tProcessingException: An unexpected error occurred in Report Processing.
   at Microsoft.ReportingServices.ReportProcessing.Persi stence.f.b(Boolean A_0)
   at Microsoft.ReportingServices.ReportProcessing.Persi stence.f.a(Stream A_0)
   at Microsoft.ReportingServices.ReportProcessing.Persi stence.f..ctor(Stream A_0)
   at Microsoft.ReportingServices.ReportProcessing.Repor tProcessing.a(GetReportChunk A_0, CreateReportChunk A_1, Hashtable& A_2, a& A_3, Boolean& A_4)
   at Microsoft.ReportingServices.ReportProcessing.Repor tProcessing.RenderSnapshotStream(CreateReportChunk createChunkCallback, String streamName, RenderingContext rc, GetResource getResourceCallback)
   at Microsoft.ReportingServices.Library.RSService.Inte rnalGetReportImageLive(ClientRequest session, CatalogItemContext itemContext, String imageId)
   at Microsoft.ReportingServices.Library.RSService.Inte rnalGetReportImage(ClientRequest session, CatalogItemContext itemContext)
   at Microsoft.ReportingServices.Library.RSService.GetR eportImage(ClientRequest session, CatalogItemContext itemContext)
   at Microsoft.ReportingServices.Library.RenderedOutput FileImpl.GetRsStream()
   at Microsoft.ReportingServices.Library.RenderedOutput FileImpl.get_FileName()
   at Microsoft.ReportingServices.EmailDeliveryProvider. EmailProvider.EmbedReport(IMessage message, RenderedOutputFile[] reportData, Notification notification, SubscriptionData data)
   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)
ReportingServicesService!processing!a38!02/18/2005-12:19:58:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.Repor tProcessingException: An unexpected error occurred in Report Processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.Repor tProcessingException: An unexpected error occurred in Report Processing.
ReportingServicesService!emailextension!a38!02/18/2005-12:19:58:: Error sending email. Microsoft.ReportingServices.ReportProcessing.Repor tProcessingException: An unexpected error occurred in Report Processing.
   at Microsoft.ReportingServices.ReportProcessing.Persi stence.f.b(Boolean A_0)
   at Microsoft.ReportingServices.ReportProcessing.Persi stence.f.a(Stream A_0)
   at Microsoft.ReportingServices.ReportProcessing.Persi stence.f..ctor(Stream A_0)
   at Microsoft.ReportingServices.ReportProcessing.Repor tProcessing.a(GetReportChunk A_0, CreateReportChunk A_1, Hashtable& A_2, a& A_3, Boolean& A_4)
   at Microsoft.ReportingServices.ReportProcessing.Repor tProcessing.RenderSnapshotStream(CreateReportChunk createChunkCallback, String streamName, RenderingContext rc, GetResource getResourceCallback)
   at Microsoft.ReportingServices.Library.RSService.Inte rnalGetReportImageLive(ClientRequest session, CatalogItemContext itemContext, String imageId)
   at Microsoft.ReportingServices.Library.RSService.Inte rnalGetReportImage(ClientRequest session, CatalogItemContext itemContext)
   at Microsoft.ReportingServices.Library.RSService.GetR eportImage(ClientRequest session, CatalogItemContext itemContext)
   at Microsoft.ReportingServices.Library.RenderedOutput FileImpl.GetRsStream()
   at Microsoft.ReportingServices.Library.RenderedOutput FileImpl.get_FileName()
   at Microsoft.ReportingServices.EmailDeliveryProvider. EmailProvider.EmbedReport(IMessage message, RenderedOutputFile[] reportData, Notification notification, SubscriptionData data)
   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)
ReportingServicesService!notification!137c!02/18/2005-12:19:58:: Notification b4789459-548b-4d29-a0f6-46cbec1bec2a completed. Success: False, Status: Failure sending mail: An unexpected error occurred in Report Processing., DeliveryExtension: Report Server Email, Report: Lista Empleados DYG, Attempt 0
ReportingServicesService!dbpolling!137c!02/18/2005-12:19:58:: NotificationPolling finished processing item b4789459-548b-4d29-a0f6-46cbec1bec2a
ReportingServicesService!notification!a38!02/18/2005-12:19:58:: Notification 96e2a1bb-371a-4b43-8d9a-65518b6d8d65 completed. Success: False, Status: Failure sending mail: An unexpected error occurred in Report Processing., DeliveryExtension: Report Server Email, Report: AnÃ¡lisis de VariaciÃ³n de Gastos, Attempt 0
ReportingServicesService!dbpolling!a38!02/18/2005-12:19:58:: NotificationPolling finished processing item 96e2a1bb-371a-4b43-8d9a-65518b6d8d65
ReportingServicesService!dbpolling!11d4!18/02/2005-12:24:47:: EventPolling polling service stopped
ReportingServicesService!dbpolling!1188!18/02/2005-12:24:47:: EventPolling heartbeat thread exiting for stop.
ReportingServicesService!dbpolling!11d4!18/02/2005-12:24:47:: NotificationPolling polling service stopped
ReportingServicesService!dbpolling!ee8!18/02/2005-12:24:47:: NotificationPolling heartbeat thread exiting for stop.
ReportingServicesService!dbpolling!11d4!18/02/2005-12:24:47:: SchedulePolling polling service stopped
ReportingServicesService!servicecontroller!11d4!18/02/2005-12:24:47:: Service controller exiting.