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

Email subscription Reported as Successful but not arriving in recipients inbox.

I have a report that is sent via email to a list of recipients. When I look at the subscription in 'My Subscriptions' the value in the Status column states that the message was 'sent successfully', however the email does not appear in the inboxes of any of the intended recipents. The report renders OK via the browser and only takes a few seconds to process. The subscription exports the report as an Excel file. The excel file is approx 8MB in size but this is still below the attachment size limit for internal emails within my organisation. The subscription is tied to a shared schedule. Other reports that are tied to the shared schedule are shown as successful in 'My Subscriptions' and also appear in the inboxes of recipients. All email address are correct.

I forgot to mention, the report was successfully received by all recipients until very recently and the report has not been modified since this time.

Has anyone come across this problem before.

Thanks

Mike

The Reporting Services e-mail delivery extension considers "sent successfully" to be "I handed it off to some SMTP forwarder". What happens to the e-mail after that is outside the scope of RS. You need to investigate within the e-mail system.

As a diagnostic, you might try delivering to an SMTP pickup folder temporarily to convince yourself that the Report Server is generating the e-mails. Find the rsReportServer.config file, change the "SendUsing" element to 1, specify some SMTPServerPickupDirectory, and try the delivery. If you get .EML files created in the specified folder, RS has done it's part of the delivery. Make sure you set SendUsing back to 2 or <blank> after you've done your test.

Here's a sample of the config file section you need to modify:

<RSEmailDPConfiguration>
<SMTPServer></SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory>D:\Email</SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing>1</SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>_awtest@.Microsoft.Com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
<RenderingExtension>RGDI</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>

Email ID Validation in SQL Query

Hi,
Can someone help me with a query to validate if a value stored in the
emailaddress field in a table is a valid email id or no. Please mail me
ASAP. Thanks in advance.
Regards
DineshDinesh
I'm not sure iunderstood your question.
Since you have not provided a table structure along with sample data , I
guess you can do something like that
IF EXISTS (SELECT * FROM Table WHERE email_id=@.par)
--do soemthing
ELSE
--do somethimg else
"Dinesh" <Dinesh@.discussions.microsoft.com> wrote in message
news:80CE816E-A91C-4ECE-93E4-19006167B567@.microsoft.com...
> Hi,
> Can someone help me with a query to validate if a value stored in the
> emailaddress field in a table is a valid email id or no. Please mail me
> ASAP. Thanks in advance.
> Regards
> Dinesh|||Dinesh skrev:

> Hi,
> Can someone help me with a query to validate if a value stored in the
> emailaddress field in a table is a valid email id or no. Please mail me
> ASAP. Thanks in advance.
> Regards
> Dinesh
Depends on what you actually want to validate...
Is it only that the value looks like 'somename@.someaddress', or is it
to check if there really IS such an (active?) email account, or is it
to check against a table with valid email addresses? Or something else?
/impslayer, aka Birger Johansson|||Please explain in detail, your question? Mean provide sample data situation
Thanks,
Siva
"impslayer" wrote:

> Dinesh skrev:
>
> Depends on what you actually want to validate...
> Is it only that the value looks like 'somename@.someaddress', or is it
> to check if there really IS such an (active?) email account, or is it
> to check against a table with valid email addresses? Or something else?
> /impslayer, aka Birger Johansson
>

EM and QA displays different format for a date field

Hi,
I have a datetime field with a value '1/1/02'. EM display it as 1/1/02 But
Query Analyzer displays it as 2002-01-01 00:00:00.000 (I used SELECT * FROM
Table1)
So in Query Analyzer, I can't tell the fomat of it. I just wonder if your
PC does the same.
Thanks.You have a problem under standing of what a data value is and how it is
stored. It is actually just stored as numeric value, denoting offsets from
some time in the reasonably distant past. Format is based on the user. QA
uses a standard value, mostly because when you are using QA the goal is
usually to see ALL of the data.
Enterprise manager is probably using your system settings. When you
actually use the data, you can format it as you wish.
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Chrissi" <anubisofthydeath@.hotmail.com> wrote in message
news:OqYzX0yUFHA.2136@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I have a datetime field with a value '1/1/02'. EM display it as 1/1/02
> But Query Analyzer displays it as 2002-01-01 00:00:00.000 (I used SELECT *
> FROM Table1)
> So in Query Analyzer, I can't tell the fomat of it. I just wonder if your
> PC does the same.
> Thanks.
>|||Chrissi,
Different clients display things differently, with the possible
excepting of strings made up of printable ASCII with codes
from 32 to 127.
If you want the datetime displayed in a particular format, I'd
suggest you select CONVERT(varchar(40),yourDatetimeColumn,X
XXX),
where XXXX is the appropriate SQL Server format code (see the
Books Online article CAST and CONVERT).
If you do this, you won't be able to "edit" the datetime values
in Enterprise Manager, but that's not a good idea anyway. Better
to make changes programmatically with UPDATE or INSERT
statements.
Steve Kass
Drew University
Chrissi wrote:

>Hi,
>I have a datetime field with a value '1/1/02'. EM display it as 1/1/02 Bu
t
>Query Analyzer displays it as 2002-01-01 00:00:00.000 (I used SELECT * FROM
>Table1)
>So in Query Analyzer, I can't tell the fomat of it. I just wonder if your
>PC does the same.
>Thanks.
>
>

Eleminate trailing zeros in the numeric field

Hello,
I have a numeric field with 4 decimal places.
In the select query i want to eliminate trailing zeros.
DB Value Result
1.1234 1.1234
1.1230 1.123
1.1200 1.12
1.1000 1.1
1.0000 1
Thanks in advance.
M. SubbaiahWhat you want to do is formatting a string. In order to do that you need to
CAST the value to a character data type. Do you really want to do that?
Anyway, here's a nice article on casting and converting data in SQL:
http://msdn.microsoft.com/library/d...br />
2f3o.asp
Look at the style parameter.
ML
http://milambda.blogspot.com/