Emailing and Report Services

I've installed report services and configured the email service by entering a
<smtpserver>192.168.1.100</smtpserver> value and a <from>from@.test.com</from>
value. Then a subscription was made, however no email was sent. I'm using
Windows 2003 a
What kinds of troubleshooting can be done to fix this problem?
Thanks,
JimAdditional Information:
SP1 is installed and the email extension has been configured.
ReportServerService_01_11_2005_15_42_05.log is as shown below. No errors
seen:
<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__01_11_2005_15_42_05.log</Path>
<SystemName>MINDSET</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing ConnectionType to '1' as specified in Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing IsSchedulingService to 'True' as specified in Configuration
file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing IsNotificationService to 'True' as specified in Configuration
file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing PollingInterval to '10' second(s) as specified in Configuration
file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing RecycleTime to '720' minute(s) as specified in Configuration
file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing MaximumMemoryLimit to '80' percent as specified in Configuration
file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing DatabaseQueryTimeout to '120' second(s) as specified in
Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing RunningRequestsDbCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing RunningRequestsAge to '30' second(s) as specified in
Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing CleanupCycleMinutes to '10' minute(s) as specified in
Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing WebServiceUseFileShareStorage to default value of 'False'
because it was not specified in Configuration file.
ReportingServicesService!resourceutilities!1250!1/11/2005-15:42:05:: i INFO:
Running on 2 physical processors, 4 logical processors
ReportingServicesService!resourceutilities!1250!1/11/2005-15:42:05:: i INFO:
Reporting Services starting SKU: Developer
ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
Running Requests Scavenger timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
Running Requests DB timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
Execution Log Entry Expiration timer enabled: Cycle: 37074 seconds
ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
Memory stats update timer enabled: Cycle: 60 seconds
ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO:
Initializing crypto as user: winhealth\Administrator
ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Exporting
public key
ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Performing
sku validation
ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Importing
existing encryption key
ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06:: EventPolling
polling service started
ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06::
NotificationPolling polling service started
ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06:: SchedulePolling
polling service started
ReportingServicesService!dbpolling!12d8!1/11/2005-15:42:06:: EventPolling
heartbeat thread started.
ReportingServicesService!dbpolling!15c0!1/11/2005-15:42:06::
NotificationPolling heartbeat thread started.
ReportingServicesService!dbpolling!6f8!1/11/2005-15:42:06:: Polling started
ReportingServicesService!library!1250!1/11/2005-15:52:05:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
"Jim" wrote:
> I've installed report services and configured the email service by entering a
> <smtpserver>192.168.1.100</smtpserver> value and a <from>from@.test.com</from>
> value. Then a subscription was made, however no email was sent. I'm using
> Windows 2003 a
> What kinds of troubleshooting can be done to fix this problem?
> Thanks,
> Jim
"Jim" wrote:
> I've installed report services and configured the email service by entering a
> <smtpserver>192.168.1.100</smtpserver> value and a <from>from@.test.com</from>
> value. Then a subscription was made, however no email was sent. I'm using
> Windows 2003 a
> What kinds of troubleshooting can be done to fix this problem?
> Thanks,
> Jim|||Error found in ReportServerWebApp:
w3wp!library!fc4!1/11/2005-15:46:38:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files --> System.Xml.XmlException: There are multiple root elements.
Line 1, position 111.
at System.Xml.XmlTextReader.ParseRoot()
at System.Xml.XmlTextReader.Read()
at System.Xml.XmlValidatingReader.ReadNoCollectTextToken()
at System.Xml.XmlValidatingReader.Read()
at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean
preserveWhitespace)
at System.Xml.XmlDocument.Load(XmlReader reader)
at System.Xml.XmlDocument.LoadXml(String xml)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl.SetConfiguration(String configInfo)
-- End of inner exception stack trace --
w3wp!extensionfactory!fc4!1/11/2005-15:46:42:: e ERROR: Exception caught
instantiating report server extension:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files --> System.Xml.XmlException: There are multiple root elements.
Line 1, position 111.
at System.Xml.XmlTextReader.ParseRoot()
at System.Xml.XmlTextReader.Read()
at System.Xml.XmlValidatingReader.ReadNoCollectTextToken()
at System.Xml.XmlValidatingReader.Read()
at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean
preserveWhitespace)
at System.Xml.XmlDocument.Load(XmlReader reader)
at System.Xml.XmlDocument.LoadXml(String xml)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl.SetConfiguration(String configInfo)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl.SetConfiguration(String configInfo)
at
Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.GetNewExtensionInstance(String extensionName, String extensionType).
w3wp!ui!fc4!1/11/2005-15:46:42:: e ERROR: Object reference not set to an
instance of an object.
w3wp!ui!fc4!1/11/2005-15:46:42:: e ERROR: HTTP status code --> 500
"Jim" wrote:
> Additional Information:
> SP1 is installed and the email extension has been configured.
> ReportServerService_01_11_2005_15_42_05.log is as shown below. No errors
> seen:
> <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__01_11_2005_15_42_05.log</Path>
> <SystemName>MINDSET</SystemName>
> <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> <OSVersion>5.2.3790.0</OSVersion>
> </Header>
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing ConnectionType to '1' as specified in Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing IsSchedulingService to 'True' as specified in Configuration
> file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing IsNotificationService to 'True' as specified in Configuration
> file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing IsEventService to 'True' as specified in Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing PollingInterval to '10' second(s) as specified in Configuration
> file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing MemoryLimit to '60' percent as specified in Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing RecycleTime to '720' minute(s) as specified in Configuration
> file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing MaximumMemoryLimit to '80' percent as specified in Configuration
> file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
> file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
> Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
> file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing DatabaseQueryTimeout to '120' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
> file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing RunningRequestsDbCycle to '60' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing RunningRequestsAge to '30' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing CleanupCycleMinutes to '10' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing SecureConnectionLevel to '0' as specified in Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing DisplayErrorLink to 'True' as specified in Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing WebServiceUseFileShareStorage to default value of 'False'
> because it was not specified in Configuration file.
> ReportingServicesService!resourceutilities!1250!1/11/2005-15:42:05:: i INFO:
> Running on 2 physical processors, 4 logical processors
> ReportingServicesService!resourceutilities!1250!1/11/2005-15:42:05:: i INFO:
> Reporting Services starting SKU: Developer
> ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
> ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> Running Requests Scavenger timer enabled: Cycle: 60 seconds
> ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> Running Requests DB timer enabled: Cycle: 60 seconds
> ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> Execution Log Entry Expiration timer enabled: Cycle: 37074 seconds
> ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> Memory stats update timer enabled: Cycle: 60 seconds
> ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO:
> Initializing crypto as user: winhealth\Administrator
> ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Exporting
> public key
> ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Performing
> sku validation
> ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Importing
> existing encryption key
> ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06:: EventPolling
> polling service started
> ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06::
> NotificationPolling polling service started
> ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06:: SchedulePolling
> polling service started
> ReportingServicesService!dbpolling!12d8!1/11/2005-15:42:06:: EventPolling
> heartbeat thread started.
> ReportingServicesService!dbpolling!15c0!1/11/2005-15:42:06::
> NotificationPolling heartbeat thread started.
> ReportingServicesService!dbpolling!6f8!1/11/2005-15:42:06:: Polling started
> ReportingServicesService!library!1250!1/11/2005-15:52:05:: i INFO: Cleaned 0
> batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> "Jim" wrote:
> > I've installed report services and configured the email service by entering a
> > <smtpserver>192.168.1.100</smtpserver> value and a <from>from@.test.com</from>
> > value. Then a subscription was made, however no email was sent. I'm using
> > Windows 2003 a
> >
> > What kinds of troubleshooting can be done to fix this problem?
> >
> > Thanks,
> > Jim
> "Jim" wrote:
> > I've installed report services and configured the email service by entering a
> > <smtpserver>192.168.1.100</smtpserver> value and a <from>from@.test.com</from>
> > value. Then a subscription was made, however no email was sent. I'm using
> > Windows 2003 a
> >
> > What kinds of troubleshooting can be done to fix this problem?
> >
> > Thanks,
> > Jim|||RSReportServer.config
<Configuration
<Dsn>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAnJp1x4j7cEGBDP0ctf5/AQQAAAAiAAAAUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAHb4gJw7ytct/ngXumtCq1cAAAAA
BIAAAKAAAAAQAAAAuU177KbSl3yj06++1ndRxiABAADJ4zNwz9gEYLzmptYuirj70DzoEXokoZbC
myrFj9XESEy4CNvxshVF4b5Dy0kWc/RwSodif+RIZ5XihCPy7TUhKREPn3HMOL0a+07XukXQGvDt
hdrunLeEwMF6+xoKIcSfulfuFuaLbnVvbTb3M3i8OV3FggECBA/Z18KFfMNVSyVxN61HMlqDC9EJ
pMSJ/l5eXiqxA1f4y8jbbo4isCClOjDu1dHoN/ZfmgnyFVzHU/LGwjP4eNy15YcRrALuPVuDUQ6A
lhlQNSy0l0VMzoHNpSav+Wo7TZBvJ8fnh9/xUOcw04t64YS3RPiwiNg658GU4JP6E+cHObltTmVd
pDQGl2dFYgyYR8TPq/6zBiYoE26cWc2nZTEccuN4aKXbCTcUAAAAflUIGOptOCGJjLJ3qiRZ1DG+
jaQ=</Dsn>
<ConnectionType>Impersonate</ConnectionType
<LogonUser>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAnJp1x4j7cEGBDP0ctf5/AQQAAAAiAAAAUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAGewGAGsiAwdRIKiQmHB13cAAAAA
BIAAAKAAAAAQAAAA9AntV5LwzNyUpaFnazAlJCAAAABlxhi7DJRmfGDbxkWtxLXvof+zbk0NxOF7
kTDYDd0+QRQAAAB4UYlEm9ffpMuBj8dYIkIaSorj2A==</LogonUser
<LogonDomain>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAnJp1x4j7cEGBDP0ctf5/AQQAAAAiAAAAUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAN36zORf3lIDr88ypo3HOxYAAAAA
BIAAAKAAAAAQAAAAOlPeo81ePGGjrFcdPd6H1BgAAAD+vOIAfw3KfimAHuOzDF/Dlyk+BavrCfcU
AAAAdn2Zn81tgGb+Z7OEUysH/6JBwWY=</LogonDomain
<LogonCred>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAnJp1x4j7cEGBDP0ctf5/AQQAAAAiAAAAUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAB49nHK2Y64P/UUlwTjf1Z4AAAAA
BIAAAKAAAAAQAAAA5gbVWKy0UKm8eJdi2QTEWhgAAACZ41XN1cBha9JipJexVj+0hZ6dBSyqB+wU
AAAAQpp1vLQTYO+MSx6K2zMnAreGVNU=</LogonCred>
<InstanceId>MSSQL.1</InstanceId>
<InstallationID>{130e9fe9-cbe3-4f6b-88ad-10003bc9f414}</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://MINDSET/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>192.168.1.100</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>reportserver@.winhealthpartners.org</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>
"Jim" wrote:
> Error found in ReportServerWebApp:
> w3wp!library!fc4!1/11/2005-15:46:38:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in the
> log files, ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in the
> log files --> System.Xml.XmlException: There are multiple root elements.
> Line 1, position 111.
> at System.Xml.XmlTextReader.ParseRoot()
> at System.Xml.XmlTextReader.Read()
> at System.Xml.XmlValidatingReader.ReadNoCollectTextToken()
> at System.Xml.XmlValidatingReader.Read()
> at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
> at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean
> preserveWhitespace)
> at System.Xml.XmlDocument.Load(XmlReader reader)
> at System.Xml.XmlDocument.LoadXml(String xml)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl.SetConfiguration(String configInfo)
> -- End of inner exception stack trace --
> w3wp!extensionfactory!fc4!1/11/2005-15:46:42:: e ERROR: Exception caught
> instantiating report server extension:
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in the
> log files --> System.Xml.XmlException: There are multiple root elements.
> Line 1, position 111.
> at System.Xml.XmlTextReader.ParseRoot()
> at System.Xml.XmlTextReader.Read()
> at System.Xml.XmlValidatingReader.ReadNoCollectTextToken()
> at System.Xml.XmlValidatingReader.Read()
> at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
> at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean
> preserveWhitespace)
> at System.Xml.XmlDocument.Load(XmlReader reader)
> at System.Xml.XmlDocument.LoadXml(String xml)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl.SetConfiguration(String configInfo)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl.SetConfiguration(String configInfo)
> at
> Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.GetNewExtensionInstance(String extensionName, String extensionType).
> w3wp!ui!fc4!1/11/2005-15:46:42:: e ERROR: Object reference not set to an
> instance of an object.
> w3wp!ui!fc4!1/11/2005-15:46:42:: e ERROR: HTTP status code --> 500
> "Jim" wrote:
> > Additional Information:
> >
> > SP1 is installed and the email extension has been configured.
> >
> > ReportServerService_01_11_2005_15_42_05.log is as shown below. No errors
> > seen:
> >
> > <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__01_11_2005_15_42_05.log</Path>
> > <SystemName>MINDSET</SystemName>
> > <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> > <OSVersion>5.2.3790.0</OSVersion>
> > </Header>
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing ConnectionType to '1' as specified in Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing IsSchedulingService to 'True' as specified in Configuration
> > file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing IsNotificationService to 'True' as specified in Configuration
> > file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing IsEventService to 'True' as specified in Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing PollingInterval to '10' second(s) as specified in Configuration
> > file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing MemoryLimit to '60' percent as specified in Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing RecycleTime to '720' minute(s) as specified in Configuration
> > file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing MaximumMemoryLimit to '80' percent as specified in Configuration
> > file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
> > Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
> > file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
> > Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
> > file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing DatabaseQueryTimeout to '120' second(s) as specified in
> > Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
> > file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
> > Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing RunningRequestsDbCycle to '60' second(s) as specified in
> > Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing RunningRequestsAge to '30' second(s) as specified in
> > Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing CleanupCycleMinutes to '10' minute(s) as specified in
> > Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing SecureConnectionLevel to '0' as specified in Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing DisplayErrorLink to 'True' as specified in Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing WebServiceUseFileShareStorage to default value of 'False'
> > because it was not specified in Configuration file.
> > ReportingServicesService!resourceutilities!1250!1/11/2005-15:42:05:: i INFO:
> > Running on 2 physical processors, 4 logical processors
> > ReportingServicesService!resourceutilities!1250!1/11/2005-15:42:05:: i INFO:
> > Reporting Services starting SKU: Developer
> > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
> > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > Running Requests Scavenger timer enabled: Cycle: 60 seconds
> > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > Running Requests DB timer enabled: Cycle: 60 seconds
> > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > Execution Log Entry Expiration timer enabled: Cycle: 37074 seconds
> > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > Memory stats update timer enabled: Cycle: 60 seconds
> > ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO:
> > Initializing crypto as user: winhealth\Administrator
> > ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Exporting
> > public key
> > ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Performing
> > sku validation
> > ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Importing
> > existing encryption key
> > ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06:: EventPolling
> > polling service started
> > ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06::
> > NotificationPolling polling service started
> > ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06:: SchedulePolling
> > polling service started
> > ReportingServicesService!dbpolling!12d8!1/11/2005-15:42:06:: EventPolling
> > heartbeat thread started.
> > ReportingServicesService!dbpolling!15c0!1/11/2005-15:42:06::
> > NotificationPolling heartbeat thread started.
> > ReportingServicesService!dbpolling!6f8!1/11/2005-15:42:06:: Polling started
> > ReportingServicesService!library!1250!1/11/2005-15:52:05:: i INFO: Cleaned 0
> > batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> > chunks, 0 running jobs
> >
> > "Jim" wrote:
> >
> > > I've installed report services and configured the email service by entering a
> > > <smtpserver>192.168.1.100</smtpserver> value and a <from>from@.test.com</from>
> > > value. Then a subscription was made, however no email was sent. I'm using
> > > Windows 2003 a
> > >
> > > What kinds of troubleshooting can be done to fix this problem?
> > >
> > > Thanks,
> > > Jim
> >
> > "Jim" wrote:
> >
> > > I've installed report services and configured the email service by entering a
> > > <smtpserver>192.168.1.100</smtpserver> value and a <from>from@.test.com</from>
> > > value. Then a subscription was made, however no email was sent. I'm using
> > > Windows 2003 a
> > >
> > > What kinds of troubleshooting can be done to fix this problem?
> > >
> > > Thanks,
> > > Jim|||Reinstalled Report Services and used the built-in account user account for
Report Services. It now works.
"Jim" wrote:
> RSReportServer.config
> <Configuration>
> <Dsn>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAnJp1x4j7cEGBDP0ctf5/AQQAAAAiAAAAUgBlAHAAbwBy
> AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAHb4gJw7ytct/ngXumtCq1cAAAAA
> BIAAAKAAAAAQAAAAuU177KbSl3yj06++1ndRxiABAADJ4zNwz9gEYLzmptYuirj70DzoEXokoZbC
> myrFj9XESEy4CNvxshVF4b5Dy0kWc/RwSodif+RIZ5XihCPy7TUhKREPn3HMOL0a+07XukXQGvDt
> hdrunLeEwMF6+xoKIcSfulfuFuaLbnVvbTb3M3i8OV3FggECBA/Z18KFfMNVSyVxN61HMlqDC9EJ
> pMSJ/l5eXiqxA1f4y8jbbo4isCClOjDu1dHoN/ZfmgnyFVzHU/LGwjP4eNy15YcRrALuPVuDUQ6A
> lhlQNSy0l0VMzoHNpSav+Wo7TZBvJ8fnh9/xUOcw04t64YS3RPiwiNg658GU4JP6E+cHObltTmVd
> pDQGl2dFYgyYR8TPq/6zBiYoE26cWc2nZTEccuN4aKXbCTcUAAAAflUIGOptOCGJjLJ3qiRZ1DG+
> jaQ=</Dsn>
> <ConnectionType>Impersonate</ConnectionType>
> <LogonUser>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAnJp1x4j7cEGBDP0ctf5/AQQAAAAiAAAAUgBlAHAAbwBy
> AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAGewGAGsiAwdRIKiQmHB13cAAAAA
> BIAAAKAAAAAQAAAA9AntV5LwzNyUpaFnazAlJCAAAABlxhi7DJRmfGDbxkWtxLXvof+zbk0NxOF7
> kTDYDd0+QRQAAAB4UYlEm9ffpMuBj8dYIkIaSorj2A==</LogonUser>
> <LogonDomain>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAnJp1x4j7cEGBDP0ctf5/AQQAAAAiAAAAUgBlAHAAbwBy
> AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAN36zORf3lIDr88ypo3HOxYAAAAA
> BIAAAKAAAAAQAAAAOlPeo81ePGGjrFcdPd6H1BgAAAD+vOIAfw3KfimAHuOzDF/Dlyk+BavrCfcU
> AAAAdn2Zn81tgGb+Z7OEUysH/6JBwWY=</LogonDomain>
> <LogonCred>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAnJp1x4j7cEGBDP0ctf5/AQQAAAAiAAAAUgBlAHAAbwBy
> AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAB49nHK2Y64P/UUlwTjf1Z4AAAAA
> BIAAAKAAAAAQAAAA5gbVWKy0UKm8eJdi2QTEWhgAAACZ41XN1cBha9JipJexVj+0hZ6dBSyqB+wU
> AAAAQpp1vLQTYO+MSx6K2zMnAreGVNU=</LogonCred>
> <InstanceId>MSSQL.1</InstanceId>
> <InstallationID>{130e9fe9-cbe3-4f6b-88ad-10003bc9f414}</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://MINDSET/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>192.168.1.100</SMTPServer>
> <SMTPServerPort></SMTPServerPort>
> <SMTPAccountName></SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing></SendUsing>
> <SMTPAuthenticate></SMTPAuthenticate>
> <From>reportserver@.winhealthpartners.org</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>
>
> "Jim" wrote:
> > Error found in ReportServerWebApp:
> >
> > w3wp!library!fc4!1/11/2005-15:46:38:: e ERROR: Throwing
> > Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> > The Report Server has encountered a configuration error; more details in the
> > log files, ;
> > Info:
> > Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> > The Report Server has encountered a configuration error; more details in the
> > log files --> System.Xml.XmlException: There are multiple root elements.
> > Line 1, position 111.
> > at System.Xml.XmlTextReader.ParseRoot()
> > at System.Xml.XmlTextReader.Read()
> > at System.Xml.XmlValidatingReader.ReadNoCollectTextToken()
> > at System.Xml.XmlValidatingReader.Read()
> > at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
> > at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean
> > preserveWhitespace)
> > at System.Xml.XmlDocument.Load(XmlReader reader)
> > at System.Xml.XmlDocument.LoadXml(String xml)
> > at
> > Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl.SetConfiguration(String configInfo)
> > -- End of inner exception stack trace --
> > w3wp!extensionfactory!fc4!1/11/2005-15:46:42:: e ERROR: Exception caught
> > instantiating report server extension:
> > Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> > The Report Server has encountered a configuration error; more details in the
> > log files --> System.Xml.XmlException: There are multiple root elements.
> > Line 1, position 111.
> > at System.Xml.XmlTextReader.ParseRoot()
> > at System.Xml.XmlTextReader.Read()
> > at System.Xml.XmlValidatingReader.ReadNoCollectTextToken()
> > at System.Xml.XmlValidatingReader.Read()
> > at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
> > at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean
> > preserveWhitespace)
> > at System.Xml.XmlDocument.Load(XmlReader reader)
> > at System.Xml.XmlDocument.LoadXml(String xml)
> > at
> > Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl.SetConfiguration(String configInfo)
> > -- End of inner exception stack trace --
> > at
> > Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl.SetConfiguration(String configInfo)
> > at
> > Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.GetNewExtensionInstance(String extensionName, String extensionType).
> > w3wp!ui!fc4!1/11/2005-15:46:42:: e ERROR: Object reference not set to an
> > instance of an object.
> > w3wp!ui!fc4!1/11/2005-15:46:42:: e ERROR: HTTP status code --> 500
> >
> > "Jim" wrote:
> >
> > > Additional Information:
> > >
> > > SP1 is installed and the email extension has been configured.
> > >
> > > ReportServerService_01_11_2005_15_42_05.log is as shown below. No errors
> > > seen:
> > >
> > > <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__01_11_2005_15_42_05.log</Path>
> > > <SystemName>MINDSET</SystemName>
> > > <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> > > <OSVersion>5.2.3790.0</OSVersion>
> > > </Header>
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing ConnectionType to '1' as specified in Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing IsSchedulingService to 'True' as specified in Configuration
> > > file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing IsNotificationService to 'True' as specified in Configuration
> > > file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing IsEventService to 'True' as specified in Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing PollingInterval to '10' second(s) as specified in Configuration
> > > file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing MemoryLimit to '60' percent as specified in Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing RecycleTime to '720' minute(s) as specified in Configuration
> > > file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing MaximumMemoryLimit to '80' percent as specified in Configuration
> > > file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
> > > Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
> > > file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
> > > Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
> > > file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing DatabaseQueryTimeout to '120' second(s) as specified in
> > > Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
> > > file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
> > > Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing RunningRequestsDbCycle to '60' second(s) as specified in
> > > Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing RunningRequestsAge to '30' second(s) as specified in
> > > Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing CleanupCycleMinutes to '10' minute(s) as specified in
> > > Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing SecureConnectionLevel to '0' as specified in Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing DisplayErrorLink to 'True' as specified in Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing WebServiceUseFileShareStorage to default value of 'False'
> > > because it was not specified in Configuration file.
> > > ReportingServicesService!resourceutilities!1250!1/11/2005-15:42:05:: i INFO:
> > > Running on 2 physical processors, 4 logical processors
> > > ReportingServicesService!resourceutilities!1250!1/11/2005-15:42:05:: i INFO:
> > > Reporting Services starting SKU: Developer
> > > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > > Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
> > > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > > Running Requests Scavenger timer enabled: Cycle: 60 seconds
> > > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > > Running Requests DB timer enabled: Cycle: 60 seconds
> > > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > > Execution Log Entry Expiration timer enabled: Cycle: 37074 seconds
> > > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > > Memory stats update timer enabled: Cycle: 60 seconds
> > > ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO:
> > > Initializing crypto as user: winhealth\Administrator
> > > ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Exporting
> > > public key
> > > ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Performing
> > > sku validation
> > > ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Importing
> > > existing encryption key
> > > ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06:: EventPolling
> > > polling service started
> > > ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06::
> > > NotificationPolling polling service started
> > > ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06:: SchedulePolling
> > > polling service started
> > > ReportingServicesService!dbpolling!12d8!1/11/2005-15:42:06:: EventPolling
> > > heartbeat thread started.
> > > ReportingServicesService!dbpolling!15c0!1/11/2005-15:42:06::
> > > NotificationPolling heartbeat thread started.
> > > ReportingServicesService!dbpolling!6f8!1/11/2005-15:42:06:: Polling started
> > > ReportingServicesService!library!1250!1/11/2005-15:52:05:: i INFO: Cleaned 0
> > > batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> > > chunks, 0 running jobs
> > >
> > > "Jim" wrote:
> > >
> > > > I've installed report services and configured the email service by entering a
> > > > <smtpserver>192.168.1.100</smtpserver> value and a <from>from@.test.com</from>
> > > > value. Then a subscription was made, however no email was sent. I'm using
> > > > Windows 2003 a
> > > >
> > > > What kinds of troubleshooting can be done to fix this problem?
> > > >
> > > > Thanks,
> > > > Jim
> > >
> > > "Jim" wrote:
> > >
> > > > I've installed report services and configured the email service by entering a
> > > > <smtpserver>192.168.1.100</smtpserver> value and a <from>from@.test.com</from>
> > > > value. Then a subscription was made, however no email was sent. I'm using
> > > > Windows 2003 a
> > > >
> > > > What kinds of troubleshooting can be done to fix this problem?
> > > >
> > > > Thanks,
> > > > Jim