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

RS Subscription Failures

RS Subscriptions are generating the following errors for some (not all)
subscriptions:
Failure sending mail: The Report Server has encountered a configuration
error; more details in the log files
The only difference I can see between our working subscriptions and the non
working subscriptions are the owners of the subscriptions.
A log file I was able to find with a failed email reference is as follows.
ReportingServicesService!dbpolling!25f4!4/18/2005-02:00:13::
NotificationPolling processing 1 more items. 2 Total items in internal
queue.
ReportingServicesService!library!27e4!04/18/2005-02:00:14:: i INFO: Call to
RenderFirst( '/Production Systems' )
ReportingServicesService!library!27e4!04/18/2005-02:00:15:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 5; possible reason -
service account doesn't have rights to check domain user SIDs.;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
ReportingServicesService!library!27e4!04/18/2005-02:00:15:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!27e4!04/18/2005-02:00:15:: Error
sending email.
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report
Server has encountered a configuration error; more details in the log
files -->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
at
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr
userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
userName)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation
requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID,
Int32& executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
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!27e4!04/18/2005-02:00:15::
Notification 75812118-974c-4618-98b1-5327eb230d09 completed. Success:
False, Status: Failure sending mail: The Report Server has encountered a
configuration error; more details in the log files, DeliveryExtension:
Report Server Email, Report: Production Systems, Attempt 0
ReportingServicesService!dbpolling!27e4!04/18/2005-02:00:15::
NotificationPolling finished processing item
75812118-974c-4618-98b1-5327eb230d09
ReportingServicesService!library!1ef8!04/18/2005-02:00:23:: i INFO:
Initializing SessionTimeout to '600' second(s) as specified in Server system
properties.
ReportingServicesService!library!1ef8!04/18/2005-02:00:23:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!1ef8!04/18/2005-02:00:26:: Email
successfully sent to "someone@.x.com" <someone@.x.com>
ReportingServicesService!notification!1ef8!04/18/2005-02:00:26::
Notification 7f32758e-2511-4a4d-8ac2-f91c31691db7 completed. Success: True,
Status: Mail sent to someone@.x.com, DeliveryExtension: Report Server Email,
Report: Production Systems, Attempt 0
ReportingServicesService!dbpolling!1ef8!04/18/2005-02:00:26::
NotificationPolling finished processing item
7f32758e-2511-4a4d-8ac2-f91c31691db7
Any help would be greatly appreciated. Thanks!
BrentHi Brent,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood your Reporting Services' subscription
is not able to send email as you expected. If I have misunderstood your
concern, please feel free to point it out.
According to the error message, I think there might be something wrong with
your configuration file. Please compare rsreportserver.config file in your
working subscriptions machine and non working subscriptions machine. You
may also post the file here and let's check the parameter
You could refer the MSDN Online or RS BooksOnline for detailed information
Configuring a Report Server for E-Mail Delivery
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm
/arp_configserver_v1_4bzl.asp
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||This is one RS Server. Subscriptions that I subscribe to work perfectly, and
have been working perfectly. Subscriptions that other users subscribe to are
failing on the same server. I've reviewed the BOL, but this appears to be
configured properly. Below is the .config file:
<Configuration>
<Dsn>removed encrypted for this post</Dsn>
<ConnectionType>Default</ConnectionType>
<LogonUser>removed encrypted for this post</LogonUser>
<LogonDomain>removed encrypted for this post</LogonDomain>
<LogonCred>removed encrypted for this post</LogonCred>
<InstanceId>MSSQL.1</InstanceId>
<InstallationID>{6435f6bb-db14-43d3-b565-ccd72a245bd3}</InstallationID>
<Add Key="SecureConnectionLevel" Value="0"/>
<Add Key="InstanceName" Value="MSSQLSERVER"/>
<Add Key="ProcessRecycleOptions" Value="0"/>
<Add Key="CleanupCycleMinutes" Value="10"/>
<Add Key="SQLCommandTimeoutSeconds" Value="60"/>
<Add Key="MaxActiveReqForOneUser" Value="20"/>
<Add Key="DatabaseQueryTimeout" Value="120"/>
<Add Key="RunningRequestsScavengerCycle" Value="60"/>
<Add Key="RunningRequestsDbCycle" Value="60"/>
<Add Key="RunningRequestsAge" Value="30"/>
<Add Key="MaxScheduleWait" Value="5"/>
<Add Key="DisplayErrorLink" Value="true"/>
<Service>
<IsSchedulingService>True</IsSchedulingService>
<IsNotificationService>True</IsNotificationService>
<IsEventService>True</IsEventService>
<PollingInterval>10</PollingInterval>
<MemoryLimit>60</MemoryLimit>
<RecycleTime>720</RecycleTime>
<MaximumMemoryLimit>80</MaximumMemoryLimit>
<MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>
<MaxQueueThreads>0</MaxQueueThreads>
<UrlRoot>http://SDBMSP-CTC01/ReportServer</UrlRoot>
<UnattendedExecutionAccount>
<UserName></UserName>
<Password></Password>
<Domain></Domain>
</UnattendedExecutionAccount>
<PolicyLevel>rssrvpolicy.config</PolicyLevel>
</Service>
<Extensions>
<Delivery>
<Extension Name="Report Server FileShare"
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<FileShareConfiguration>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
</FileShareConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>smarthost.fnfinc.com</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>brent@.nospam.nospam</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
</Delivery>
<Render>
<Extension Name="XML"
Type="Microsoft.ReportingServices.Rendering.XmlDataRenderer.XmlDataReport,Microsoft.ReportingServices.XmlRendering"/>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="false"/>
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
<Extension Name="IMAGE"
Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport,Microsoft.ReportingServices.ImageRendering"/>
<Extension Name="PDF"
Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering"/>
<Extension Name="HTML4.0"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
<Extension Name="HTML3.2"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html32RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
<Extension Name="MHTML"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering"/>
<Extension Name="EXCEL"
Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"/>
<Extension Name="HTMLOWC"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.HtmlOWCRenderingExtension,Microsoft.ReportingServices.HtmlRendering">
<Configuration>
<OWCConfiguration>
<OWCDownloadLocation
language="de">http://office.microsoft.com/germany/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="en">http://office.microsoft.com/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="ja">http://office.microsoft.com/japan/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="zh-chs">http://office.microsoft.com/china/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="zh-cht">http://office.microsoft.com/china/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="es">http://office.microsoft.com/spain/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="ko">http://office.microsoft.com/korea/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="fr">http://office.microsoft.com/france/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="it">http://office.microsoft.com/italy/downloads/2002/owc10.aspx</OWCDownloadLocation>
</OWCConfiguration>
</Configuration>
</Extension>
</Render>
<Data>
<Extension Name="SQL"
Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="OLEDB"
Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="ORACLE"
Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="ODBC"
Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
</Data>
<Security>
<Extension Name="Windows"
Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization,
Microsoft.ReportingServices.Authorization"/>
</Security>
<Authentication>
<Extension Name="Windows"
Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication,
Microsoft.ReportingServices.Authorization"/>
</Authentication>
<EventProcessing>
<Extension Name="SnapShot Extension"
Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary">
<Event>
<Type>ReportHistorySnapshotCreated</Type>
</Event>
</Extension>
<Extension Name="Timed Subscription Extension"
Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary">
<Event>
<Type>TimedSubscription</Type>
</Event>
</Extension>
<Extension Name="Cache Update Extension"
Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary">
<Event>
<Type>SnapshotUpdated</Type>
</Event>
</Extension>
</EventProcessing>
</Extensions>
</Configuration>
"Michael Cheng [MSFT]" wrote:
> Hi Brent,
> Welcome to use MSDN Managed Newsgroup!
> From your descriptions, I understood your Reporting Services' subscription
> is not able to send email as you expected. If I have misunderstood your
> concern, please feel free to point it out.
> According to the error message, I think there might be something wrong with
> your configuration file. Please compare rsreportserver.config file in your
> working subscriptions machine and non working subscriptions machine. You
> may also post the file here and let's check the parameter
> You could refer the MSDN Online or RS BooksOnline for detailed information
> Configuring a Report Server for E-Mail Delivery
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm
> /arp_configserver_v1_4bzl.asp
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi Brent,
Thanks for your prompt update and sorry for my lateness!
I looked into your Reporting Services log and found the following entry
--
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
The Report Server has encountered a configuration error; more details in
the
log files, AuthzInitializeContextFromSid: Win32 error: 5; possible reason -
service account doesn't have rights to check domain user SIDs.;
--
Based on my knowledge, when your Reporting Services is running under
Windows Server 2003 and your Reporting Services and SQL Server are both
running under domain user account, you should apply the hotfix in the
following KB
"The specified domain either does not exist or could not be contacted"
error message in Windows Server 2003
http://support.microsoft.com/kb/834859
You may also apply Windows Server 2003 Service Pack 1, within which, I
believe this hotfix had been included
http://www.microsoft.com/downloads/details.aspx?FamilyID=22cfc239-337c-4d81-
8354-72593b1c1f43&DisplayLang=en
NOTE that it will be a FREE/REFUND case if you only asking for hotfix.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

RS and Subscription Mail Delivery

Hi Guy,
During installation of Reporting Services we didn't completed SMTP info.
Up to now thos info are really important for subsription delivery via mail.
I found an article in Technet describing which parameter configure in
RSWebApplication.config file to activate RS SMTP Service.
The config file is an XML format and i think i wrote it wrong because, even
if i restarted everything i don't have availability of mail delivery in
subscription configuration.
Someone could help me?
Can you show me an example of your config file if you correctly setted SMTP
info during setup?
Thanks in advance for your help.
Ciao
StefanoHere is a working configuration (done after the install but that doesn't
matter). Note that I have the IP address of the server hardcoded. You should
not have to do this, you should be able to use the name. Note that most of
configurations are left blank. The IP address is the IP address of a SMTP
server that we have.
<RSEmailDPConfiguration>
<SMTPServer>123.45.6.78</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>somebody@.bogus.com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
Bruce L-C
"Steph" <steph@.steph.it> wrote in message
news:ewbUSSnaEHA.2812@.TK2MSFTNGP11.phx.gbl...
> Hi Guy,
> During installation of Reporting Services we didn't completed SMTP info.
> Up to now thos info are really important for subsription delivery via
mail.
> I found an article in Technet describing which parameter configure in
> RSWebApplication.config file to activate RS SMTP Service.
> The config file is an XML format and i think i wrote it wrong because,
even
> if i restarted everything i don't have availability of mail delivery in
> subscription configuration.
> Someone could help me?
> Can you show me an example of your config file if you correctly setted
SMTP
> info during setup?
> Thanks in advance for your help.
> Ciao
> Stefano
>|||Thanks Bruce,
But i have an additional request for you.....where i have to place those
line in the file.
My config file is actually done in this way:
<Configuration>
<UI>
<ReportServerUrl>http://SQLLUCEPLAN/ReportServer</ReportServerUrl>
</UI>
<Extensions>
<DeliveryUI>
<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProvide
rControl,ReportingServicesEmailDeliveryProvider">
<DefaultDeliveryExtension>True</DefaultDeliveryExtension>
<Configuration>
<RSEmailDPConfiguration>
<DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server FileShare"
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIContr
ol,ReportingServicesFileShareDeliveryProvider">
<Configuration>
<FileShare>
<DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
</FileShare>
</Configuration>
</Extension>
</DeliveryUI>
</Extensions>
<Add Key="MaxActiveReqForOneUser" Value="20"/>
<Add Key="DisplayErrorLink" Value="true"/>
</Configuration>
Thanks and Ciao
Stefano|||Did you start editing and deleting lines. Yours looks different. For
instance. I have <Delivery> and you have <DeliveryUI>
When I went in and manually modified entries for email I did not have to add
any lines, I just edited lines that were there.
Do you have your original file?
Bruce L-C
"Steph" <steph@.steph.it> wrote in message
news:et1NN7naEHA.1152@.TK2MSFTNGP09.phx.gbl...
> Thanks Bruce,
> But i have an additional request for you.....where i have to place those
> line in the file.
> My config file is actually done in this way:
> <Configuration>
> <UI>
> <ReportServerUrl>http://SQLLUCEPLAN/ReportServer</ReportServerUrl>
> </UI>
> <Extensions>
> <DeliveryUI>
> <Extension Name="Report Server Email"
>
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProvide
> rControl,ReportingServicesEmailDeliveryProvider">
> <DefaultDeliveryExtension>True</DefaultDeliveryExtension>
> <Configuration>
> <RSEmailDPConfiguration>
> <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
> </RSEmailDPConfiguration>
> </Configuration>
> </Extension>
> <Extension Name="Report Server FileShare"
>
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIContr
> ol,ReportingServicesFileShareDeliveryProvider">
> <Configuration>
> <FileShare>
> <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
> </FileShare>
> </Configuration>
> </Extension>
> </DeliveryUI>
> </Extensions>
> <Add Key="MaxActiveReqForOneUser" Value="20"/>
> <Add Key="DisplayErrorLink" Value="true"/>
> </Configuration>
> Thanks and Ciao
> Stefano
>|||Stefano is looking the wrong file. Look in the RSReportServer.config file
for the elements that Bruce was mentioning.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uCTlpxoaEHA.1000@.TK2MSFTNGP12.phx.gbl...
> Did you start editing and deleting lines. Yours looks different. For
> instance. I have <Delivery> and you have <DeliveryUI>
> When I went in and manually modified entries for email I did not have to
add
> any lines, I just edited lines that were there.
> Do you have your original file?
> Bruce L-C
> "Steph" <steph@.steph.it> wrote in message
> news:et1NN7naEHA.1152@.TK2MSFTNGP09.phx.gbl...
> > Thanks Bruce,
> > But i have an additional request for you.....where i have to place
those
> > line in the file.
> > My config file is actually done in this way:
> >
> > <Configuration>
> > <UI>
> > <ReportServerUrl>http://SQLLUCEPLAN/ReportServer</ReportServerUrl>
> > </UI>
> > <Extensions>
> > <DeliveryUI>
> > <Extension Name="Report Server Email"
> >
>
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProvide
> > rControl,ReportingServicesEmailDeliveryProvider">
> > <DefaultDeliveryExtension>True</DefaultDeliveryExtension>
> > <Configuration>
> > <RSEmailDPConfiguration>
> > <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
> > </RSEmailDPConfiguration>
> > </Configuration>
> > </Extension>
> > <Extension Name="Report Server FileShare"
> >
>
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIContr
> > ol,ReportingServicesFileShareDeliveryProvider">
> > <Configuration>
> > <FileShare>
> > <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
> > </FileShare>
> > </Configuration>
> > </Extension>
> > </DeliveryUI>
> > </Extensions>
> > <Add Key="MaxActiveReqForOneUser" Value="20"/>
> > <Add Key="DisplayErrorLink" Value="true"/>
> > </Configuration>
> >
> > Thanks and Ciao
> > Stefano
> >
> >
>|||Ahh. Great. Thanks for jumping in.
Bruce L-C
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:uINrD$oaEHA.752@.TK2MSFTNGP09.phx.gbl...
> Stefano is looking the wrong file. Look in the RSReportServer.config file
> for the elements that Bruce was mentioning.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uCTlpxoaEHA.1000@.TK2MSFTNGP12.phx.gbl...
> > Did you start editing and deleting lines. Yours looks different. For
> > instance. I have <Delivery> and you have <DeliveryUI>
> >
> > When I went in and manually modified entries for email I did not have to
> add
> > any lines, I just edited lines that were there.
> >
> > Do you have your original file?
> >
> > Bruce L-C
> >
> > "Steph" <steph@.steph.it> wrote in message
> > news:et1NN7naEHA.1152@.TK2MSFTNGP09.phx.gbl...
> > > Thanks Bruce,
> > > But i have an additional request for you.....where i have to place
> those
> > > line in the file.
> > > My config file is actually done in this way:
> > >
> > > <Configuration>
> > > <UI>
> > > <ReportServerUrl>http://SQLLUCEPLAN/ReportServer</ReportServerUrl>
> > > </UI>
> > > <Extensions>
> > > <DeliveryUI>
> > > <Extension Name="Report Server Email"
> > >
> >
>
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProvide
> > > rControl,ReportingServicesEmailDeliveryProvider">
> > > <DefaultDeliveryExtension>True</DefaultDeliveryExtension>
> > > <Configuration>
> > > <RSEmailDPConfiguration>
> > > <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
> > > </RSEmailDPConfiguration>
> > > </Configuration>
> > > </Extension>
> > > <Extension Name="Report Server FileShare"
> > >
> >
>
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIContr
> > > ol,ReportingServicesFileShareDeliveryProvider">
> > > <Configuration>
> > > <FileShare>
> > > <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
> > > </FileShare>
> > > </Configuration>
> > > </Extension>
> > > </DeliveryUI>
> > > </Extensions>
> > > <Add Key="MaxActiveReqForOneUser" Value="20"/>
> > > <Add Key="DisplayErrorLink" Value="true"/>
> > > </Configuration>
> > >
> > > Thanks and Ciao
> > > Stefano
> > >
> > >
> >
> >
>|||Thanks for your help.
I've done the settings and everything looks good except when you try to
confirm subscription or change the schedule i get an error telling that the
value for the field StartDateTime is not valid for this field. It's
impposible to convert string value in the requested type.
Can you help me again?
Thanks in advance!
Stefano|||Are you doing this from Report Manager? Or are you controlling the
subscription via web services. My suggestion is to first do it from Report
Manager to make sure everything is setup correctly. If this is via web
services then I can't help you, no experience with them.
Bruce L-C
"Steph" <steph@.steph.it> wrote in message
news:ee$VbtxaEHA.3944@.tk2msftngp13.phx.gbl...
> Thanks for your help.
> I've done the settings and everything looks good except when you try to
> confirm subscription or change the schedule i get an error telling that
the
> value for the field StartDateTime is not valid for this field. It's
> impposible to convert string value in the requested type.
> Can you help me again?
> Thanks in advance!
> Stefano
>|||Hi Bruce,
I don't use web services, i do entirely from report manager.
Ciao
Stefano
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OzfAkrzaEHA.2340@.TK2MSFTNGP09.phx.gbl...
> Are you doing this from Report Manager? Or are you controlling the
> subscription via web services. My suggestion is to first do it from Report
> Manager to make sure everything is setup correctly. If this is via web
> services then I can't help you, no experience with them.
> Bruce L-C
> "Steph" <steph@.steph.it> wrote in message
> news:ee$VbtxaEHA.3944@.tk2msftngp13.phx.gbl...
> > Thanks for your help.
> > I've done the settings and everything looks good except when you try to
> > confirm subscription or change the schedule i get an error telling that
> the
> > value for the field StartDateTime is not valid for this field. It's
> > impposible to convert string value in the requested type.
> > Can you help me again?
> > Thanks in advance!
> > Stefano
> >
> >
>|||OK, I was confused. Have you tested the report standalone. This seems to me
to be a report parameter problem. Is the report parameter of date data type
(instead of string)
Bruce L-C
"Steph" <steph@.steph.it> wrote in message
news:uwIP%23zzaEHA.3716@.TK2MSFTNGP11.phx.gbl...
> Hi Bruce,
> I don't use web services, i do entirely from report manager.
> Ciao
> Stefano
> "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OzfAkrzaEHA.2340@.TK2MSFTNGP09.phx.gbl...
> > Are you doing this from Report Manager? Or are you controlling the
> > subscription via web services. My suggestion is to first do it from
Report
> > Manager to make sure everything is setup correctly. If this is via web
> > services then I can't help you, no experience with them.
> >
> > Bruce L-C
> >
> > "Steph" <steph@.steph.it> wrote in message
> > news:ee$VbtxaEHA.3944@.tk2msftngp13.phx.gbl...
> > > Thanks for your help.
> > > I've done the settings and everything looks good except when you try
to
> > > confirm subscription or change the schedule i get an error telling
that
> > the
> > > value for the field StartDateTime is not valid for this field. It's
> > > impposible to convert string value in the requested type.
> > > Can you help me again?
> > > Thanks in advance!
> > > Stefano
> > >
> > >
> >
> >
>|||It doesn't have any parameter......and it works perfectly!
If can help in your problem solving, before inserting the line to activate
e-mail delivey, cliccking on scheduling to have a schedule for save the
report on disk, scheduling was working perfectly!
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23EFuri0aEHA.1644@.tk2msftngp13.phx.gbl...
> OK, I was confused. Have you tested the report standalone. This seems to
me
> to be a report parameter problem. Is the report parameter of date data
type
> (instead of string)
> Bruce L-C
> "Steph" <steph@.steph.it> wrote in message
> news:uwIP%23zzaEHA.3716@.TK2MSFTNGP11.phx.gbl...
> > Hi Bruce,
> > I don't use web services, i do entirely from report manager.
> > Ciao
> > Stefano
> >
> > "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > news:OzfAkrzaEHA.2340@.TK2MSFTNGP09.phx.gbl...
> > > Are you doing this from Report Manager? Or are you controlling the
> > > subscription via web services. My suggestion is to first do it from
> Report
> > > Manager to make sure everything is setup correctly. If this is via web
> > > services then I can't help you, no experience with them.
> > >
> > > Bruce L-C
> > >
> > > "Steph" <steph@.steph.it> wrote in message
> > > news:ee$VbtxaEHA.3944@.tk2msftngp13.phx.gbl...
> > > > Thanks for your help.
> > > > I've done the settings and everything looks good except when you try
> to
> > > > confirm subscription or change the schedule i get an error telling
> that
> > > the
> > > > value for the field StartDateTime is not valid for this field. It's
> > > > impposible to convert string value in the requested type.
> > > > Can you help me again?
> > > > Thanks in advance!
> > > > Stefano
> > > >
> > > >
> > >
> > >
> >
> >
>