Tuesday, March 27, 2012
emailsubscription - eventpolling, but no notificationpolling
>From script i'm sending a few emails with pdf attachments.
One report is mailed, two others not. The script for creating the
subscriptions is equal, only different parameters.
When I look in the logfiles I don't see any errors, however only the
succeeded report has both event- and notificationpolling logging.
So the logging for the succeeded one is:
ReportingServicesService!dbpolling!1240!04/30/2005-05:49:52::
EventPolling processing item f21fb887-9e00-40c5-8fac-f246ad14bd4f
ReportingServicesService!dbpolling!194!30.04.2005-05:49:52::
EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!library!1240!04/30/2005-05:49:53:: Schedule
3461442c-d51f-4701-9413-a5bef0d283a0 executed at 04/30/2005 05:49:53.
ReportingServicesService!schedule!1240!04/30/2005-05:49:53:: Creating
Time based subscription notification for subscription:
3424547a-9e5a-4e74-8bd1-78af62a38490
ReportingServicesService!library!1240!04/30/2005-05:49:53:: Schedule
3461442c-d51f-4701-9413-a5bef0d283a0 execution completed at 04/30/2005
05:49:53.
ReportingServicesService!dbpolling!1240!04/30/2005-05:49:53::
EventPolling finished processing item
f21fb887-9e00-40c5-8fac-f246ad14bd4f
ReportingServicesService!dbpolling!194!30.04.2005-05:49:53::
EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1240!04/30/2005-05:49:53::
EventPolling processing item 351c51cd-2274-4218-b92e-f05ebdcc0bcb
ReportingServicesService!dbpolling!1240!04/30/2005-05:49:53::
EventPolling finished processing item
351c51cd-2274-4218-b92e-f05ebdcc0bcb
ReportingServicesService!dbpolling!194!30.04.2005-05:49:54::
NotificationPolling processing 1 more items. 1 Total items in internal
queue.
ReportingServicesService!dbpolling!1240!04/30/2005-05:49:54::
NotificationPolling processing item
72b719c2-1ae2-4e7a-a096-b15364e8ebd4
ReportingServicesService!library!1240!04/30/2005-05:49:55:: i INFO:
Call to RenderFirst( '/KEAS/KEASReports/Analyse' )
ReportingServicesService!library!1240!04/30/2005-05:49:56:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server
system properties.
ReportingServicesService!emailextension!1240!04/30/2005-05:49:57::
Email successfully sent to "spitz@.tiscali.nl" <spitz@.tiscali.nl>
ReportingServicesService!library!1240!04/30/2005-05:49:57:: Data Driven
Notification for activation id eff41ff5-c76d-4ced-be63-377e82daf4bb was
saved.
ReportingServicesService!library!1240!04/30/2005-05:49:57:: Status:
Mail sent to spitz@.tiscali.nl;
ReportingServicesService!notification!1240!04/30/2005-05:49:57::
Notification 72b719c2-1ae2-4e7a-a096-b15364e8ebd4 completed. Success:
True, Status: Mail sent to spitz@.tiscali.nl;, DeliveryExtension: Report
Server Email, Report: Analyse, Attempt 0
ReportingServicesService!dbpolling!1240!04/30/2005-05:49:57::
NotificationPolling finished processing item
72b719c2-1ae2-4e7a-a096-b15364e8ebd4
The logging for the ones that are not mailed (the subscriptions are
created):
ReportingServicesService!dbpolling!194!30.04.2005-05:48:52::
EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1240!04/30/2005-05:48:52::
EventPolling processing item a3d3a5e0-4634-4f32-ab10-8564fa09be40
ReportingServicesService!library!1240!04/30/2005-05:48:52:: Schedule
54043fb7-5eec-4063-ae6e-a0ed054e538c executed at 04/30/2005 05:48:52.
ReportingServicesService!schedule!1240!04/30/2005-05:48:52:: Creating
Time based subscription notification for subscription:
9e5701ab-2fc5-48ab-8290-ae05f55fb29f
ReportingServicesService!library!1240!04/30/2005-05:48:53:: Schedule
54043fb7-5eec-4063-ae6e-a0ed054e538c execution completed at 04/30/2005
05:48:53.
ReportingServicesService!dbpolling!194!30.04.2005-05:48:53::
EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1240!04/30/2005-05:48:53::
EventPolling finished processing item
a3d3a5e0-4634-4f32-ab10-8564fa09be40
ReportingServicesService!dbpolling!1240!04/30/2005-05:48:53::
EventPolling processing item 7efce5e2-8cca-4e87-9ac9-f2bac7ad68ff
ReportingServicesService!dbpolling!1240!04/30/2005-05:48:53::
EventPolling finished processing item
7efce5e2-8cca-4e87-9ac9-f2bac7ad68ff
The securitysettings for all reports are equal.
The failed jobs are also not mailed if started from sqlagent (although
they succeed as sqlagentjob)
Any suggestions are more than welcome, since i have no clue how to
solve this!
Regards jespHave you tried viewing the subscriptions through Report Manager? Perhaps
something is not set up correctly causing the subscription to not fire
correctly.
Have you tried creating the same subscriptions through Report Manager?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"jesp" <spitz@.tiscali.nl> wrote in message
news:1115007058.978980.232660@.o13g2000cwo.googlegroups.com...
> Hi,
>>From script i'm sending a few emails with pdf attachments.
> One report is mailed, two others not. The script for creating the
> subscriptions is equal, only different parameters.
> When I look in the logfiles I don't see any errors, however only the
> succeeded report has both event- and notificationpolling logging.
> So the logging for the succeeded one is:
> ReportingServicesService!dbpolling!1240!04/30/2005-05:49:52::
> EventPolling processing item f21fb887-9e00-40c5-8fac-f246ad14bd4f
> ReportingServicesService!dbpolling!194!30.04.2005-05:49:52::
> EventPolling processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!library!1240!04/30/2005-05:49:53:: Schedule
> 3461442c-d51f-4701-9413-a5bef0d283a0 executed at 04/30/2005 05:49:53.
> ReportingServicesService!schedule!1240!04/30/2005-05:49:53:: Creating
> Time based subscription notification for subscription:
> 3424547a-9e5a-4e74-8bd1-78af62a38490
> ReportingServicesService!library!1240!04/30/2005-05:49:53:: Schedule
> 3461442c-d51f-4701-9413-a5bef0d283a0 execution completed at 04/30/2005
> 05:49:53.
> ReportingServicesService!dbpolling!1240!04/30/2005-05:49:53::
> EventPolling finished processing item
> f21fb887-9e00-40c5-8fac-f246ad14bd4f
> ReportingServicesService!dbpolling!194!30.04.2005-05:49:53::
> EventPolling processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!1240!04/30/2005-05:49:53::
> EventPolling processing item 351c51cd-2274-4218-b92e-f05ebdcc0bcb
> ReportingServicesService!dbpolling!1240!04/30/2005-05:49:53::
> EventPolling finished processing item
> 351c51cd-2274-4218-b92e-f05ebdcc0bcb
> ReportingServicesService!dbpolling!194!30.04.2005-05:49:54::
> NotificationPolling processing 1 more items. 1 Total items in internal
> queue.
> ReportingServicesService!dbpolling!1240!04/30/2005-05:49:54::
> NotificationPolling processing item
> 72b719c2-1ae2-4e7a-a096-b15364e8ebd4
> ReportingServicesService!library!1240!04/30/2005-05:49:55:: i INFO:
> Call to RenderFirst( '/KEAS/KEASReports/Analyse' )
> ReportingServicesService!library!1240!04/30/2005-05:49:56:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server
> system properties.
> ReportingServicesService!emailextension!1240!04/30/2005-05:49:57::
> Email successfully sent to "spitz@.tiscali.nl" <spitz@.tiscali.nl>
> ReportingServicesService!library!1240!04/30/2005-05:49:57:: Data Driven
> Notification for activation id eff41ff5-c76d-4ced-be63-377e82daf4bb was
> saved.
> ReportingServicesService!library!1240!04/30/2005-05:49:57:: Status:
> Mail sent to spitz@.tiscali.nl;
> ReportingServicesService!notification!1240!04/30/2005-05:49:57::
> Notification 72b719c2-1ae2-4e7a-a096-b15364e8ebd4 completed. Success:
> True, Status: Mail sent to spitz@.tiscali.nl;, DeliveryExtension: Report
> Server Email, Report: Analyse, Attempt 0
> ReportingServicesService!dbpolling!1240!04/30/2005-05:49:57::
> NotificationPolling finished processing item
> 72b719c2-1ae2-4e7a-a096-b15364e8ebd4
> The logging for the ones that are not mailed (the subscriptions are
> created):
> ReportingServicesService!dbpolling!194!30.04.2005-05:48:52::
> EventPolling processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!1240!04/30/2005-05:48:52::
> EventPolling processing item a3d3a5e0-4634-4f32-ab10-8564fa09be40
> ReportingServicesService!library!1240!04/30/2005-05:48:52:: Schedule
> 54043fb7-5eec-4063-ae6e-a0ed054e538c executed at 04/30/2005 05:48:52.
> ReportingServicesService!schedule!1240!04/30/2005-05:48:52:: Creating
> Time based subscription notification for subscription:
> 9e5701ab-2fc5-48ab-8290-ae05f55fb29f
> ReportingServicesService!library!1240!04/30/2005-05:48:53:: Schedule
> 54043fb7-5eec-4063-ae6e-a0ed054e538c execution completed at 04/30/2005
> 05:48:53.
> ReportingServicesService!dbpolling!194!30.04.2005-05:48:53::
> EventPolling processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!1240!04/30/2005-05:48:53::
> EventPolling finished processing item
> a3d3a5e0-4634-4f32-ab10-8564fa09be40
> ReportingServicesService!dbpolling!1240!04/30/2005-05:48:53::
> EventPolling processing item 7efce5e2-8cca-4e87-9ac9-f2bac7ad68ff
> ReportingServicesService!dbpolling!1240!04/30/2005-05:48:53::
> EventPolling finished processing item
> 7efce5e2-8cca-4e87-9ac9-f2bac7ad68ff
>
> The securitysettings for all reports are equal.
> The failed jobs are also not mailed if started from sqlagent (although
> they succeed as sqlagentjob)
> Any suggestions are more than welcome, since i have no clue how to
> solve this!
> Regards jesp
>sql
Monday, March 26, 2012
Email with attachments.
I have just setup a new Reporting Service Server. I loaded a page then I created a subscription which will email and excel document of the report out.
Each time the subscription runs I am getting this error below:
Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.
When I take out the attachment on the email and just have it send the link the email runs fine with no errors. Is there some type of setup that needs to be done with the server side to have it send attachments?
Please let me know. Thanks
Ken, any luck with this problem?
I'm having the same issue - can email fine when only sending a link in the report subscription, but send fails when attempting to include an attachment. Just getting the following logon failure in the report server logs:
Logon Failure:
Reason: An error occurred during logon
User Name:
Domain:
Logon Type: 3
Logon Process: Authz
Authentication Package: Kerberos
Workstation Name: NZRPTAUC01
Status code: 0x8009030E
Substatus code: 0x0
Caller User Name: LOCAL SERVICE
Caller Domain: NT AUTHORITY
Caller Logon ID: (0x0,0x3E5)
Caller Process ID: 1740
Transited Services: -
Source Network Address: -
Source Port: -
|||
I am having same issue.. have you solved the problem?|||
Yes. The 'Log On' account that your SQL Server Reporting Services service runs under must have permissions to send email via your smtp server.
1. Open Admin Tools > Services on your report server and find the SQL Server Reporting Services service.
2. Double click the service and go to the Log On properties tab to determine the service account.
3. Set permissions on your smtp server to allow the service account to send email.
Email with attachments.
I have just setup a new Reporting Service Server. I loaded a page then I created a subscription which will email and excel document of the report out.
Each time the subscription runs I am getting this error below:
Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.
When I take out the attachment on the email and just have it send the link the email runs fine with no errors. Is there some type of setup that needs to be done with the server side to have it send attachments?
Please let me know. Thanks
Ken, any luck with this problem?
I'm having the same issue - can email fine when only sending a link in the report subscription, but send fails when attempting to include an attachment. Just getting the following logon failure in the report server logs:
Logon Failure:
Reason: An error occurred during logon
User Name:
Domain:
Logon Type: 3
Logon Process: Authz
Authentication Package: Kerberos
Workstation Name: NZRPTAUC01
Status code: 0x8009030E
Substatus code: 0x0
Caller User Name: LOCAL SERVICE
Caller Domain: NT AUTHORITY
Caller Logon ID: (0x0,0x3E5)
Caller Process ID: 1740
Transited Services: -
Source Network Address: -
Source Port: -
|||I am having same issue.. have you solved the problem?|||
Yes. The 'Log On' account that your SQL Server Reporting Services service runs under must have permissions to send email via your smtp server.
1. Open Admin Tools > Services on your report server and find the SQL Server Reporting Services service.
2. Double click the service and go to the Log On properties tab to determine the service account.
3. Set permissions on your smtp server to allow the service account to send email.
Email with attachments.
I have just setup a new Reporting Service Server. I loaded a page then I created a subscription which will email and excel document of the report out.
Each time the subscription runs I am getting this error below:
Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.
When I take out the attachment on the email and just have it send the link the email runs fine with no errors. Is there some type of setup that needs to be done with the server side to have it send attachments?
Please let me know. Thanks
Ken, any luck with this problem?
I'm having the same issue - can email fine when only sending a link in the report subscription, but send fails when attempting to include an attachment. Just getting the following logon failure in the report server logs:
Logon Failure:
Reason: An error occurred during logon
User Name:
Domain:
Logon Type: 3
Logon Process: Authz
Authentication Package: Kerberos
Workstation Name: NZRPTAUC01
Status code: 0x8009030E
Substatus code: 0x0
Caller User Name: LOCAL SERVICE
Caller Domain: NT AUTHORITY
Caller Logon ID: (0x0,0x3E5)
Caller Process ID: 1740
Transited Services: -
Source Network Address: -
Source Port: -
|||
I am having same issue.. have you solved the problem?|||
Yes. The 'Log On' account that your SQL Server Reporting Services service runs under must have permissions to send email via your smtp server.
1. Open Admin Tools > Services on your report server and find the SQL Server Reporting Services service.
2. Double click the service and go to the Log On properties tab to determine the service account.
3. Set permissions on your smtp server to allow the service account to send email.
Monday, March 19, 2012
Email Notification with Custom Attachments using Notification Services 2005
Hi All,
I am using Notification Services 2005.I have done with the configuration and deployment of Notification Services 2005.Now i wanted to know how to send notifications via email with custom attachments.
Please help me out in this issue.
Amby
Hi Amby -[copied for a reply to your newsgroup posting]
The built-in SMTP delivery protocol doesn't support attachments. But
you do have a couple of options:
1) you can build a custom delivery protocol that uses SMTP to send
notifications with attachments. I don't have Shyam Pather's SQLNS book
in front of me at the moment, but I think he goes through a similar
example in it. It's for v2.0, not 2005, but the same concepts should
apply.
2) I've also sent notifications via SMTP that have a link to a
resource that they need rather than including it as an attachment. For
example, rather than attaching a PDF, I place the PDF on a web site
and then send a link to the PDF in the notification. This has worked
well for me.
HTH....
--
Joe Webb
SQL Server MVP
http://www.sqlns.com
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
Sunday, March 11, 2012
EMAIL Coruption In attachments
am testing Email report schedules. We are working with files of type:
TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE SHARE
successfully. I am able to email LINKS to reports successfully. When I
send files of these three types as Email ATTACHMENTS they arrive corupted.
The HEX dump is really ugly. Mostly FF bytes... I am passing from RS to a
SMTP server is external to the RS server, which then passes the reports to
a NOTES server and then to me. The log file for RS shows nothing unusual.
How would you approach debuging this issue?
thanks.
dlrYou can now download a hotfix that addresses this problem. See
http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> OK, I am looking for help on how to break this problem up for debugging.
> I
> am testing Email report schedules. We are working with files of type:
> TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE SHARE
> successfully. I am able to email LINKS to reports successfully. When I
> send files of these three types as Email ATTACHMENTS they arrive corupted.
> The HEX dump is really ugly. Mostly FF bytes... I am passing from RS to
> a
> SMTP server is external to the RS server, which then passes the reports
> to
> a NOTES server and then to me. The log file for RS shows nothing unusual.
> How would you approach debuging this issue?
> thanks.
> dlr
>|||ok. thanks for the tip. HOTFix resolved all problems with a single
exception. WEB ARCHIVES are still not working in notes (works fine with
hotmail/outlook express) We are at v5.0.9 on Notes. Perhaps upgrading NOTES
will resolve this last problem?....
dlr
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:%236gRNPqgEHA.384@.TK2MSFTNGP10.phx.gbl...
> You can now download a hotfix that addresses this problem. See
> http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> > OK, I am looking for help on how to break this problem up for debugging.
> > I
> > am testing Email report schedules. We are working with files of type:
> > TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE
SHARE
> > successfully. I am able to email LINKS to reports successfully. When I
> > send files of these three types as Email ATTACHMENTS they arrive
corupted.
> > The HEX dump is really ugly. Mostly FF bytes... I am passing from RS
to
> > a
> > SMTP server is external to the RS server, which then passes the reports
> > to
> > a NOTES server and then to me. The log file for RS shows nothing
unusual.
> > How would you approach debuging this issue?
> >
> > thanks.
> >
> > dlr
> >
> >
>|||I believe the Notes Viewer does not support MHTML. You may want to change
your RS configuration to always attach MHTML rather then embed it. You can
do this by removing this line for the RSReportServer.config file:
<RenderingExtension>MHTML</RenderingExtension>
which is under the EmbeddedRenderFormats element
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
news:OUYrEE7gEHA.1392@.TK2MSFTNGP11.phx.gbl...
> ok. thanks for the tip. HOTFix resolved all problems with a single
> exception. WEB ARCHIVES are still not working in notes (works fine with
> hotmail/outlook express) We are at v5.0.9 on Notes. Perhaps upgrading
NOTES
> will resolve this last problem?....
> dlr
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:%236gRNPqgEHA.384@.TK2MSFTNGP10.phx.gbl...
> > You can now download a hotfix that addresses this problem. See
> > http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> > news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> > > OK, I am looking for help on how to break this problem up for
debugging.
> > > I
> > > am testing Email report schedules. We are working with files of type:
> > > TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE
> SHARE
> > > successfully. I am able to email LINKS to reports successfully. When
I
> > > send files of these three types as Email ATTACHMENTS they arrive
> corupted.
> > > The HEX dump is really ugly. Mostly FF bytes... I am passing from RS
> to
> > > a
> > > SMTP server is external to the RS server, which then passes the
reports
> > > to
> > > a NOTES server and then to me. The log file for RS shows nothing
> unusual.
> > > How would you approach debuging this issue?
> > >
> > > thanks.
> > >
> > > dlr
> > >
> > >
> >
> >
>|||very nice Daniel. thank you!
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:esmzQT7gEHA.2952@.TK2MSFTNGP09.phx.gbl...
> I believe the Notes Viewer does not support MHTML. You may want to change
> your RS configuration to always attach MHTML rather then embed it. You
can
> do this by removing this line for the RSReportServer.config file:
> <RenderingExtension>MHTML</RenderingExtension>
> which is under the EmbeddedRenderFormats element
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> news:OUYrEE7gEHA.1392@.TK2MSFTNGP11.phx.gbl...
> > ok. thanks for the tip. HOTFix resolved all problems with a single
> > exception. WEB ARCHIVES are still not working in notes (works fine with
> > hotmail/outlook express) We are at v5.0.9 on Notes. Perhaps upgrading
> NOTES
> > will resolve this last problem?....
> >
> > dlr
> >
> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> > news:%236gRNPqgEHA.384@.TK2MSFTNGP10.phx.gbl...
> > > You can now download a hotfix that addresses this problem. See
> > > http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
> > >
> > > --
> > > Brian Welcker
> > > Group Program Manager
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> > > news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> > > > OK, I am looking for help on how to break this problem up for
> debugging.
> > > > I
> > > > am testing Email report schedules. We are working with files of
type:
> > > > TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE
> > SHARE
> > > > successfully. I am able to email LINKS to reports successfully.
When
> I
> > > > send files of these three types as Email ATTACHMENTS they arrive
> > corupted.
> > > > The HEX dump is really ugly. Mostly FF bytes... I am passing from
RS
> > to
> > > > a
> > > > SMTP server is external to the RS server, which then passes the
> reports
> > > > to
> > > > a NOTES server and then to me. The log file for RS shows nothing
> > unusual.
> > > > How would you approach debuging this issue?
> > > >
> > > > thanks.
> > > >
> > > > dlr
> > > >
> > > >
> > >
> > >
> >
> >
>|||What exactly are you seeing? Can you create the subscriptions? Do they
never fire?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Carlos E. Mosquera" <CarlosEMosquera@.discussions.microsoft.com> wrote in
message news:D7BDCEF4-6090-49AD-A937-42A26EE9C192@.microsoft.com...
> Hi Dennis,
> We install this fix and now can't send any subscriptions.
> How you install this fix?
> Do you have some other problem when you isntall it?
> Thanks.
> "Dennis Redfield" wrote:
> > ok. thanks for the tip. HOTFix resolved all problems with a single
> > exception. WEB ARCHIVES are still not working in notes (works fine with
> > hotmail/outlook express) We are at v5.0.9 on Notes. Perhaps upgrading
NOTES
> > will resolve this last problem?....
> >
> > dlr
> >
> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> > news:%236gRNPqgEHA.384@.TK2MSFTNGP10.phx.gbl...
> > > You can now download a hotfix that addresses this problem. See
> > > http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
> > >
> > > --
> > > Brian Welcker
> > > Group Program Manager
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> > > news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> > > > OK, I am looking for help on how to break this problem up for
debugging.
> > > > I
> > > > am testing Email report schedules. We are working with files of
type:
> > > > TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE
> > SHARE
> > > > successfully. I am able to email LINKS to reports successfully.
When I
> > > > send files of these three types as Email ATTACHMENTS they arrive
> > corupted.
> > > > The HEX dump is really ugly. Mostly FF bytes... I am passing from
RS
> > to
> > > > a
> > > > SMTP server is external to the RS server, which then passes the
reports
> > > > to
> > > > a NOTES server and then to me. The log file for RS shows nothing
> > unusual.
> > > > How would you approach debuging this issue?
> > > >
> > > > thanks.
> > > >
> > > > dlr|||After fix install i subscriptions show this error:
Failure sending mail: The Report Server has encountered a configuration
error; more details in the log files
But before install subscriptions work with files formats errors.
Configuration was no touched and we have RS with SP1 + 872774
How log file i should check?
"Daniel Reib [MSFT]" wrote:
> What exactly are you seeing? Can you create the subscriptions? Do they
> never fire?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.|||This is the log (Fideicomiso is the report name):
ReportingServicesService!dbpolling!234!9/8/2004-16:30:03:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03:: EventPolling
processing item 4a28e564-b3d6-491d-826c-96a9926daf72
ReportingServicesService!library!3844!9/8/2004-16:30:03:: Schedule
a58e2b9e-782b-4589-b6c2-b920bf754c9e executed at 9/8/2004 4:30:03 PM.
ReportingServicesService!schedule!3844!9/8/2004-16:30:03:: Creating Time
based subscription notification for subscription:
4683f97c-9125-4f74-bb1c-5804303e7a54
ReportingServicesService!library!3844!9/8/2004-16:30:03:: Schedule
a58e2b9e-782b-4589-b6c2-b920bf754c9e execution completed at 9/8/2004 4:30:03
PM.
ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03:: EventPolling
finished processing item 4a28e564-b3d6-491d-826c-96a9926daf72
ReportingServicesService!dbpolling!234!9/8/2004-16:30:03::
NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03::
NotificationPolling processing item b8c2e7c5-0d9a-460b-b17d-e064f36198e7
ReportingServicesService!library!3844!09/08/2004-16:30:03:: i INFO:
Initializing EnableIntegratedSecurity to 'True' as specified in Server
system properties.
ReportingServicesService!library!3844!09/08/2004-16:30:04:: i INFO: Call to
RenderFirst( '/ReportSystem/Fideicomisos' )
ReportingServicesService!library!3844!09/08/2004-16:30:04:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 1355;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
ReportingServicesService!library!3844!09/08/2004-16:30:04:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!3844!09/08/2004-16:30:04:: Error
sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
The Report Server has encountered a configuration error; more details in the
log files -->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
at
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
userName)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32&
executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!notification!3844!09/08/2004-16:30:04::
Notification b8c2e7c5-0d9a-460b-b17d-e064f36198e7 completed. Success: False,
Status: Failure sending mail: The Report Server has encountered a
configuration error; more details in the log files, DeliveryExtension: Report
Server Email, Report: Fideicomisos, Attempt 0
ReportingServicesService!dbpolling!3844!09/08/2004-16:30:04::
NotificationPolling finished processing item
b8c2e7c5-0d9a-460b-b17d-e064f36198e7
"Carlos E. Mosquera" wrote:
> After fix install i subscriptions show this error:
> Failure sending mail: The Report Server has encountered a configuration
> error; more details in the log files
> But before install subscriptions work with files formats errors.
> Configuration was no touched and we have RS with SP1 + 872774
> How log file i should check?
> "Daniel Reib [MSFT]" wrote:
> > What exactly are you seeing? Can you create the subscriptions? Do they
> > never fire?
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no rights.|||The error you are getting is: The specified domain either does not exist or
could not be contacted.
This is indicating a problem resolving the name of the owner of the
subscription. Can you try recreating the subscription and see if the new
subscription works? Also, does this happen with all users? What about a
user local to the report server box?
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Carlos E. Mosquera" <CarlosEMosquera@.discussions.microsoft.com> wrote in
message news:F05D7D1B-BFAB-428B-9445-E3E640E0BDDE@.microsoft.com...
> This is the log (Fideicomiso is the report name):
> ReportingServicesService!dbpolling!234!9/8/2004-16:30:03:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03:: EventPolling
> processing item 4a28e564-b3d6-491d-826c-96a9926daf72
> ReportingServicesService!library!3844!9/8/2004-16:30:03:: Schedule
> a58e2b9e-782b-4589-b6c2-b920bf754c9e executed at 9/8/2004 4:30:03 PM.
> ReportingServicesService!schedule!3844!9/8/2004-16:30:03:: Creating Time
> based subscription notification for subscription:
> 4683f97c-9125-4f74-bb1c-5804303e7a54
> ReportingServicesService!library!3844!9/8/2004-16:30:03:: Schedule
> a58e2b9e-782b-4589-b6c2-b920bf754c9e execution completed at 9/8/2004
4:30:03
> PM.
> ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03:: EventPolling
> finished processing item 4a28e564-b3d6-491d-826c-96a9926daf72
> ReportingServicesService!dbpolling!234!9/8/2004-16:30:03::
> NotificationPolling processing 1 more items. 1 Total items in internal
queue.
> ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03::
> NotificationPolling processing item b8c2e7c5-0d9a-460b-b17d-e064f36198e7
> ReportingServicesService!library!3844!09/08/2004-16:30:03:: i INFO:
> Initializing EnableIntegratedSecurity to 'True' as specified in Server
> system properties.
> ReportingServicesService!library!3844!09/08/2004-16:30:04:: i INFO: Call
to
> RenderFirst( '/ReportSystem/Fideicomisos' )
> ReportingServicesService!library!3844!09/08/2004-16:30:04:: e ERROR:
> Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files, AuthzInitializeContextFromSid: Win32 error: 1355;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files
> ReportingServicesService!library!3844!09/08/2004-16:30:04:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server
system
> properties.
> ReportingServicesService!emailextension!3844!09/08/2004-16:30:04:: Error
> sending email.
Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
> The Report Server has encountered a configuration error; more details in
the
> log files -->
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files
> at
>
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntP
tr userSid)
> at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
> userName)
> at
>
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(Strin
g
> userName, IntPtr userToken)
> at
>
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(S
tring
> userName, IntPtr userToken, Byte[] secDesc, ReportOperation
requiredOperation)
> at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
> catItemType, Byte[] secDesc, ReportOperation rptOper)
> at
>
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionF
romCatalog(CatalogItemContext
> reportContext, String historyID, Boolean forRendering, Guid& reportID,
Int32&
> executionOption, String& savedParametersXml, ReportSnapshot&
> compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
> historyDate)
> at
> Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
> report, String historyID, Boolean forRendering, NameValueCollection
values,
> DatasourceCredentialsCollection credentials)
> at
>
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(Catalog
ItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters)
> at
>
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
> at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
> at
>
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> -- End of inner exception stack trace --
> at
>
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> at
>
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RS
Service
> rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
> type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
> String[]& secondaryStreamNames)
> at Microsoft.ReportingServices.Library.ReportImpl.Render(String
> renderFormat, String deviceInfo)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMes
sageBody(IMessage message, Notification notification, SubscriptionData data)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessag
e(Notification notification)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Noti
fication notification)
> ReportingServicesService!notification!3844!09/08/2004-16:30:04::
> Notification b8c2e7c5-0d9a-460b-b17d-e064f36198e7 completed. Success:
False,
> Status: Failure sending mail: The Report Server has encountered a
> configuration error; more details in the log files, DeliveryExtension:
Report
> Server Email, Report: Fideicomisos, Attempt 0
> ReportingServicesService!dbpolling!3844!09/08/2004-16:30:04::
> NotificationPolling finished processing item
> b8c2e7c5-0d9a-460b-b17d-e064f36198e7
>
> "Carlos E. Mosquera" wrote:
> > After fix install i subscriptions show this error:
> >
> > Failure sending mail: The Report Server has encountered a configuration
> > error; more details in the log files
> >
> > But before install subscriptions work with files formats errors.
> >
> > Configuration was no touched and we have RS with SP1 + 872774
> >
> > How log file i should check?
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> > > What exactly are you seeing? Can you create the subscriptions? Do
they
> > > never fire?
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no
rights.|||Hi Daniel,
Daniel Reib [MSFT] wrote:
> The error you are getting is: The specified domain either does not
> exist or could not be contacted.
> This is indicating a problem resolving the name of the owner of the
> subscription. Can you try recreating the subscription and see if the
> new subscription works? Also, does this happen with all users? What
> about a user local to the report server box?
PMFJI, but I am having the same issue as Carlos. Everything worked fine
with subscriptions with RS SP1, but I was having the issue of Lotus Notes
users not being able to open PDF attachments, so I installed the hotfix
872774. Now I'm unable to send any emails from RS (no matter what user I
create the subscription under). I'm running Windows 2003 Server, SQL Server
2000 SP3a, and RS SP1 w/872774 hotfix. I started a thread on 9/8/2004 at
8:25am PDT which shows the log file entries, but I didn't get a response
except from Carlos. Any ideas? Thanks!
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]|||This is very strange. I am not sure what is going on. Are you also
receiving the 1355 error?
It may be best for you to contact PSS to try and find a resolution for this.
I am not sure why installing the hotfix would cause these problems.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jake Marx" <msnews@.longhead.com> wrote in message
news:#8K95hnlEHA.1652@.TK2MSFTNGP09.phx.gbl...
> Hi Daniel,
> Daniel Reib [MSFT] wrote:
> > The error you are getting is: The specified domain either does not
> > exist or could not be contacted.
> >
> > This is indicating a problem resolving the name of the owner of the
> > subscription. Can you try recreating the subscription and see if the
> > new subscription works? Also, does this happen with all users? What
> > about a user local to the report server box?
> PMFJI, but I am having the same issue as Carlos. Everything worked fine
> with subscriptions with RS SP1, but I was having the issue of Lotus Notes
> users not being able to open PDF attachments, so I installed the hotfix
> 872774. Now I'm unable to send any emails from RS (no matter what user I
> create the subscription under). I'm running Windows 2003 Server, SQL
Server
> 2000 SP3a, and RS SP1 w/872774 hotfix. I started a thread on 9/8/2004 at
> 8:25am PDT which shows the log file entries, but I didn't get a response
> except from Carlos. Any ideas? Thanks!
> --
> Regards,
> Jake Marx
> MS MVP - Excel
> www.longhead.com
> [please keep replies in the newsgroup - email address unmonitored]
>|||Hi Daniel,
Daniel Reib [MSFT] wrote:
> This is very strange. I am not sure what is going on. Are you also
> receiving the 1355 error?
Yes - here's a snippet from my log file:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception: The Report Server has encountered a configuration error; more
details in the log files, AuthzInitializeContextFromSid: Win32 error: 1355;
> It may be best for you to contact PSS to try and find a resolution
> for this. I am not sure why installing the hotfix would cause these
> problems.
Thanks - I'll try contacting PSS to see if they can shed some light on this.
I'd like to resolve this without having to roll back to SP1, as I have a
client that needs PDF attachments sent from RS and she's on Lotus Notes.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]|||Hi
Finaly my server administrator try another way to avoid reinstall of RS and
everything work fine. He check every single configuration and all was
complete.
My principal server have SQL Server 2000 Ent. + SP3 and RS + SP1 in a
Windows 2003 Server, then we try use RS with another server with Windows 2000
Server SP4 with IIS 5 and Framework 1.1 (WITHOUT FIX 872774)
GUESS WHAT? Now all subscriptions work fine with same SMTP and
subscriptors use Lotus Notes 6.5.1 (and 6.5.2) and any files corrupted.
This experience tell me something... Windows 2003 Server will have something
wrong.
Thanks a lot for all your help and contributions.
"Daniel Reib [MSFT]" wrote:
> The error you are getting is: The specified domain either does not exist or
> could not be contacted.
>
> This is indicating a problem resolving the name of the owner of the
> subscription. Can you try recreating the subscription and see if the new
> subscription works? Also, does this happen with all users? What about a
> user local to the report server box?
>
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.|||Carlos,
Carlos E. Mosquera wrote:
> My principal server have SQL Server 2000 Ent. + SP3 and RS + SP1 in a
> Windows 2003 Server, then we try use RS with another server with
> Windows 2000 Server SP4 with IIS 5 and Framework 1.1 (WITHOUT FIX
> 872774)
> GUESS WHAT? Now all subscriptions work fine with same SMTP and
> subscriptors use Lotus Notes 6.5.1 (and 6.5.2) and any files
> corrupted.
> This experience tell me something... Windows 2003 Server will have
> something wrong.
I was working with PSS on this issue, but I ran out of time and options. I
never got it working under Windows Server 2003 with the hotfix applied. And
I was unsuccessful at getting it to work even after attempting to roll back
to RS SP1.
So I ended up doing the same thing - reformatting, installing Windows 2000
Server, installing RS, and installing RS SP1 - but I continued by installing
the hotfix as well. Guess what - works great now. I haven't had a Lotus
Notes client open the attachment yet, but hopefully it will work.
I did get an email today from the PSS rep assigned to my case. I think she
is leaning toward this being a Windows Server 2003 issue that happens to
cause problems for RS with the hotfix applied. Here's the article she
provided in case anyone else runs into this issue:
http://support.microsoft.com/?id=834859
I wish I still had 2003 installed so I could request this hotfix and test it
out. It does look promising.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]|||The hotfix actually fixed a similiar issue of ours:
Server A: Window 2003
Reporting Server: SP1 8.00.878.00
Issue: Excel Subscription Email Attachment Corrupted
Email Server: Novell Netware
Our two other environments/servers do not have problem:
Server B: Windows 2000
Reporting Server: RTM 8.00.743.00
Server C: Windows 2000
Reporting Server: SP1 8.00.878.00
So I think there is something to do with Windows2003 and Non-Exchange mail
server?
Tao
"Brian Welcker [MSFT]" wrote:
> You can now download a hotfix that addresses this problem. See
> http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> > OK, I am looking for help on how to break this problem up for debugging.
> > I
> > am testing Email report schedules. We are working with files of type:
> > TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE SHARE
> > successfully. I am able to email LINKS to reports successfully. When I
> > send files of these three types as Email ATTACHMENTS they arrive corupted.
> > The HEX dump is really ugly. Mostly FF bytes... I am passing from RS to
> > a
> > SMTP server is external to the RS server, which then passes the reports
> > to
> > a NOTES server and then to me. The log file for RS shows nothing unusual.
> > How would you approach debuging this issue?
> >
> > thanks.
> >
> > dlr
> >
> >
>
>