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