RS2005 email delivery problem

We started using RS 2005 web farm a month ago. Since then we have
problem delivering reports trough email. When using shared
subscription with several reports some reports are sent and some are
not.
Errors displayed by various parts of system are below:
Subscription Last Status text:
The delivery extension for this subscription could not be loaded.
Windows Application event log:
Report Server (MSSQLSERVER) cannot load the Report Server
DocumentLibrary
extension.
At first we thought that problem is our postfix mail server so we
transferred from directly sending mail to sending mail to local SMTP
which then sends mail to postfix. One problem was a connection
timeout. It seems that connection with mail server is opened at the
same time the shared schedule execution has started. With SMTP service
standard time-out of 10 minutes or so reports lasting more than that
have no chance to be sent. So my solution was installing local SMTP
Service from windows components setup and setting its timeout to
timeout needed by our reports. But the problem didn't go away. I was
hoping that unsent mail will be in badmail SMTP folder or that I will
find it in drop folder as unsent mail. Strange thing is that all the
folders are empty. There is no bad mail. My SRS can't send mail to my
local SMTP! When shared subscription with several reports is fired
connection to local SMTP is created. I can see it in Current Sessions.
If subscription is shared I suppose that reports, belonging to shared
subscription, are being executed one by one and sent to SMTP server as
they are finished. Time out of my SMTP is 180 minutes. All the reports
executed one by one take about 30 minutes so I guess now time out is
not a problem. I think that there are 2 possible reasons:
1. Opened connection to SMTP somehow brakes between two reports being
sent and can't be reestablished
2. SRS successfully execute some reports and send them to SMTP and
when next report is finished and have to be sent, SRS can't load DLL
needed to send mail.
Every suggestion will be appreciated!Any ideas?
ijeremi...@.gmail.com wrote:
> We started using RS 2005 web farm a month ago. Since then we have
> problem delivering reports trough email. When using shared
> subscription with several reports some reports are sent and some are
> not.
> Errors displayed by various parts of system are below:
> Subscription Last Status text:
> The delivery extension for this subscription could not be loaded.
> Windows Application event log:
> Report Server (MSSQLSERVER) cannot load the Report Server
> DocumentLibrary
> extension.
> At first we thought that problem is our postfix mail server so we
> transferred from directly sending mail to sending mail to local SMTP
> which then sends mail to postfix. One problem was a connection
> timeout. It seems that connection with mail server is opened at the
> same time the shared schedule execution has started. With SMTP service
> standard time-out of 10 minutes or so reports lasting more than that
> have no chance to be sent. So my solution was installing local SMTP
> Service from windows components setup and setting its timeout to
> timeout needed by our reports. But the problem didn't go away. I was
> hoping that unsent mail will be in badmail SMTP folder or that I will
> find it in drop folder as unsent mail. Strange thing is that all the
> folders are empty. There is no bad mail. My SRS can't send mail to my
> local SMTP! When shared subscription with several reports is fired
> connection to local SMTP is created. I can see it in Current Sessions.
> If subscription is shared I suppose that reports, belonging to shared
> subscription, are being executed one by one and sent to SMTP server as
> they are finished. Time out of my SMTP is 180 minutes. All the reports
> executed one by one take about 30 minutes so I guess now time out is
> not a problem. I think that there are 2 possible reasons:
> 1. Opened connection to SMTP somehow brakes between two reports being
> sent and can't be reestablished
> 2. SRS successfully execute some reports and send them to SMTP and
> when next report is finished and have to be sent, SRS can't load DLL
> needed to send mail.
> Every suggestion will be appreciated!|||If no-one responds here I suggest trying the web based forums. That is where
MS people hang out and the other RS MVP.
http://forums.microsoft.com/msdn/showforum.aspx?forumid=82&siteid=1
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<ijeremicyu@.gmail.com> wrote in message
news:1184243847.242957.320910@.w3g2000hsg.googlegroups.com...
> Any ideas?
> ijeremi...@.gmail.com wrote:
>> We started using RS 2005 web farm a month ago. Since then we have
>> problem delivering reports trough email. When using shared
>> subscription with several reports some reports are sent and some are
>> not.
>> Errors displayed by various parts of system are below:
>> Subscription Last Status text:
>> The delivery extension for this subscription could not be loaded.
>> Windows Application event log:
>> Report Server (MSSQLSERVER) cannot load the Report Server
>> DocumentLibrary
>> extension.
>> At first we thought that problem is our postfix mail server so we
>> transferred from directly sending mail to sending mail to local SMTP
>> which then sends mail to postfix. One problem was a connection
>> timeout. It seems that connection with mail server is opened at the
>> same time the shared schedule execution has started. With SMTP service
>> standard time-out of 10 minutes or so reports lasting more than that
>> have no chance to be sent. So my solution was installing local SMTP
>> Service from windows components setup and setting its timeout to
>> timeout needed by our reports. But the problem didn't go away. I was
>> hoping that unsent mail will be in badmail SMTP folder or that I will
>> find it in drop folder as unsent mail. Strange thing is that all the
>> folders are empty. There is no bad mail. My SRS can't send mail to my
>> local SMTP! When shared subscription with several reports is fired
>> connection to local SMTP is created. I can see it in Current Sessions.
>> If subscription is shared I suppose that reports, belonging to shared
>> subscription, are being executed one by one and sent to SMTP server as
>> they are finished. Time out of my SMTP is 180 minutes. All the reports
>> executed one by one take about 30 minutes so I guess now time out is
>> not a problem. I think that there are 2 possible reasons:
>> 1. Opened connection to SMTP somehow brakes between two reports being
>> sent and can't be reestablished
>> 2. SRS successfully execute some reports and send them to SMTP and
>> when next report is finished and have to be sent, SRS can't load DLL
>> needed to send mail.
>> Every suggestion will be appreciated!
>sql

RS2000: Failure sending mail: Cannot access a closed file...

SQL Server 2000, RS2000...
I have 2 timed subscriptions to the same report. One of the
subscriptions delivers the report via Report Server Email, the other
via File share.
If I choose PDF orWeb Archive as the deliverable then then both
reports work. If I choose Excel, I get the following error message
posted on the Report Server next to Status when I look at both
subscriptions to the report.
Any idea what is happening?
Thanks,
KeithOn Feb 1, 5:29 pm, 1300...@.gmail.com wrote:
> SQL Server 2000, RS2000...
> I have 2 timed subscriptions to the same report. One of the
> subscriptions delivers the report via Report Server Email, the other
> via File share.
> If I choose PDF orWeb Archive as the deliverable then then both
> reports work. If I choose Excel, I get the following error message
> posted on the Report Server next to Status when I look at both
> subscriptions to the report.
Guess including the error might help!
Failure sending mail: Cannot access a closed file
> Any idea what is happening?
> Thanks,
> Keith

RS2000 Large report fails to export to Excel

I have large report (200 pages, landscape 14x8.5) that will not export to
Excel.
Last night we scheduled the report to email us the Excel rendered file. The
subscription page shows the following error.
Failure sending mail: Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
We ran the report manually today and tried to export through the Report
Manager and it tries to download a file that is only 1.84K large. When we
click save we get an error.
Does anyone have any idea what I could do get this report to export to Excel?
I've inlcuded the trace log below detailing the why the it would not send
the mail.
ReportingServicesService!dbpolling!1460!5/4/2006-04:00:09:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!14d4!5/4/2006-04:00:09:: EventPolling
processing item 16f10910-40d4-4c9c-a06c-438872d94b26
ReportingServicesService!library!14d4!5/4/2006-04:00:09:: Schedule
446540f1-2ad4-4422-9751-4a98f39d6277 executed at 5/4/2006 4:00:09 AM.
ReportingServicesService!schedule!14d4!5/4/2006-04:00:09:: Creating Time
based subscription notification for subscription:
f804f939-b2ae-48cc-b656-8396e511fbb2
ReportingServicesService!library!14d4!5/4/2006-04:00:09:: Schedule
446540f1-2ad4-4422-9751-4a98f39d6277 execution completed at 5/4/2006 4:00:09
AM.
ReportingServicesService!dbpolling!14d4!5/4/2006-04:00:09:: EventPolling
finished processing item 16f10910-40d4-4c9c-a06c-438872d94b26
ReportingServicesService!dbpolling!1384!05/04/2006-04:00:09::
NotificationPolling processing item e493718d-bcfd-48fb-8420-908baa3f80c4
ReportingServicesService!dbpolling!1460!5/4/2006-04:00:09::
NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!library!1384!05/04/2006-04:00:13:: i INFO: Call to
RenderFirst( '/PSP Reporting/Resource Management/ResM02 - Allocation Report
By Initiative' )
ReportingServicesService!runningjobs!13e0!5/4/2006-04:01:40:: i INFO:
Adding: 1 running jobs to the database
ReportingServicesService!library!15e4!5/4/2006-04:09:40:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!processing!1384!5/4/2006-04:10:22:: e ERROR: There
is no data for the field at position 17.
ReportingServicesService!processing!1384!5/4/2006-04:10:22:: e ERROR: There
is no data for the field at position 18.
ReportingServicesService!processing!1384!5/4/2006-04:10:22:: e ERROR: There
is no data for the field at position 19.
ReportingServicesService!reportrendering!1384!05/04/2006-04:10:52:: e ERROR:
Throwing
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., ;
Info:
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.ArgumentOutOfRangeException: Index was out of range.
Must be non-negative and less than the size of the collection.
Parameter name: index
at System.Collections.ArrayList.get_Item(Int32 index)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.PageTableGrid.get_Item(Int32 row, Int32 col)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderImage(PageTableGrid
pageTableGrid, ReportItemInfo reportItemInfo, PageCell pageCell, Int32 row,
Int32 col, Boolean addHeaderRows)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderGridCell(PageLayout
pageLayout, Int32 row, Int32 col, Hashtable& duplicateItemsTable, Boolean
addHeaderRows)
at
Microsoft.ReportingServices.Rendering.BIFFUtility.WorkSheet.WriteRowBlocksAndCells(ExcelRenderer
excelRenderer, Stream stream, UInt32 indexBeginOffsetPosition, Int32 minCol,
Int32 maxCol)
at
Microsoft.ReportingServices.Rendering.BIFFUtility.BaseWorkSheet.WriteWorkSheet(ExcelRenderer excelRenderer, Stream stream, Int32 offset)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageLayout(PageLayout pageLayout, Int32& currentPageNumber, Stack& stack)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageCollection(PageCollection
pageCollection, Int32& currentPageNumber, Stack& stack, PageLayout&
lastPageLayout)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateWorkSheets()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateMainSheet()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderExcelWorkBook(CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessReport(CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime A_0,
GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
-- End of inner exception stack trace --
ReportingServicesService!library!1384!05/04/2006-04:10:52:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!1384!05/04/2006-04:10:52:: Error
sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.ArgumentOutOfRangeException: Index was out of range.
Must be non-negative and less than the size of the collection.
Parameter name: index
at System.Collections.ArrayList.get_Item(Int32 index)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.PageTableGrid.get_Item(Int32 row, Int32 col)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderImage(PageTableGrid
pageTableGrid, ReportItemInfo reportItemInfo, PageCell pageCell, Int32 row,
Int32 col, Boolean addHeaderRows)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderGridCell(PageLayout
pageLayout, Int32 row, Int32 col, Hashtable& duplicateItemsTable, Boolean
addHeaderRows)
at
Microsoft.ReportingServices.Rendering.BIFFUtility.WorkSheet.WriteRowBlocksAndCells(ExcelRenderer
excelRenderer, Stream stream, UInt32 indexBeginOffsetPosition, Int32 minCol,
Int32 maxCol)
at
Microsoft.ReportingServices.Rendering.BIFFUtility.BaseWorkSheet.WriteWorkSheet(ExcelRenderer excelRenderer, Stream stream, Int32 offset)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageLayout(PageLayout pageLayout, Int32& currentPageNumber, Stack& stack)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageCollection(PageCollection
pageCollection, Int32& currentPageNumber, Stack& stack, PageLayout&
lastPageLayout)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateWorkSheets()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateMainSheet()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderExcelWorkBook(CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessReport(CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime A_0,
GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime A_0,
GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime
executionTimeStamp, GetReportChunk getCompiledDefinitionCallback,
ProcessingContext pc, RenderingContext rc)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext
reportContext, ItemProperties properties, ParameterInfoCollection
effectiveParameters, Guid reportId, ClientRequest session, String
description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection
thisReportDataSources, Boolean cachingRequested, Warning[]& warnings,
ReportSnapshot& resultSnapshotData, DateTime& executionDateTime,
RuntimeDataSourceInfoCollection& alldataSources, UserProfileState&
usedUserProfile)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
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!1384!05/04/2006-04:10:52::
Notification e493718d-bcfd-48fb-8420-908baa3f80c4 completed. Success: False,
Status: Failure sending mail: Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., DeliveryExtension: Report Server Email, Report: ResM02 - Allocation
Report By Initiative, Attempt 0
ReportingServicesService!dbpolling!1384!05/04/2006-04:10:52::
NotificationPolling finished processing item
e493718d-bcfd-48fb-8420-908baa3f80c4200 pages? AFAIK, Excel can only have about 65000 rows maximum. That could
be the cause of the error, if the report have too many rows of data.
"SBishop" <SBishop@.discussions.microsoft.com> wrote in message
news:68982103-D197-48FF-A23F-D6CAA7527758@.microsoft.com...
>I have large report (200 pages, landscape 14x8.5) that will not export to
> Excel.
> Last night we scheduled the report to email us the Excel rendered file.
> The
> subscription page shows the following error.
> Failure sending mail: Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> We ran the report manually today and tried to export through the Report
> Manager and it tries to download a file that is only 1.84K large. When we
> click save we get an error.
> Does anyone have any idea what I could do get this report to export to
> Excel?
> I've inlcuded the trace log below detailing the why the it would not send
> the mail.
> ReportingServicesService!dbpolling!1460!5/4/2006-04:00:09:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!14d4!5/4/2006-04:00:09:: EventPolling
> processing item 16f10910-40d4-4c9c-a06c-438872d94b26
> ReportingServicesService!library!14d4!5/4/2006-04:00:09:: Schedule
> 446540f1-2ad4-4422-9751-4a98f39d6277 executed at 5/4/2006 4:00:09 AM.
> ReportingServicesService!schedule!14d4!5/4/2006-04:00:09:: Creating Time
> based subscription notification for subscription:
> f804f939-b2ae-48cc-b656-8396e511fbb2
> ReportingServicesService!library!14d4!5/4/2006-04:00:09:: Schedule
> 446540f1-2ad4-4422-9751-4a98f39d6277 execution completed at 5/4/2006
> 4:00:09
> AM.
> ReportingServicesService!dbpolling!14d4!5/4/2006-04:00:09:: EventPolling
> finished processing item 16f10910-40d4-4c9c-a06c-438872d94b26
> ReportingServicesService!dbpolling!1384!05/04/2006-04:00:09::
> NotificationPolling processing item e493718d-bcfd-48fb-8420-908baa3f80c4
> ReportingServicesService!dbpolling!1460!5/4/2006-04:00:09::
> NotificationPolling processing 1 more items. 1 Total items in internal
> queue.
> ReportingServicesService!library!1384!05/04/2006-04:00:13:: i INFO: Call
> to
> RenderFirst( '/PSP Reporting/Resource Management/ResM02 - Allocation
> Report
> By Initiative' )
> ReportingServicesService!runningjobs!13e0!5/4/2006-04:01:40:: i INFO:
> Adding: 1 running jobs to the database
> ReportingServicesService!library!15e4!5/4/2006-04:09:40:: i INFO: Cleaned
> 0
> batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!processing!1384!5/4/2006-04:10:22:: e ERROR:
> There
> is no data for the field at position 17.
> ReportingServicesService!processing!1384!5/4/2006-04:10:22:: e ERROR:
> There
> is no data for the field at position 18.
> ReportingServicesService!processing!1384!5/4/2006-04:10:22:: e ERROR:
> There
> is no data for the field at position 19.
> ReportingServicesService!reportrendering!1384!05/04/2006-04:10:52:: e
> ERROR:
> Throwing
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown., ;
> Info:
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. -->
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. --> System.ArgumentOutOfRangeException: Index was out of range.
> Must be non-negative and less than the size of the collection.
> Parameter name: index
> at System.Collections.ArrayList.get_Item(Int32 index)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.PageTableGrid.get_Item(Int32
> row, Int32 col)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderImage(PageTableGrid
> pageTableGrid, ReportItemInfo reportItemInfo, PageCell pageCell, Int32
> row,
> Int32 col, Boolean addHeaderRows)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderGridCell(PageLayout
> pageLayout, Int32 row, Int32 col, Hashtable& duplicateItemsTable, Boolean
> addHeaderRows)
> at
> Microsoft.ReportingServices.Rendering.BIFFUtility.WorkSheet.WriteRowBlocksAndCells(ExcelRenderer
> excelRenderer, Stream stream, UInt32 indexBeginOffsetPosition, Int32
> minCol,
> Int32 maxCol)
> at
> Microsoft.ReportingServices.Rendering.BIFFUtility.BaseWorkSheet.WriteWorkSheet(ExcelRenderer
> excelRenderer, Stream stream, Int32 offset)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageLayout(PageLayout
> pageLayout, Int32& currentPageNumber, Stack& stack)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageCollection(PageCollection
> pageCollection, Int32& currentPageNumber, Stack& stack, PageLayout&
> lastPageLayout)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateWorkSheets()
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateMainSheet()
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderExcelWorkBook(CreateAndRegisterStream
> createAndRegisterStream)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessReport(CreateAndRegisterStream
> createAndRegisterStream)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
> report, NameValueCollection reportServerParameters, NameValueCollection
> deviceInfo, NameValueCollection clientCapabilities,
> EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> CreateAndRegisterStream createAndRegisterStream)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
> report, NameValueCollection reportServerParameters, NameValueCollection
> deviceInfo, NameValueCollection clientCapabilities,
> EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> CreateAndRegisterStream createAndRegisterStream)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
> A_0,
> GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
> CreateReportChunk A_4, Boolean& A_5)
> -- End of inner exception stack trace --
> ReportingServicesService!library!1384!05/04/2006-04:10:52:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server
> system
> properties.
> ReportingServicesService!emailextension!1384!05/04/2006-04:10:52:: Error
> sending email.
> Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. -->
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. -->
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. --> System.ArgumentOutOfRangeException: Index was out of range.
> Must be non-negative and less than the size of the collection.
> Parameter name: index
> at System.Collections.ArrayList.get_Item(Int32 index)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.PageTableGrid.get_Item(Int32
> row, Int32 col)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderImage(PageTableGrid
> pageTableGrid, ReportItemInfo reportItemInfo, PageCell pageCell, Int32
> row,
> Int32 col, Boolean addHeaderRows)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderGridCell(PageLayout
> pageLayout, Int32 row, Int32 col, Hashtable& duplicateItemsTable, Boolean
> addHeaderRows)
> at
> Microsoft.ReportingServices.Rendering.BIFFUtility.WorkSheet.WriteRowBlocksAndCells(ExcelRenderer
> excelRenderer, Stream stream, UInt32 indexBeginOffsetPosition, Int32
> minCol,
> Int32 maxCol)
> at
> Microsoft.ReportingServices.Rendering.BIFFUtility.BaseWorkSheet.WriteWorkSheet(ExcelRenderer
> excelRenderer, Stream stream, Int32 offset)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageLayout(PageLayout
> pageLayout, Int32& currentPageNumber, Stack& stack)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageCollection(PageCollection
> pageCollection, Int32& currentPageNumber, Stack& stack, PageLayout&
> lastPageLayout)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateWorkSheets()
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateMainSheet()
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderExcelWorkBook(CreateAndRegisterStream
> createAndRegisterStream)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessReport(CreateAndRegisterStream
> createAndRegisterStream)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
> report, NameValueCollection reportServerParameters, NameValueCollection
> deviceInfo, NameValueCollection clientCapabilities,
> EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> CreateAndRegisterStream createAndRegisterStream)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
> report, NameValueCollection reportServerParameters, NameValueCollection
> deviceInfo, NameValueCollection clientCapabilities,
> EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> CreateAndRegisterStream createAndRegisterStream)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
> A_0,
> GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
> CreateReportChunk A_4, Boolean& A_5)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
> A_0,
> GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
> CreateReportChunk A_4, Boolean& A_5)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime
> executionTimeStamp, GetReportChunk getCompiledDefinitionCallback,
> ProcessingContext pc, RenderingContext rc)
> at
> Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext
> reportContext, ItemProperties properties, ParameterInfoCollection
> effectiveParameters, Guid reportId, ClientRequest session, String
> description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection
> thisReportDataSources, Boolean cachingRequested, Warning[]& warnings,
> ReportSnapshot& resultSnapshotData, DateTime& executionDateTime,
> RuntimeDataSourceInfoCollection& alldataSources, UserProfileState&
> usedUserProfile)
> at
> Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters)
> at
> Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters, String[]&
> secondaryStreamNames)
> at
> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
> at
> Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> at
> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
> rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
> type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
> String[]& secondaryStreamNames)
> at Microsoft.ReportingServices.Library.ReportImpl.Render(String
> renderFormat, String deviceInfo)
> 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!1384!05/04/2006-04:10:52::
> Notification e493718d-bcfd-48fb-8420-908baa3f80c4 completed. Success:
> False,
> Status: Failure sending mail: Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown., DeliveryExtension: Report Server Email, Report: ResM02 -
> Allocation
> Report By Initiative, Attempt 0
> ReportingServicesService!dbpolling!1384!05/04/2006-04:10:52::
> NotificationPolling finished processing item
> e493718d-bcfd-48fb-8420-908baa3f80c4
>

rs.exe and SMTP

Hi

I'm trying to send email from my rss script. It seems that the script cannot create an SmtpClient instance because of SmtpPermission problems, but I just can't find where I need to enable the SmtpPermission. I've tried many things, including web.config and rssrvpolicy.config.

Here's a code sample:

Public Sub Main

Dim smtpClient As New System.Net.Mail.SmtpClient

End Sub

and here's the output when I execute the above script under rs.exe against my local report server

Unhandled exception:
Request for the permission of type 'System.Net.Mail.SmtpPermission, System, Version=2.0.0.0, Culture=neutral,PublicKeyToken=b77a5c561934e089' failed.

Any ideas?

Many thanks

Tony

i have the same problem but with a console application....

RS Subscriptions not running

Hi, I'm having some problems with email subscriptions.
I've set up the subscription and schedule time but the schedule just doesn't
seem to run. It's reporting no errors, there's nothing in the log and the
subscription just looks like a new subscription that's never run.
Can anyone out there help, it would be appreaciated.
Many thanksCan you check to see if the corresponding SQL Agent job is firing and if
there are any issues? Also make sure that the ReportServer service is
running.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sandra" <Sandra@.discussions.microsoft.com> wrote in message
news:7D7C4C13-C9B6-4B15-9D6C-00DE601D15D9@.microsoft.com...
> Hi, I'm having some problems with email subscriptions.
> I've set up the subscription and schedule time but the schedule just
> doesn't
> seem to run. It's reporting no errors, there's nothing in the log and the
> subscription just looks like a new subscription that's never run.
> Can anyone out there help, it would be appreaciated.
> Many thanks|||I've checked the job and it is running correctly, the job is being inserted
into the Event table but it just doesn't move from there.|||You should check to see if the reportserver windows service is running. If
it is, check in the ReportServerService_<timestamp>.log file to see if there
are any errors indicating why the events are not being processed.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sandra" <Sandra@.discussions.microsoft.com> wrote in message
news:EF8BDA76-B94E-493C-9FD7-378A6B3F4D24@.microsoft.com...
> I've checked the job and it is running correctly, the job is being
> inserted
> into the Event table but it just doesn't move from there.|||Sandra,
Did you ever find a solution? We're having the same issue.
"Daniel Reib [MSFT]" wrote:
> You should check to see if the reportserver windows service is running. If
> it is, check in the ReportServerService_<timestamp>.log file to see if there
> are any errors indicating why the events are not being processed.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Sandra" <Sandra@.discussions.microsoft.com> wrote in message
> news:EF8BDA76-B94E-493C-9FD7-378A6B3F4D24@.microsoft.com...
> > I've checked the job and it is running correctly, the job is being
> > inserted
> > into the Event table but it just doesn't move from there.
>
>|||The problem was in the implementation. We just used the wrong timezone for
the execution date. Therefore the schedule was always created one hour before
the intended time. After changing the timezone in the code it worked!
"daw" wrote:
> Sandra,
> Did you ever find a solution? We're having the same issue.
> "Daniel Reib [MSFT]" wrote:
> > You should check to see if the reportserver windows service is running. If
> > it is, check in the ReportServerService_<timestamp>.log file to see if there
> > are any errors indicating why the events are not being processed.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "Sandra" <Sandra@.discussions.microsoft.com> wrote in message
> > news:EF8BDA76-B94E-493C-9FD7-378A6B3F4D24@.microsoft.com...
> > > I've checked the job and it is running correctly, the job is being
> > > inserted
> > > into the Event table but it just doesn't move from there.
> >
> >
> >|||We have the same problem, but not related to time zone settings.
Before the subscriptions are running several month without problem.
SQL Agent is started, smtp server available. I can start the jobs direct in
SQL Agent jobs. The job is marked as successfull. No log entries where ever
possible. RS just don't start to create the report and send it. On the test
server it still works, everything is exact the same on the testsystem.
Before this occured the database log file was full. And we thought that
couses the problem. After fix this, the beheavoiour is still the same.
Has anybody a clues!
"Sandra Geisler" wrote:
> The problem was in the implementation. We just used the wrong timezone for
> the execution date. Therefore the schedule was always created one hour before
> the intended time. After changing the timezone in the code it worked!
> "daw" wrote:
> > Sandra,
> > Did you ever find a solution? We're having the same issue.
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> > > You should check to see if the reportserver windows service is running. If
> > > it is, check in the ReportServerService_<timestamp>.log file to see if there
> > > are any errors indicating why the events are not being processed.
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no rights.
> > >
> > >
> > > "Sandra" <Sandra@.discussions.microsoft.com> wrote in message
> > > news:EF8BDA76-B94E-493C-9FD7-378A6B3F4D24@.microsoft.com...
> > > > I've checked the job and it is running correctly, the job is being
> > > > inserted
> > > > into the Event table but it just doesn't move from there.
> > >
> > >
> > >|||Hello,
did I understand correctly, that the email subscription has the correct
start date and time, but does not start though?
"Dev Main" <DevMain@.discussions.microsoft.com> schrieb im Newsbeitrag
news:2892A909-D1A8-4FE4-B572-49B2FD36E457@.microsoft.com...
> We have the same problem, but not related to time zone settings.
> Before the subscriptions are running several month without problem.
> SQL Agent is started, smtp server available. I can start the jobs direct
> in
> SQL Agent jobs. The job is marked as successfull. No log entries where
> ever
> possible. RS just don't start to create the report and send it. On the
> test
> server it still works, everything is exact the same on the testsystem.
> Before this occured the database log file was full. And we thought that
> couses the problem. After fix this, the beheavoiour is still the same.
> Has anybody a clues!
> "Sandra Geisler" wrote:
>> The problem was in the implementation. We just used the wrong timezone
>> for
>> the execution date. Therefore the schedule was always created one hour
>> before
>> the intended time. After changing the timezone in the code it worked!
>> "daw" wrote:
>> > Sandra,
>> > Did you ever find a solution? We're having the same issue.
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> > > You should check to see if the reportserver windows service is
>> > > running. If
>> > > it is, check in the ReportServerService_<timestamp>.log file to see
>> > > if there
>> > > are any errors indicating why the events are not being processed.
>> > >
>> > > --
>> > > -Daniel
>> > > This posting is provided "AS IS" with no warranties, and confers no
>> > > rights.
>> > >
>> > >
>> > > "Sandra" <Sandra@.discussions.microsoft.com> wrote in message
>> > > news:EF8BDA76-B94E-493C-9FD7-378A6B3F4D24@.microsoft.com...
>> > > > I've checked the job and it is running correctly, the job is being
>> > > > inserted
>> > > > into the Event table but it just doesn't move from there.
>> > >
>> > >
>> > >|||Yes! Date and time are absolut correct. I veryfied this after reading your
post.
There are no log entries. Not in Event Viewer, not in log files from
reporting services.
"Sandra Geisler" wrote:
> Hello,
> did I understand correctly, that the email subscription has the correct
> start date and time, but does not start though?
>
> "Dev Main" <DevMain@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:2892A909-D1A8-4FE4-B572-49B2FD36E457@.microsoft.com...
> > We have the same problem, but not related to time zone settings.
> >
> > Before the subscriptions are running several month without problem.
> >
> > SQL Agent is started, smtp server available. I can start the jobs direct
> > in
> > SQL Agent jobs. The job is marked as successfull. No log entries where
> > ever
> > possible. RS just don't start to create the report and send it. On the
> > test
> > server it still works, everything is exact the same on the testsystem.
> >
> > Before this occured the database log file was full. And we thought that
> > couses the problem. After fix this, the beheavoiour is still the same.
> >
> > Has anybody a clues!
> >
> > "Sandra Geisler" wrote:
> >
> >> The problem was in the implementation. We just used the wrong timezone
> >> for
> >> the execution date. Therefore the schedule was always created one hour
> >> before
> >> the intended time. After changing the timezone in the code it worked!
> >>
> >> "daw" wrote:
> >>
> >> > Sandra,
> >> > Did you ever find a solution? We're having the same issue.
> >> >
> >> > "Daniel Reib [MSFT]" wrote:
> >> >
> >> > > You should check to see if the reportserver windows service is
> >> > > running. If
> >> > > it is, check in the ReportServerService_<timestamp>.log file to see
> >> > > if there
> >> > > are any errors indicating why the events are not being processed.
> >> > >
> >> > > --
> >> > > -Daniel
> >> > > This posting is provided "AS IS" with no warranties, and confers no
> >> > > rights.
> >> > >
> >> > >
> >> > > "Sandra" <Sandra@.discussions.microsoft.com> wrote in message
> >> > > news:EF8BDA76-B94E-493C-9FD7-378A6B3F4D24@.microsoft.com...
> >> > > > I've checked the job and it is running correctly, the job is being
> >> > > > inserted
> >> > > > into the Event table but it just doesn't move from there.
> >> > >
> >> > >
> >> > >
>
>