emailed subscription not including port number in servername URL link for report

I hope someone can help as I have searched for a solution but been unable to find one as yet.

My problem is that after installing SharePoint V3.0 and amending the Report Server to <ServerName>:8080, as I don't yet wish to use integrated mode, everything works fine except email delivered subscriptions. The URL in the email body referencing the report only puts in <ServerName> etc. omitting the port number :8080. I have tried to find where this URL link is built-up from but have had no luck in the report manager, report services configuration and the config files, does anyone know where I need to look and if possible what I need to amend to have the link include :8080 after the servername portion of the URL. I can copy the URL and manually insert the port address and it works but this defeats the object of automated subscriptions.

Sorry if this is a dumb question but it is giving me a headache at the moment.

All answers gratefully received,

Andy

You should update the URLRoot element in the rsreportserver.config file to include :8080 in it. This should get the URL to work.

-Lukasz

|||

Thanks Lukasz,

I thought I had looked at all the appropriate config files but obviously I missed this one. I found the entry and added the :8080 to the path and it all works fine now.

Much appreciated,

Andy

emailed subscription not including port number in servername URL link for report

I hope someone can help as I have searched for a solution but been unable to find one as yet.

My problem is that after installing SharePoint V3.0 and amending the Report Server to <ServerName>:8080, as I don't yet wish to use integrated mode, everything works fine except email delivered subscriptions. The URL in the email body referencing the report only puts in <ServerName> etc. omitting the port number :8080. I have tried to find where this URL link is built-up from but have had no luck in the report manager, report services configuration and the config files, does anyone know where I need to look and if possible what I need to amend to have the link include :8080 after the servername portion of the URL. I can copy the URL and manually insert the port address and it works but this defeats the object of automated subscriptions.

Sorry if this is a dumb question but it is giving me a headache at the moment.

All answers gratefully received,

Andy

You should update the URLRoot element in the rsreportserver.config file to include :8080 in it. This should get the URL to work.

-Lukasz

|||

Thanks Lukasz,

I thought I had looked at all the appropriate config files but obviously I missed this one. I found the entry and added the :8080 to the path and it all works fine now.

Much appreciated,

Andy

emailed subscription not including port number in servername URL link for report

I hope someone can help as I have searched for a solution but been unable to find one as yet.

My problem is that after installing SharePoint V3.0 and amending the Report Server to <ServerName>:8080, as I don't yet wish to use integrated mode, everything works fine except email delivered subscriptions. The URL in the email body referencing the report only puts in <ServerName> etc. omitting the port number :8080. I have tried to find where this URL link is built-up from but have had no luck in the report manager, report services configuration and the config files, does anyone know where I need to look and if possible what I need to amend to have the link include :8080 after the servername portion of the URL. I can copy the URL and manually insert the port address and it works but this defeats the object of automated subscriptions.

Sorry if this is a dumb question but it is giving me a headache at the moment.

All answers gratefully received,

Andy

You should update the URLRoot element in the rsreportserver.config file to include :8080 in it. This should get the URL to work.

-Lukasz

|||

Thanks Lukasz,

I thought I had looked at all the appropriate config files but obviously I missed this one. I found the entry and added the :8080 to the path and it all works fine now.

Much appreciated,

Andy

Email Subscriptions Issue

Hi,
I've been having an issue getting email subscriptions going. I've followed
the link on Configure a Report Server for E-mail Delivery on msdn2 and it
looks like it creates the report, I'm just getting an odd CAS issue I don't
know how to resolve.
Here is the info from my log
ReportingServicesService!schedule!4!3/21/2006-08:30:01:: Creating Time based
subscription notification for subscription:
c2ab0c2a-b6f1-4778-bd8a-f095d11a04b8
ReportingServicesService!library!4!3/21/2006-08:30:01:: Schedule
b91a6628-784f-4c47-853d-8a589c2a6879 execution completed at 3/21/2006
8:30:01 AM.
ReportingServicesService!dbpolling!4!3/21/2006-08:30:01:: EventPolling
finished processing item 67befaa3-5171-4991-b84e-61c064c1a5ed
ReportingServicesService!dbpolling!c!3/21/2006-08:30:01::
NotificationPolling processing 1 more items. 1 Total items in internal
queue.
ReportingServicesService!dbpolling!d!3/21/2006-08:30:01::
NotificationPolling processing item 3b191c1b-5df5-42ee-9ed1-6437e7c68d90
ReportingServicesService!notification!d!03/21/2006-08:30:01:: e ERROR: Error
occured processing notification. Request for the permission of type
'System.Web.AspNetHostingPermission, System, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
ReportingServicesService!notification!d!03/21/2006-08:30:01:: Notification
3b191c1b-5df5-42ee-9ed1-6437e7c68d90 completed. Success: True, Status:
Request for the permission of type 'System.Web.AspNetHostingPermission,
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'
failed., DeliveryExtension: Report Server Email, Report: SalesOrderSummary,
Attempt 0
ReportingServicesService!dbpolling!d!03/21/2006-08:30:01::
NotificationPolling finished processing item
3b191c1b-5df5-42ee-9ed1-6437e7c68d90
I've searched for the AspNetHostingPermission regards to this, but can't
seem to find it. I set an unattended execution account but no good there.
do I have to give whatever account the ReportingServiceServices is running
as AspNetHostingPermission access? And to what?
Thanks,
ChrisHi Chris,
Welcome to the MSDN newsgroup.
From your description, I understand you're encounering some problem in the
SQL 2005 reporting service when use the email delivery service to send
email notification, correct?
Based on the log entry you provided, the reporting service application is
concerning about the ASPNETHostPermission, this is quite strange and I
seldom see error on this object,(mostly it'll report error regarding on a
certain account or an API call...).
I think we can first try confirming this issue to be a .NET cas specific
one. You can use the "caspol.exe" tool(shiped with .net framework to
configure .NET code access policy setting)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/htm
l/cpconusingcodeaccesssecuritypolicytoolcaspolexe.asp
use the "caspol.exe -s off" to temporarly disable the CAS checking. Test
the SSRS email delivery again under the CAS disabing mode to see whether it
still suffer the issue. If not, we can confirm the problem to be a .net CAS
configration or code evidence specifc issue.
Also, you can try creating another SSRS report and configure it to use
EMAIL delivery to see whethre this is a common problem on that server
machine.
In addition, here are some reference introducing the .NET CAS used in SQL
2005 reporting service:
#Understanding Code Access Security in Reporting Services
http://msdn2.microsoft.com/en-us/library/ms155108.aspx
Please feel free to post here if you've any other finding.
Regards,
Steven Cheng
Microsoft Online Community 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 Steven,
Thanks for the response. So I ran caspol -s off which temporarily disabled
CAS checking. Ran the subscription and no dice. I tried running it as a
file share, same error as before with the ASPNetHostingPermission.
When you talk about creating a report for email delivery, what exactly do
you mean. I'm afraid I'm not sure what to do here.
Thanks!
Chris
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:I9pOSMYTGHA.7884@.TK2MSFTNGXA03.phx.gbl...
> Hi Chris,
> Welcome to the MSDN newsgroup.
> From your description, I understand you're encounering some problem in the
> SQL 2005 reporting service when use the email delivery service to send
> email notification, correct?
> Based on the log entry you provided, the reporting service application is
> concerning about the ASPNETHostPermission, this is quite strange and I
> seldom see error on this object,(mostly it'll report error regarding on a
> certain account or an API call...).
> I think we can first try confirming this issue to be a .NET cas specific
> one. You can use the "caspol.exe" tool(shiped with .net framework to
> configure .NET code access policy setting)
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/htm
> l/cpconusingcodeaccesssecuritypolicytoolcaspolexe.asp
>
> use the "caspol.exe -s off" to temporarly disable the CAS checking. Test
> the SSRS email delivery again under the CAS disabing mode to see whether
> it
> still suffer the issue. If not, we can confirm the problem to be a .net
> CAS
> configration or code evidence specifc issue.
> Also, you can try creating another SSRS report and configure it to use
> EMAIL delivery to see whethre this is a common problem on that server
> machine.
> In addition, here are some reference introducing the .NET CAS used in SQL
> 2005 reporting service:
> #Understanding Code Access Security in Reporting Services
> http://msdn2.microsoft.com/en-us/library/ms155108.aspx
> Please feel free to post here if you've any other finding.
> Regards,
> Steven Cheng
> Microsoft Online Community 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.
>|||Thanks for your response Chris,
So turn off CAS still suffer the problem, it is likely not a typical CAS
configuration issue. The "creating a report for email delivery" I mentioned
means create another report or a new email notification task to see whether
it also suffers the problem.
BTW, does this problem occur the first time on that server and have you
ever successfully used the email notification on that server before?
Regards,
Steven Cheng
Microsoft Online Community 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 Steven,
I tried creating a new report with new email delvery options. Same result.
No, I have never used email delivery on this before, so I've never had a
successful run of it.
What else can I check?
Thanks!
Chris
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:eIzGbZnTGHA.864@.TK2MSFTNGXA03.phx.gbl...
> Thanks for your response Chris,
> So turn off CAS still suffer the problem, it is likely not a typical CAS
> configuration issue. The "creating a report for email delivery" I
> mentioned
> means create another report or a new email notification task to see
> whether
> it also suffers the problem.
> BTW, does this problem occur the first time on that server and have you
> ever successfully used the email notification on that server before?
> Regards,
> Steven Cheng
> Microsoft Online Community 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.
>|||To add to this I'm using Forms Auth. However, running in debug mode and
letting the server execute doesn't ever hit any breakpoints...
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:eIzGbZnTGHA.864@.TK2MSFTNGXA03.phx.gbl...
> Thanks for your response Chris,
> So turn off CAS still suffer the problem, it is likely not a typical CAS
> configuration issue. The "creating a report for email delivery" I
> mentioned
> means create another report or a new email notification task to see
> whether
> it also suffers the problem.
> BTW, does this problem occur the first time on that server and have you
> ever successfully used the email notification on that server before?
> Regards,
> Steven Cheng
> Microsoft Online Community 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.
>|||Thanks for your followup Chris,
Since the email delivery never run on the server, I'm thinking whether
there is something incorrectly about the RS installation. Is it possible
that you try unstalling and reinstalling the RS service?
Regards,
Steven Cheng
Microsoft Online Community 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 Steven,
Thank you for the continued assistance. I've decided to escalate this to an
MSDN support incident since it seems to be much more than meets the eye.
To answer your question though, it's happening on 3 different servers with
RS on it. Each one same issue.
Thank you so much for your continued support though!
-Chris
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:Z6ib5%23lUGHA.4716@.TK2MSFTNGXA01.phx.gbl...
> Thanks for your followup Chris,
> Since the email delivery never run on the server, I'm thinking whether
> there is something incorrectly about the RS installation. Is it possible
> that you try unstalling and reinstalling the RS service?
> Regards,
> Steven Cheng
> Microsoft Online Community 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.
>|||Thanks for your response Chris,
Hope you'll soon get this resolved. And welcome to post the result and
share with us when you got it resolved.
Regards,
Steven Cheng
Microsoft Online Community 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.sql

Email Subscriptions

I have my email set up and it works fine when I email the link, however when
I try to include the report in the email I get the following error message.
Failure sending mail: An internal error occurred on the report server. See
the error log for more details. Is this a set up issue?
Thanks.Not necessarily. Can you post the log file. At least the relevant part.
The log file is called ReportServerService<timestamp>.log
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"nscotia17" <nscotia17@.discussions.microsoft.com> wrote in message
news:81B6C46C-CD66-4721-9BB1-6454D9C4F85D@.microsoft.com...
>I have my email set up and it works fine when I email the link, however
>when
> I try to include the report in the email I get the following error
> message.
> Failure sending mail: An internal error occurred on the report server. See
> the error log for more details. Is this a set up issue?
> Thanks.|||Here is the log file when trying to email an attached report through
subscriptions.
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>Mountain Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__03_07_2005_15_19_09.log</Path>
<SystemName>NAVSUAPP702</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing IsSchedulingService to 'True' as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing IsNotificationService to 'True' as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing PollingInterval to '10' second(s) as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing RecycleTime to '720' minute(s) as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing MaximumMemoryLimit to '80' percent as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing DatabaseQueryTimeout to '120' second(s) as specified in
Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing RunningRequestsDbCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing RunningRequestsAge to '30' second(s) as specified in
Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing CleanupCycleMinutes to '10' minute(s) as specified in
Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing WebServiceUseFileShareStorage to default value of 'False'
because it was not specified in Configuration file.
ReportingServicesService!resourceutilities!1c48!3/7/2005-15:19:10:: i INFO:
Running on 2 physical processors, 4 logical processors
ReportingServicesService!resourceutilities!1c48!3/7/2005-15:19:10:: i INFO:
Reporting Services starting SKU: Developer
ReportingServicesService!runningjobs!1c48!3/7/2005-15:19:10:: i INFO:
Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
ReportingServicesService!runningjobs!1c48!3/7/2005-15:19:10:: i INFO:
Running Requests Scavenger timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!1c48!3/7/2005-15:19:10:: i INFO:
Running Requests DB timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!1c48!3/7/2005-15:19:10:: i INFO:
Execution Log Entry Expiration timer enabled: Cycle: 38449 seconds
ReportingServicesService!runningjobs!1c48!3/7/2005-15:19:10:: i INFO: Memory
stats update timer enabled: Cycle: 60 seconds
ReportingServicesService!crypto!e00!3/7/2005-15:19:10:: i INFO: Initializing
crypto as user: NT AUTHORITY\NETWORK SERVICE
ReportingServicesService!crypto!e00!3/7/2005-15:19:10:: i INFO: Exporting
public key
ReportingServicesService!crypto!e00!3/7/2005-15:19:10:: i INFO: Performing
sku validation
ReportingServicesService!crypto!e00!3/7/2005-15:19:10:: i INFO: Importing
existing encryption key
ReportingServicesService!dbpolling!e00!03/07/2005-15:19:10:: EventPolling
polling service started
ReportingServicesService!dbpolling!e00!03/07/2005-15:19:10::
NotificationPolling polling service started
ReportingServicesService!dbpolling!e00!03/07/2005-15:19:10:: SchedulePolling
polling service started
ReportingServicesService!dbpolling!c20!3/7/2005-15:19:10:: EventPolling
heartbeat thread started.
ReportingServicesService!dbpolling!1e9c!3/7/2005-15:19:10::
NotificationPolling heartbeat thread started.
ReportingServicesService!dbpolling!1fb0!3/7/2005-15:19:10:: Polling started
ReportingServicesService!library!1c48!3/7/2005-15:29:10:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 1
chunks, 0 running jobs
ReportingServicesService!dbpolling!1fb0!3/7/2005-15:30:05:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1c48!3/7/2005-15:30:05:: EventPolling
processing item 9872c0b5-f8dc-4387-97dd-d206e5819124
ReportingServicesService!library!1c48!3/7/2005-15:30:05:: Schedule
dceba956-d832-453e-b603-b735093c283e executed at 3/7/2005 3:30:05 PM.
ReportingServicesService!schedule!1c48!3/7/2005-15:30:05:: Creating Time
based subscription notification for subscription:
5acf26d9-5330-466d-8b5d-32a563bd8c51
ReportingServicesService!library!1c48!3/7/2005-15:30:05:: Schedule
dceba956-d832-453e-b603-b735093c283e execution completed at 3/7/2005 3:30:05
PM.
ReportingServicesService!dbpolling!1c48!3/7/2005-15:30:05:: EventPolling
finished processing item 9872c0b5-f8dc-4387-97dd-d206e5819124
ReportingServicesService!dbpolling!1fb0!3/7/2005-15:30:05::
NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1c48!3/7/2005-15:30:05::
NotificationPolling processing item f391b132-a040-4f87-ab13-f53ffe36096a
ReportingServicesService!library!1c48!03/07/2005-15:30:05:: i INFO:
Initializing EnableIntegratedSecurity to 'True' as specified in Server
system properties.
ReportingServicesService!library!1c48!03/07/2005-15:30:06:: i INFO: Call to
RenderFirst( '/PMAC Test/Net SalesC6' )
ReportingServicesService!library!1c48!03/07/2005-15:30:06:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.InvalidOperationException: The key 'RsDbPassword' does
not exist in the appSettings configuration section.
at System.Configuration.AppSettingsReader.GetValue(String key, Type type)
at Navitaire.dotRez.Reporting.Extensions.Security.Utils.getAppSettings()
at
Navitaire.dotRez.Reporting.Extensions.Security.Utils.GetConfigurationInfo(String settingName)
at
Navitaire.dotRez.Reporting.Extensions.Security.Authorization.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)
-- End of inner exception stack trace --
ReportingServicesService!library!1c48!03/07/2005-15:30:06:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!1c48!03/07/2005-15:30:06:: Error
sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
An internal error occurred on the report server. See the error log for more
details. -->
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.InvalidOperationException: The key 'RsDbPassword' does
not exist in the appSettings configuration section.
at System.Configuration.AppSettingsReader.GetValue(String key, Type type)
at Navitaire.dotRez.Reporting.Extensions.Security.Utils.getAppSettings()
at
Navitaire.dotRez.Reporting.Extensions.Security.Utils.GetConfigurationInfo(String settingName)
at
Navitaire.dotRez.Reporting.Extensions.Security.Authorization.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)
-- End of inner exception stack trace --
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!1c48!03/07/2005-15:30:06::
Notification f391b132-a040-4f87-ab13-f53ffe36096a completed. Success: False,
Status: Failure sending mail: An internal error occurred on the report
server. See the error log for more details., DeliveryExtension: Report Server
Email, Report: Net SalesC6, Attempt 0
ReportingServicesService!dbpolling!1c48!03/07/2005-15:30:06::
NotificationPolling finished processing item
f391b132-a040-4f87-ab13-f53ffe36096a
ReportingServicesService!library!1c48!03/07/2005-15:39:10:: Using folder
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\RSTempFiles
for temporary files.
ReportingServicesService!library!1c48!03/07/2005-15:39:10:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 2 snapshots, 6
chunks, 0 running jobs
Thanks.
"Daniel Reib [MSFT]" wrote:
> Not necessarily. Can you post the log file. At least the relevant part.
> The log file is called ReportServerService<timestamp>.log
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "nscotia17" <nscotia17@.discussions.microsoft.com> wrote in message
> news:81B6C46C-CD66-4721-9BB1-6454D9C4F85D@.microsoft.com...
> >I have my email set up and it works fine when I email the link, however
> >when
> > I try to include the report in the email I get the following error
> > message.
> > Failure sending mail: An internal error occurred on the report server. See
> > the error log for more details. Is this a set up issue?
> > Thanks.
>
>

Email report ONLY if there are records ?

Any idea how to have a Report Subscription only email the report or link if
there are records returned by the reports query or dataset?You would need to do this in a data driven subscription.
Brian Welcker
MSFT
"steve" <steve@.discussions.microsoft.com> wrote in message
news:74944DC2-1C3F-44C0-9E6B-1625D6641E0B@.microsoft.com...
> Any idea how to have a Report Subscription only email the report or link
> if
> there are records returned by the reports query or dataset?
>sql

Email report (or link), only if there are records to be viewed.

Any idea how to have a Report Subscription only email the report or link if
there are records returned by the reports query or dataset?The only way I've seen to do this is with a data driven subscription.
Unfortunately, DDS is not available in non-Enterprise edition
installations. If you can't do DDS, the best you can do is use an
expression like ="No data available to report" in the NoRows property.
The subscription email still goes out but the report contains an
explanatory message instead of a blank page.
HTH
toolman
Corvallis wrote:
> Any idea how to have a Report Subscription only email the report or link if
> there are records returned by the reports query or dataset?|||Hi Corvallis,
Were you able to do this? Have the same need to email the
report ONLY if there are any records. Please let us know.
Best regards,
Steve.
"Corvallis" wrote:
> Any idea how to have a Report Subscription only email the report or link if
> there are records returned by the reports query or dataset?|||Hi Toolman,
Do you have any examples of this
? We need the same logic. Am looking at the step 3 window and the place to
put this in but am not sure.
Thanks, Steve.
"toolman" wrote:
> The only way I've seen to do this is with a data driven subscription.
> Unfortunately, DDS is not available in non-Enterprise edition
> installations. If you can't do DDS, the best you can do is use an
> expression like ="No data available to report" in the NoRows property.
> The subscription email still goes out but the report contains an
> explanatory message instead of a blank page.
> HTH
> toolman
> Corvallis wrote:
> > Any idea how to have a Report Subscription only email the report or link if
> > there are records returned by the reports query or dataset?
>