Email Subscriptions Problem

Hi,
We recently have troubleshoots with email subscriptions. Some reports are
correctly sent, others aren't... There are no error messages in the "state"
column of all those subscriptions, "mail sent to.." is displayed.
Everything seems correct in the log files, RS tells us that all messages
have been sent correctly. The only "strange" info line is this one before
report execution for subscription:
ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i INFO:
LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd, reportPath:
/<report_path>, userName: <domain>\<user> not found in the database.
Another user in the newsgroup is facing the same problem:
http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
For information, we are using Reporting Services SP2 on Windows Server 2K3.
Thanks in advance.
Grégory.You can try having the emails dropped to a folder instead. If all the
emails are getting correctly dropped then your SMTP server is having an
issue passing them on and you should look into that.
To get the emails to drop to a folder, set the SMTPPickupDirectory element
in the RSReportServer.config file to a folder location, then set the
SendUsing element to 1. All emails will then be placed in that folder. If
some are not being placed then the log files should state why they are not.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
> Hi,
> We recently have troubleshoots with email subscriptions. Some reports are
> correctly sent, others aren't... There are no error messages in the
> "state"
> column of all those subscriptions, "mail sent to.." is displayed.
> Everything seems correct in the log files, RS tells us that all messages
> have been sent correctly. The only "strange" info line is this one before
> report execution for subscription:
> ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i INFO:
> LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd, reportPath:
> /<report_path>, userName: <domain>\<user> not found in the database.
> Another user in the newsgroup is facing the same problem:
> http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
> For information, we are using Reporting Services SP2 on Windows Server
> 2K3.
> Thanks in advance.
> Grégory.
>|||Hi Daniel,
This is a pretty interesting option! I'll try this and let you know what the
results are.
thanks for your support.
Grégory.
"Daniel Reib [MSFT]" wrote:
> You can try having the emails dropped to a folder instead. If all the
> emails are getting correctly dropped then your SMTP server is having an
> issue passing them on and you should look into that.
> To get the emails to drop to a folder, set the SMTPPickupDirectory element
> in the RSReportServer.config file to a folder location, then set the
> SendUsing element to 1. All emails will then be placed in that folder. If
> some are not being placed then the log files should state why they are not.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
> > Hi,
> >
> > We recently have troubleshoots with email subscriptions. Some reports are
> > correctly sent, others aren't... There are no error messages in the
> > "state"
> > column of all those subscriptions, "mail sent to.." is displayed.
> >
> > Everything seems correct in the log files, RS tells us that all messages
> > have been sent correctly. The only "strange" info line is this one before
> > report execution for subscription:
> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i INFO:
> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd, reportPath:
> > /<report_path>, userName: <domain>\<user> not found in the database.
> >
> > Another user in the newsgroup is facing the same problem:
> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
> >
> > For information, we are using Reporting Services SP2 on Windows Server
> > 2K3.
> >
> > Thanks in advance.
> > Grégory.
> >
>
>|||I got the same issue, yesterday email working fine, but this morning not
working, and I try your option. Email message file .eml does droped in the
SMTPServerPickupFolder. But does it mean the issue of SMTP server passing? Is
it possible that RS fail to trigger SMTP to sending email? Thanks.
Tony
"Daniel Reib [MSFT]" wrote:
> You can try having the emails dropped to a folder instead. If all the
> emails are getting correctly dropped then your SMTP server is having an
> issue passing them on and you should look into that.
> To get the emails to drop to a folder, set the SMTPPickupDirectory element
> in the RSReportServer.config file to a folder location, then set the
> SendUsing element to 1. All emails will then be placed in that folder. If
> some are not being placed then the log files should state why they are not.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
> > Hi,
> >
> > We recently have troubleshoots with email subscriptions. Some reports are
> > correctly sent, others aren't... There are no error messages in the
> > "state"
> > column of all those subscriptions, "mail sent to.." is displayed.
> >
> > Everything seems correct in the log files, RS tells us that all messages
> > have been sent correctly. The only "strange" info line is this one before
> > report execution for subscription:
> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i INFO:
> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd, reportPath:
> > /<report_path>, userName: <domain>\<user> not found in the database.
> >
> > Another user in the newsgroup is facing the same problem:
> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
> >
> > For information, we are using Reporting Services SP2 on Windows Server
> > 2K3.
> >
> > Thanks in advance.
> > Grégory.
> >
>
>|||If all the emails are being dropped then RS is doing everything it can to
send the emails. We use the CDO objects to generate and send the emails.
If it reports no errors then from RS everything is working. The most
reliable way to set up RS to forward emails is to have it drop the .eml
files to the local SMTP pickup directory and have this relay the emails to
your SMTP server. Using the local smtp server gives you much better retry
logic as well as more configuration options.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tony" <Tony@.discussions.microsoft.com> wrote in message
news:8741570E-4313-4624-970E-57A047057244@.microsoft.com...
>I got the same issue, yesterday email working fine, but this morning not
> working, and I try your option. Email message file .eml does droped in the
> SMTPServerPickupFolder. But does it mean the issue of SMTP server passing?
> Is
> it possible that RS fail to trigger SMTP to sending email? Thanks.
> Tony
> "Daniel Reib [MSFT]" wrote:
>> You can try having the emails dropped to a folder instead. If all the
>> emails are getting correctly dropped then your SMTP server is having an
>> issue passing them on and you should look into that.
>> To get the emails to drop to a folder, set the SMTPPickupDirectory
>> element
>> in the RSReportServer.config file to a folder location, then set the
>> SendUsing element to 1. All emails will then be placed in that folder.
>> If
>> some are not being placed then the log files should state why they are
>> not.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
>> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
>> > Hi,
>> >
>> > We recently have troubleshoots with email subscriptions. Some reports
>> > are
>> > correctly sent, others aren't... There are no error messages in the
>> > "state"
>> > column of all those subscriptions, "mail sent to.." is displayed.
>> >
>> > Everything seems correct in the log files, RS tells us that all
>> > messages
>> > have been sent correctly. The only "strange" info line is this one
>> > before
>> > report execution for subscription:
>> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i INFO:
>> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd, reportPath:
>> > /<report_path>, userName: <domain>\<user> not found in the database.
>> >
>> > Another user in the newsgroup is facing the same problem:
>> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
>> >
>> > For information, we are using Reporting Services SP2 on Windows Server
>> > 2K3.
>> >
>> > Thanks in advance.
>> > Grégory.
>> >
>>|||Daniel, thanks for the answer. I see.
This time I took off SMTP pickup directory and also took off SendUse=1. It
works fine. I guess that's because I restart the ReportServer service.
Yesterday, I also missed some email, I tried to delete the subscription and
create a new one, if fixed as well.
So my suggestion to Greg is, to restart service and recreate the subscription.
So far they are working fine. Hope not missing again...
"Daniel Reib [MSFT]" wrote:
> If all the emails are being dropped then RS is doing everything it can to
> send the emails. We use the CDO objects to generate and send the emails.
> If it reports no errors then from RS everything is working. The most
> reliable way to set up RS to forward emails is to have it drop the .eml
> files to the local SMTP pickup directory and have this relay the emails to
> your SMTP server. Using the local smtp server gives you much better retry
> logic as well as more configuration options.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Tony" <Tony@.discussions.microsoft.com> wrote in message
> news:8741570E-4313-4624-970E-57A047057244@.microsoft.com...
> >I got the same issue, yesterday email working fine, but this morning not
> > working, and I try your option. Email message file .eml does droped in the
> > SMTPServerPickupFolder. But does it mean the issue of SMTP server passing?
> > Is
> > it possible that RS fail to trigger SMTP to sending email? Thanks.
> >
> > Tony
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> You can try having the emails dropped to a folder instead. If all the
> >> emails are getting correctly dropped then your SMTP server is having an
> >> issue passing them on and you should look into that.
> >>
> >> To get the emails to drop to a folder, set the SMTPPickupDirectory
> >> element
> >> in the RSReportServer.config file to a folder location, then set the
> >> SendUsing element to 1. All emails will then be placed in that folder.
> >> If
> >> some are not being placed then the log files should state why they are
> >> not.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> >> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
> >> > Hi,
> >> >
> >> > We recently have troubleshoots with email subscriptions. Some reports
> >> > are
> >> > correctly sent, others aren't... There are no error messages in the
> >> > "state"
> >> > column of all those subscriptions, "mail sent to.." is displayed.
> >> >
> >> > Everything seems correct in the log files, RS tells us that all
> >> > messages
> >> > have been sent correctly. The only "strange" info line is this one
> >> > before
> >> > report execution for subscription:
> >> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i INFO:
> >> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd, reportPath:
> >> > /<report_path>, userName: <domain>\<user> not found in the database.
> >> >
> >> > Another user in the newsgroup is facing the same problem:
> >> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
> >> >
> >> > For information, we are using Reporting Services SP2 on Windows Server
> >> > 2K3.
> >> >
> >> > Thanks in advance.
> >> > Grégory.
> >> >
> >>
> >>
> >>
>
>|||Again, when I create new Email subscription for new report, this time data
driven, not working at all, not matter I re-create or restart server. On the
report manager, showing executed successfully, but I did not receive any
email... Look like Email subscription not working properly. Anybody please
help.
In the log file, I have following:
ReportingServicesService!library!870!01/09/2006-16:36:05:: i INFO: Call to
RenderFirst( '/MyQReports/POWithoutSOAgingReportByBuyer' )
ReportingServicesService!library!870!01/09/2006-16:36:05:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!session!870!01/09/2006-16:36:05:: i INFO:
LoadSnapshot: Item with session: mbiqao45tcm10y45x3t0jqfv, reportPath:
/MyQReports/POWithoutSOAgingReportByBuyer, userName:
[mydomaion]\[myDomainUser] not found in the database
ReportingServicesService!cache!870!01/09/2006-16:36:05:: i INFO: Image from
cache : /MyQReports/POWithoutSOAgingReportByBuyer
ReportingServicesService!emailextension!870!01/09/2006-16:36:05:: Email
successfully sent to "tonyl@.cormine.com" <tonyl@.cormine.com>
ReportingServicesService!library!870!01/09/2006-16:36:05:: Data Driven
Notification for activation id 0ab9cb1f-4267-447a-8806-65d8be1c201f was saved.
ReportingServicesService!library!870!01/09/2006-16:36:05:: Status: Mail sent
to tonyl@.cormine.com
"Daniel Reib [MSFT]" wrote:
> If all the emails are being dropped then RS is doing everything it can to
> send the emails. We use the CDO objects to generate and send the emails.
> If it reports no errors then from RS everything is working. The most
> reliable way to set up RS to forward emails is to have it drop the .eml
> files to the local SMTP pickup directory and have this relay the emails to
> your SMTP server. Using the local smtp server gives you much better retry
> logic as well as more configuration options.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Tony" <Tony@.discussions.microsoft.com> wrote in message
> news:8741570E-4313-4624-970E-57A047057244@.microsoft.com...
> >I got the same issue, yesterday email working fine, but this morning not
> > working, and I try your option. Email message file .eml does droped in the
> > SMTPServerPickupFolder. But does it mean the issue of SMTP server passing?
> > Is
> > it possible that RS fail to trigger SMTP to sending email? Thanks.
> >
> > Tony
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> You can try having the emails dropped to a folder instead. If all the
> >> emails are getting correctly dropped then your SMTP server is having an
> >> issue passing them on and you should look into that.
> >>
> >> To get the emails to drop to a folder, set the SMTPPickupDirectory
> >> element
> >> in the RSReportServer.config file to a folder location, then set the
> >> SendUsing element to 1. All emails will then be placed in that folder.
> >> If
> >> some are not being placed then the log files should state why they are
> >> not.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> >> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
> >> > Hi,
> >> >
> >> > We recently have troubleshoots with email subscriptions. Some reports
> >> > are
> >> > correctly sent, others aren't... There are no error messages in the
> >> > "state"
> >> > column of all those subscriptions, "mail sent to.." is displayed.
> >> >
> >> > Everything seems correct in the log files, RS tells us that all
> >> > messages
> >> > have been sent correctly. The only "strange" info line is this one
> >> > before
> >> > report execution for subscription:
> >> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i INFO:
> >> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd, reportPath:
> >> > /<report_path>, userName: <domain>\<user> not found in the database.
> >> >
> >> > Another user in the newsgroup is facing the same problem:
> >> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
> >> >
> >> > For information, we are using Reporting Services SP2 on Windows Server
> >> > 2K3.
> >> >
> >> > Thanks in advance.
> >> > Grégory.
> >> >
> >>
> >>
> >>
>
>|||Can you look in the ReportServerService_<timestamp>.log file? This should
have info about the subscriptions.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tony" <Tony@.discussions.microsoft.com> wrote in message
news:77031B41-7C47-4E47-B53A-A6E8AE1DB71D@.microsoft.com...
> Again, when I create new Email subscription for new report, this time data
> driven, not working at all, not matter I re-create or restart server. On
> the
> report manager, showing executed successfully, but I did not receive any
> email... Look like Email subscription not working properly. Anybody please
> help.
> In the log file, I have following:
> ReportingServicesService!library!870!01/09/2006-16:36:05:: i INFO: Call to
> RenderFirst( '/MyQReports/POWithoutSOAgingReportByBuyer' )
> ReportingServicesService!library!870!01/09/2006-16:36:05:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server
> system
> properties.
> ReportingServicesService!session!870!01/09/2006-16:36:05:: i INFO:
> LoadSnapshot: Item with session: mbiqao45tcm10y45x3t0jqfv, reportPath:
> /MyQReports/POWithoutSOAgingReportByBuyer, userName:
> [mydomaion]\[myDomainUser] not found in the database
> ReportingServicesService!cache!870!01/09/2006-16:36:05:: i INFO: Image
> from
> cache : /MyQReports/POWithoutSOAgingReportByBuyer
> ReportingServicesService!emailextension!870!01/09/2006-16:36:05:: Email
> successfully sent to "tonyl@.cormine.com" <tonyl@.cormine.com>
> ReportingServicesService!library!870!01/09/2006-16:36:05:: Data Driven
> Notification for activation id 0ab9cb1f-4267-447a-8806-65d8be1c201f was
> saved.
> ReportingServicesService!library!870!01/09/2006-16:36:05:: Status: Mail
> sent
> to tonyl@.cormine.com
>
> "Daniel Reib [MSFT]" wrote:
>> If all the emails are being dropped then RS is doing everything it can to
>> send the emails. We use the CDO objects to generate and send the emails.
>> If it reports no errors then from RS everything is working. The most
>> reliable way to set up RS to forward emails is to have it drop the .eml
>> files to the local SMTP pickup directory and have this relay the emails
>> to
>> your SMTP server. Using the local smtp server gives you much better
>> retry
>> logic as well as more configuration options.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Tony" <Tony@.discussions.microsoft.com> wrote in message
>> news:8741570E-4313-4624-970E-57A047057244@.microsoft.com...
>> >I got the same issue, yesterday email working fine, but this morning not
>> > working, and I try your option. Email message file .eml does droped in
>> > the
>> > SMTPServerPickupFolder. But does it mean the issue of SMTP server
>> > passing?
>> > Is
>> > it possible that RS fail to trigger SMTP to sending email? Thanks.
>> >
>> > Tony
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> >> You can try having the emails dropped to a folder instead. If all the
>> >> emails are getting correctly dropped then your SMTP server is having
>> >> an
>> >> issue passing them on and you should look into that.
>> >>
>> >> To get the emails to drop to a folder, set the SMTPPickupDirectory
>> >> element
>> >> in the RSReportServer.config file to a folder location, then set the
>> >> SendUsing element to 1. All emails will then be placed in that
>> >> folder.
>> >> If
>> >> some are not being placed then the log files should state why they are
>> >> not.
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
>> >> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
>> >> > Hi,
>> >> >
>> >> > We recently have troubleshoots with email subscriptions. Some
>> >> > reports
>> >> > are
>> >> > correctly sent, others aren't... There are no error messages in the
>> >> > "state"
>> >> > column of all those subscriptions, "mail sent to.." is displayed.
>> >> >
>> >> > Everything seems correct in the log files, RS tells us that all
>> >> > messages
>> >> > have been sent correctly. The only "strange" info line is this one
>> >> > before
>> >> > report execution for subscription:
>> >> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i INFO:
>> >> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd,
>> >> > reportPath:
>> >> > /<report_path>, userName: <domain>\<user> not found in the database.
>> >> >
>> >> > Another user in the newsgroup is facing the same problem:
>> >> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
>> >> >
>> >> > For information, we are using Reporting Services SP2 on Windows
>> >> > Server
>> >> > 2K3.
>> >> >
>> >> > Thanks in advance.
>> >> > Grégory.
>> >> >
>> >>
>> >>
>> >>
>>|||Below copied logs was from the ReportServerService_<timestamp>.log file. It
tells userName:
> > [mydomaion]\[myDomainUser] not found in the database, but following with email sent successfully. I have no idea how to check it out.
We are using exchange server, last time I check the sentbox of the service
account, it has non email relating to RS email, event some of them I received.
Thanks.
Tony
"Daniel Reib [MSFT]" wrote:
> Can you look in the ReportServerService_<timestamp>.log file? This should
> have info about the subscriptions.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Tony" <Tony@.discussions.microsoft.com> wrote in message
> news:77031B41-7C47-4E47-B53A-A6E8AE1DB71D@.microsoft.com...
> > Again, when I create new Email subscription for new report, this time data
> > driven, not working at all, not matter I re-create or restart server. On
> > the
> > report manager, showing executed successfully, but I did not receive any
> > email... Look like Email subscription not working properly. Anybody please
> > help.
> > In the log file, I have following:
> > ReportingServicesService!library!870!01/09/2006-16:36:05:: i INFO: Call to
> > RenderFirst( '/MyQReports/POWithoutSOAgingReportByBuyer' )
> > ReportingServicesService!library!870!01/09/2006-16:36:05:: i INFO:
> > Initializing EnableExecutionLogging to 'True' as specified in Server
> > system
> > properties.
> > ReportingServicesService!session!870!01/09/2006-16:36:05:: i INFO:
> > LoadSnapshot: Item with session: mbiqao45tcm10y45x3t0jqfv, reportPath:
> > /MyQReports/POWithoutSOAgingReportByBuyer, userName:
> > [mydomaion]\[myDomainUser] not found in the database
> > ReportingServicesService!cache!870!01/09/2006-16:36:05:: i INFO: Image
> > from
> > cache : /MyQReports/POWithoutSOAgingReportByBuyer
> > ReportingServicesService!emailextension!870!01/09/2006-16:36:05:: Email
> > successfully sent to "tonyl@.cormine.com" <tonyl@.cormine.com>
> > ReportingServicesService!library!870!01/09/2006-16:36:05:: Data Driven
> > Notification for activation id 0ab9cb1f-4267-447a-8806-65d8be1c201f was
> > saved.
> > ReportingServicesService!library!870!01/09/2006-16:36:05:: Status: Mail
> > sent
> > to tonyl@.cormine.com
> >
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> If all the emails are being dropped then RS is doing everything it can to
> >> send the emails. We use the CDO objects to generate and send the emails.
> >> If it reports no errors then from RS everything is working. The most
> >> reliable way to set up RS to forward emails is to have it drop the .eml
> >> files to the local SMTP pickup directory and have this relay the emails
> >> to
> >> your SMTP server. Using the local smtp server gives you much better
> >> retry
> >> logic as well as more configuration options.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Tony" <Tony@.discussions.microsoft.com> wrote in message
> >> news:8741570E-4313-4624-970E-57A047057244@.microsoft.com...
> >> >I got the same issue, yesterday email working fine, but this morning not
> >> > working, and I try your option. Email message file .eml does droped in
> >> > the
> >> > SMTPServerPickupFolder. But does it mean the issue of SMTP server
> >> > passing?
> >> > Is
> >> > it possible that RS fail to trigger SMTP to sending email? Thanks.
> >> >
> >> > Tony
> >> >
> >> > "Daniel Reib [MSFT]" wrote:
> >> >
> >> >> You can try having the emails dropped to a folder instead. If all the
> >> >> emails are getting correctly dropped then your SMTP server is having
> >> >> an
> >> >> issue passing them on and you should look into that.
> >> >>
> >> >> To get the emails to drop to a folder, set the SMTPPickupDirectory
> >> >> element
> >> >> in the RSReportServer.config file to a folder location, then set the
> >> >> SendUsing element to 1. All emails will then be placed in that
> >> >> folder.
> >> >> If
> >> >> some are not being placed then the log files should state why they are
> >> >> not.
> >> >>
> >> >> --
> >> >> -Daniel
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> rights.
> >> >>
> >> >>
> >> >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> >> >> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
> >> >> > Hi,
> >> >> >
> >> >> > We recently have troubleshoots with email subscriptions. Some
> >> >> > reports
> >> >> > are
> >> >> > correctly sent, others aren't... There are no error messages in the
> >> >> > "state"
> >> >> > column of all those subscriptions, "mail sent to.." is displayed.
> >> >> >
> >> >> > Everything seems correct in the log files, RS tells us that all
> >> >> > messages
> >> >> > have been sent correctly. The only "strange" info line is this one
> >> >> > before
> >> >> > report execution for subscription:
> >> >> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i INFO:
> >> >> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd,
> >> >> > reportPath:
> >> >> > /<report_path>, userName: <domain>\<user> not found in the database.
> >> >> >
> >> >> > Another user in the newsgroup is facing the same problem:
> >> >> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
> >> >> >
> >> >> > For information, we are using Reporting Services SP2 on Windows
> >> >> > Server
> >> >> > 2K3.
> >> >> >
> >> >> > Thanks in advance.
> >> >> > Grégory.
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||Hi Tony and Daniel,
Well... After restarting ReportServer service, everything worked well during
2 days... and this morning the problem was back again!
I've tried to change SMTP Pickup Directory and SendUsing options, but since
we have to restart service for changes to take effect , it's always working
after that and eml files are created in the directory.
Mails are correctly sent too when i restart ReportServer, so the best way
would be to test the first option during some days.. But since the server is
our production server, it's impossible.
Is there a way to have messages dropped in the directory and sent via SMTP
in the meantime.
Thanx in advance.
Grégory.
"Tony" wrote:
> Daniel, thanks for the answer. I see.
> This time I took off SMTP pickup directory and also took off SendUse=1. It
> works fine. I guess that's because I restart the ReportServer service.
> Yesterday, I also missed some email, I tried to delete the subscription and
> create a new one, if fixed as well.
> So my suggestion to Greg is, to restart service and recreate the subscription.
> So far they are working fine. Hope not missing again...
> "Daniel Reib [MSFT]" wrote:
> > If all the emails are being dropped then RS is doing everything it can to
> > send the emails. We use the CDO objects to generate and send the emails.
> > If it reports no errors then from RS everything is working. The most
> > reliable way to set up RS to forward emails is to have it drop the .eml
> > files to the local SMTP pickup directory and have this relay the emails to
> > your SMTP server. Using the local smtp server gives you much better retry
> > logic as well as more configuration options.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "Tony" <Tony@.discussions.microsoft.com> wrote in message
> > news:8741570E-4313-4624-970E-57A047057244@.microsoft.com...
> > >I got the same issue, yesterday email working fine, but this morning not
> > > working, and I try your option. Email message file .eml does droped in the
> > > SMTPServerPickupFolder. But does it mean the issue of SMTP server passing?
> > > Is
> > > it possible that RS fail to trigger SMTP to sending email? Thanks.
> > >
> > > Tony
> > >
> > > "Daniel Reib [MSFT]" wrote:
> > >
> > >> You can try having the emails dropped to a folder instead. If all the
> > >> emails are getting correctly dropped then your SMTP server is having an
> > >> issue passing them on and you should look into that.
> > >>
> > >> To get the emails to drop to a folder, set the SMTPPickupDirectory
> > >> element
> > >> in the RSReportServer.config file to a folder location, then set the
> > >> SendUsing element to 1. All emails will then be placed in that folder.
> > >> If
> > >> some are not being placed then the log files should state why they are
> > >> not.
> > >>
> > >> --
> > >> -Daniel
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > >> rights.
> > >>
> > >>
> > >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> > >> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
> > >> > Hi,
> > >> >
> > >> > We recently have troubleshoots with email subscriptions. Some reports
> > >> > are
> > >> > correctly sent, others aren't... There are no error messages in the
> > >> > "state"
> > >> > column of all those subscriptions, "mail sent to.." is displayed.
> > >> >
> > >> > Everything seems correct in the log files, RS tells us that all
> > >> > messages
> > >> > have been sent correctly. The only "strange" info line is this one
> > >> > before
> > >> > report execution for subscription:
> > >> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i INFO:
> > >> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd, reportPath:
> > >> > /<report_path>, userName: <domain>\<user> not found in the database.
> > >> >
> > >> > Another user in the newsgroup is facing the same problem:
> > >> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
> > >> >
> > >> > For information, we are using Reporting Services SP2 on Windows Server
> > >> > 2K3.
> > >> >
> > >> > Thanks in advance.
> > >> > Grégory.
> > >> >
> > >>
> > >>
> > >>
> >
> >
> >|||Yes, this is the most reliable way to send emails from RS. To do this you
must have the local SMTP server installed. You then configure the SMTP
server to relay the messages, then configure RS to drop the eml files to the
SMTP server's pickup directory.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
news:73376ECB-98E3-423F-AB38-BB267DB862A9@.microsoft.com...
> Hi Tony and Daniel,
> Well... After restarting ReportServer service, everything worked well
> during
> 2 days... and this morning the problem was back again!
> I've tried to change SMTP Pickup Directory and SendUsing options, but
> since
> we have to restart service for changes to take effect , it's always
> working
> after that and eml files are created in the directory.
> Mails are correctly sent too when i restart ReportServer, so the best way
> would be to test the first option during some days.. But since the server
> is
> our production server, it's impossible.
> Is there a way to have messages dropped in the directory and sent via SMTP
> in the meantime.
> Thanx in advance.
> Grégory.
> "Tony" wrote:
>> Daniel, thanks for the answer. I see.
>> This time I took off SMTP pickup directory and also took off SendUse=1.
>> It
>> works fine. I guess that's because I restart the ReportServer service.
>> Yesterday, I also missed some email, I tried to delete the subscription
>> and
>> create a new one, if fixed as well.
>> So my suggestion to Greg is, to restart service and recreate the
>> subscription.
>> So far they are working fine. Hope not missing again...
>> "Daniel Reib [MSFT]" wrote:
>> > If all the emails are being dropped then RS is doing everything it can
>> > to
>> > send the emails. We use the CDO objects to generate and send the
>> > emails.
>> > If it reports no errors then from RS everything is working. The most
>> > reliable way to set up RS to forward emails is to have it drop the .eml
>> > files to the local SMTP pickup directory and have this relay the emails
>> > to
>> > your SMTP server. Using the local smtp server gives you much better
>> > retry
>> > logic as well as more configuration options.
>> >
>> > --
>> > -Daniel
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >
>> >
>> > "Tony" <Tony@.discussions.microsoft.com> wrote in message
>> > news:8741570E-4313-4624-970E-57A047057244@.microsoft.com...
>> > >I got the same issue, yesterday email working fine, but this morning
>> > >not
>> > > working, and I try your option. Email message file .eml does droped
>> > > in the
>> > > SMTPServerPickupFolder. But does it mean the issue of SMTP server
>> > > passing?
>> > > Is
>> > > it possible that RS fail to trigger SMTP to sending email? Thanks.
>> > >
>> > > Tony
>> > >
>> > > "Daniel Reib [MSFT]" wrote:
>> > >
>> > >> You can try having the emails dropped to a folder instead. If all
>> > >> the
>> > >> emails are getting correctly dropped then your SMTP server is having
>> > >> an
>> > >> issue passing them on and you should look into that.
>> > >>
>> > >> To get the emails to drop to a folder, set the SMTPPickupDirectory
>> > >> element
>> > >> in the RSReportServer.config file to a folder location, then set the
>> > >> SendUsing element to 1. All emails will then be placed in that
>> > >> folder.
>> > >> If
>> > >> some are not being placed then the log files should state why they
>> > >> are
>> > >> not.
>> > >>
>> > >> --
>> > >> -Daniel
>> > >> This posting is provided "AS IS" with no warranties, and confers no
>> > >> rights.
>> > >>
>> > >>
>> > >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
>> > >> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
>> > >> > Hi,
>> > >> >
>> > >> > We recently have troubleshoots with email subscriptions. Some
>> > >> > reports
>> > >> > are
>> > >> > correctly sent, others aren't... There are no error messages in
>> > >> > the
>> > >> > "state"
>> > >> > column of all those subscriptions, "mail sent to.." is displayed.
>> > >> >
>> > >> > Everything seems correct in the log files, RS tells us that all
>> > >> > messages
>> > >> > have been sent correctly. The only "strange" info line is this one
>> > >> > before
>> > >> > report execution for subscription:
>> > >> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i INFO:
>> > >> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd,
>> > >> > reportPath:
>> > >> > /<report_path>, userName: <domain>\<user> not found in the
>> > >> > database.
>> > >> >
>> > >> > Another user in the newsgroup is facing the same problem:
>> > >> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
>> > >> >
>> > >> > For information, we are using Reporting Services SP2 on Windows
>> > >> > Server
>> > >> > 2K3.
>> > >> >
>> > >> > Thanks in advance.
>> > >> > Grégory.
>> > >> >
>> > >>
>> > >>
>> > >>
>> >
>> >
>> >|||I'm not sure what the issue could be. From the RS side, it has completed
the mailing successfully. I'm not sure why you are not receiving the
emails.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tony" <Tony@.discussions.microsoft.com> wrote in message
news:1D7BBD81-0405-4948-B096-E259B302D8DC@.microsoft.com...
> Below copied logs was from the ReportServerService_<timestamp>.log file.
> It
> tells userName:
>> > [mydomaion]\[myDomainUser] not found in the database, but following
>> > with email sent successfully. I have no idea how to check it out.
> We are using exchange server, last time I check the sentbox of the service
> account, it has non email relating to RS email, event some of them I
> received.
> Thanks.
> Tony
> "Daniel Reib [MSFT]" wrote:
>> Can you look in the ReportServerService_<timestamp>.log file? This
>> should
>> have info about the subscriptions.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Tony" <Tony@.discussions.microsoft.com> wrote in message
>> news:77031B41-7C47-4E47-B53A-A6E8AE1DB71D@.microsoft.com...
>> > Again, when I create new Email subscription for new report, this time
>> > data
>> > driven, not working at all, not matter I re-create or restart server.
>> > On
>> > the
>> > report manager, showing executed successfully, but I did not receive
>> > any
>> > email... Look like Email subscription not working properly. Anybody
>> > please
>> > help.
>> > In the log file, I have following:
>> > ReportingServicesService!library!870!01/09/2006-16:36:05:: i INFO: Call
>> > to
>> > RenderFirst( '/MyQReports/POWithoutSOAgingReportByBuyer' )
>> > ReportingServicesService!library!870!01/09/2006-16:36:05:: i INFO:
>> > Initializing EnableExecutionLogging to 'True' as specified in Server
>> > system
>> > properties.
>> > ReportingServicesService!session!870!01/09/2006-16:36:05:: i INFO:
>> > LoadSnapshot: Item with session: mbiqao45tcm10y45x3t0jqfv, reportPath:
>> > /MyQReports/POWithoutSOAgingReportByBuyer, userName:
>> > [mydomaion]\[myDomainUser] not found in the database
>> > ReportingServicesService!cache!870!01/09/2006-16:36:05:: i INFO: Image
>> > from
>> > cache : /MyQReports/POWithoutSOAgingReportByBuyer
>> > ReportingServicesService!emailextension!870!01/09/2006-16:36:05:: Email
>> > successfully sent to "tonyl@.cormine.com" <tonyl@.cormine.com>
>> > ReportingServicesService!library!870!01/09/2006-16:36:05:: Data Driven
>> > Notification for activation id 0ab9cb1f-4267-447a-8806-65d8be1c201f was
>> > saved.
>> > ReportingServicesService!library!870!01/09/2006-16:36:05:: Status: Mail
>> > sent
>> > to tonyl@.cormine.com
>> >
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> >> If all the emails are being dropped then RS is doing everything it can
>> >> to
>> >> send the emails. We use the CDO objects to generate and send the
>> >> emails.
>> >> If it reports no errors then from RS everything is working. The most
>> >> reliable way to set up RS to forward emails is to have it drop the
>> >> .eml
>> >> files to the local SMTP pickup directory and have this relay the
>> >> emails
>> >> to
>> >> your SMTP server. Using the local smtp server gives you much better
>> >> retry
>> >> logic as well as more configuration options.
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "Tony" <Tony@.discussions.microsoft.com> wrote in message
>> >> news:8741570E-4313-4624-970E-57A047057244@.microsoft.com...
>> >> >I got the same issue, yesterday email working fine, but this morning
>> >> >not
>> >> > working, and I try your option. Email message file .eml does droped
>> >> > in
>> >> > the
>> >> > SMTPServerPickupFolder. But does it mean the issue of SMTP server
>> >> > passing?
>> >> > Is
>> >> > it possible that RS fail to trigger SMTP to sending email? Thanks.
>> >> >
>> >> > Tony
>> >> >
>> >> > "Daniel Reib [MSFT]" wrote:
>> >> >
>> >> >> You can try having the emails dropped to a folder instead. If all
>> >> >> the
>> >> >> emails are getting correctly dropped then your SMTP server is
>> >> >> having
>> >> >> an
>> >> >> issue passing them on and you should look into that.
>> >> >>
>> >> >> To get the emails to drop to a folder, set the SMTPPickupDirectory
>> >> >> element
>> >> >> in the RSReportServer.config file to a folder location, then set
>> >> >> the
>> >> >> SendUsing element to 1. All emails will then be placed in that
>> >> >> folder.
>> >> >> If
>> >> >> some are not being placed then the log files should state why they
>> >> >> are
>> >> >> not.
>> >> >>
>> >> >> --
>> >> >> -Daniel
>> >> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> >> rights.
>> >> >>
>> >> >>
>> >> >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
>> >> >> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
>> >> >> > Hi,
>> >> >> >
>> >> >> > We recently have troubleshoots with email subscriptions. Some
>> >> >> > reports
>> >> >> > are
>> >> >> > correctly sent, others aren't... There are no error messages in
>> >> >> > the
>> >> >> > "state"
>> >> >> > column of all those subscriptions, "mail sent to.." is displayed.
>> >> >> >
>> >> >> > Everything seems correct in the log files, RS tells us that all
>> >> >> > messages
>> >> >> > have been sent correctly. The only "strange" info line is this
>> >> >> > one
>> >> >> > before
>> >> >> > report execution for subscription:
>> >> >> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i
>> >> >> > INFO:
>> >> >> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd,
>> >> >> > reportPath:
>> >> >> > /<report_path>, userName: <domain>\<user> not found in the
>> >> >> > database.
>> >> >> >
>> >> >> > Another user in the newsgroup is facing the same problem:
>> >> >> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
>> >> >> >
>> >> >> > For information, we are using Reporting Services SP2 on Windows
>> >> >> > Server
>> >> >> > 2K3.
>> >> >> >
>> >> >> > Thanks in advance.
>> >> >> > Grégory.
>> >> >> >
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Hi,
I've got some news!
I've made some test with the AntiVirus protection on the server... and guess
what... when I stop the antivirus, subscriptions on a particular problematic
report are working ... when I start it again, mails aren't sent.
We are actually using Symantec AntiVirus 10, this version has been installed
mid-december. Is there any incomatibility beetween this progam and Reporting
Services ?
Once again Daniel, thanks for your support.
Grégory.
"Daniel Reib [MSFT]" wrote:
> Yes, this is the most reliable way to send emails from RS. To do this you
> must have the local SMTP server installed. You then configure the SMTP
> server to relay the messages, then configure RS to drop the eml files to the
> SMTP server's pickup directory.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> news:73376ECB-98E3-423F-AB38-BB267DB862A9@.microsoft.com...
> > Hi Tony and Daniel,
> >
> > Well... After restarting ReportServer service, everything worked well
> > during
> > 2 days... and this morning the problem was back again!
> >
> > I've tried to change SMTP Pickup Directory and SendUsing options, but
> > since
> > we have to restart service for changes to take effect , it's always
> > working
> > after that and eml files are created in the directory.
> > Mails are correctly sent too when i restart ReportServer, so the best way
> > would be to test the first option during some days.. But since the server
> > is
> > our production server, it's impossible.
> >
> > Is there a way to have messages dropped in the directory and sent via SMTP
> > in the meantime.
> >
> > Thanx in advance.
> > Grégory.
> >
> > "Tony" wrote:
> >
> >> Daniel, thanks for the answer. I see.
> >> This time I took off SMTP pickup directory and also took off SendUse=1.
> >> It
> >> works fine. I guess that's because I restart the ReportServer service.
> >> Yesterday, I also missed some email, I tried to delete the subscription
> >> and
> >> create a new one, if fixed as well.
> >> So my suggestion to Greg is, to restart service and recreate the
> >> subscription.
> >> So far they are working fine. Hope not missing again...
> >>
> >> "Daniel Reib [MSFT]" wrote:
> >>
> >> > If all the emails are being dropped then RS is doing everything it can
> >> > to
> >> > send the emails. We use the CDO objects to generate and send the
> >> > emails.
> >> > If it reports no errors then from RS everything is working. The most
> >> > reliable way to set up RS to forward emails is to have it drop the .eml
> >> > files to the local SMTP pickup directory and have this relay the emails
> >> > to
> >> > your SMTP server. Using the local smtp server gives you much better
> >> > retry
> >> > logic as well as more configuration options.
> >> >
> >> > --
> >> > -Daniel
> >> > This posting is provided "AS IS" with no warranties, and confers no
> >> > rights.
> >> >
> >> >
> >> > "Tony" <Tony@.discussions.microsoft.com> wrote in message
> >> > news:8741570E-4313-4624-970E-57A047057244@.microsoft.com...
> >> > >I got the same issue, yesterday email working fine, but this morning
> >> > >not
> >> > > working, and I try your option. Email message file .eml does droped
> >> > > in the
> >> > > SMTPServerPickupFolder. But does it mean the issue of SMTP server
> >> > > passing?
> >> > > Is
> >> > > it possible that RS fail to trigger SMTP to sending email? Thanks.
> >> > >
> >> > > Tony
> >> > >
> >> > > "Daniel Reib [MSFT]" wrote:
> >> > >
> >> > >> You can try having the emails dropped to a folder instead. If all
> >> > >> the
> >> > >> emails are getting correctly dropped then your SMTP server is having
> >> > >> an
> >> > >> issue passing them on and you should look into that.
> >> > >>
> >> > >> To get the emails to drop to a folder, set the SMTPPickupDirectory
> >> > >> element
> >> > >> in the RSReportServer.config file to a folder location, then set the
> >> > >> SendUsing element to 1. All emails will then be placed in that
> >> > >> folder.
> >> > >> If
> >> > >> some are not being placed then the log files should state why they
> >> > >> are
> >> > >> not.
> >> > >>
> >> > >> --
> >> > >> -Daniel
> >> > >> This posting is provided "AS IS" with no warranties, and confers no
> >> > >> rights.
> >> > >>
> >> > >>
> >> > >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> >> > >> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
> >> > >> > Hi,
> >> > >> >
> >> > >> > We recently have troubleshoots with email subscriptions. Some
> >> > >> > reports
> >> > >> > are
> >> > >> > correctly sent, others aren't... There are no error messages in
> >> > >> > the
> >> > >> > "state"
> >> > >> > column of all those subscriptions, "mail sent to.." is displayed.
> >> > >> >
> >> > >> > Everything seems correct in the log files, RS tells us that all
> >> > >> > messages
> >> > >> > have been sent correctly. The only "strange" info line is this one
> >> > >> > before
> >> > >> > report execution for subscription:
> >> > >> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i INFO:
> >> > >> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd,
> >> > >> > reportPath:
> >> > >> > /<report_path>, userName: <domain>\<user> not found in the
> >> > >> > database.
> >> > >> >
> >> > >> > Another user in the newsgroup is facing the same problem:
> >> > >> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
> >> > >> >
> >> > >> > For information, we are using Reporting Services SP2 on Windows
> >> > >> > Server
> >> > >> > 2K3.
> >> > >> >
> >> > >> > Thanks in advance.
> >> > >> > Grégory.
> >> > >> >
> >> > >>
> >> > >>
> >> > >>
> >> >
> >> >
> >> >
>
>|||I have not heard of this kind of issue before. Is this when the emails are
being dropped to a folder or sent directly to the SMTP server? Does it
repro if you leave the antivirus on and don't scan the RSTempFiles
directory? Are you excluding the ASP.Net temporary files directory?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
news:86506F24-662F-4038-A6E5-D9C8766B1E31@.microsoft.com...
> Hi,
> I've got some news!
> I've made some test with the AntiVirus protection on the server... and
> guess
> what... when I stop the antivirus, subscriptions on a particular
> problematic
> report are working ... when I start it again, mails aren't sent.
> We are actually using Symantec AntiVirus 10, this version has been
> installed
> mid-december. Is there any incomatibility beetween this progam and
> Reporting
> Services ?
> Once again Daniel, thanks for your support.
> Grégory.
> "Daniel Reib [MSFT]" wrote:
>> Yes, this is the most reliable way to send emails from RS. To do this
>> you
>> must have the local SMTP server installed. You then configure the SMTP
>> server to relay the messages, then configure RS to drop the eml files to
>> the
>> SMTP server's pickup directory.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
>> news:73376ECB-98E3-423F-AB38-BB267DB862A9@.microsoft.com...
>> > Hi Tony and Daniel,
>> >
>> > Well... After restarting ReportServer service, everything worked well
>> > during
>> > 2 days... and this morning the problem was back again!
>> >
>> > I've tried to change SMTP Pickup Directory and SendUsing options, but
>> > since
>> > we have to restart service for changes to take effect , it's always
>> > working
>> > after that and eml files are created in the directory.
>> > Mails are correctly sent too when i restart ReportServer, so the best
>> > way
>> > would be to test the first option during some days.. But since the
>> > server
>> > is
>> > our production server, it's impossible.
>> >
>> > Is there a way to have messages dropped in the directory and sent via
>> > SMTP
>> > in the meantime.
>> >
>> > Thanx in advance.
>> > Grégory.
>> >
>> > "Tony" wrote:
>> >
>> >> Daniel, thanks for the answer. I see.
>> >> This time I took off SMTP pickup directory and also took off
>> >> SendUse=1.
>> >> It
>> >> works fine. I guess that's because I restart the ReportServer service.
>> >> Yesterday, I also missed some email, I tried to delete the
>> >> subscription
>> >> and
>> >> create a new one, if fixed as well.
>> >> So my suggestion to Greg is, to restart service and recreate the
>> >> subscription.
>> >> So far they are working fine. Hope not missing again...
>> >>
>> >> "Daniel Reib [MSFT]" wrote:
>> >>
>> >> > If all the emails are being dropped then RS is doing everything it
>> >> > can
>> >> > to
>> >> > send the emails. We use the CDO objects to generate and send the
>> >> > emails.
>> >> > If it reports no errors then from RS everything is working. The
>> >> > most
>> >> > reliable way to set up RS to forward emails is to have it drop the
>> >> > .eml
>> >> > files to the local SMTP pickup directory and have this relay the
>> >> > emails
>> >> > to
>> >> > your SMTP server. Using the local smtp server gives you much better
>> >> > retry
>> >> > logic as well as more configuration options.
>> >> >
>> >> > --
>> >> > -Daniel
>> >> > This posting is provided "AS IS" with no warranties, and confers no
>> >> > rights.
>> >> >
>> >> >
>> >> > "Tony" <Tony@.discussions.microsoft.com> wrote in message
>> >> > news:8741570E-4313-4624-970E-57A047057244@.microsoft.com...
>> >> > >I got the same issue, yesterday email working fine, but this
>> >> > >morning
>> >> > >not
>> >> > > working, and I try your option. Email message file .eml does
>> >> > > droped
>> >> > > in the
>> >> > > SMTPServerPickupFolder. But does it mean the issue of SMTP server
>> >> > > passing?
>> >> > > Is
>> >> > > it possible that RS fail to trigger SMTP to sending email? Thanks.
>> >> > >
>> >> > > Tony
>> >> > >
>> >> > > "Daniel Reib [MSFT]" wrote:
>> >> > >
>> >> > >> You can try having the emails dropped to a folder instead. If
>> >> > >> all
>> >> > >> the
>> >> > >> emails are getting correctly dropped then your SMTP server is
>> >> > >> having
>> >> > >> an
>> >> > >> issue passing them on and you should look into that.
>> >> > >>
>> >> > >> To get the emails to drop to a folder, set the
>> >> > >> SMTPPickupDirectory
>> >> > >> element
>> >> > >> in the RSReportServer.config file to a folder location, then set
>> >> > >> the
>> >> > >> SendUsing element to 1. All emails will then be placed in that
>> >> > >> folder.
>> >> > >> If
>> >> > >> some are not being placed then the log files should state why
>> >> > >> they
>> >> > >> are
>> >> > >> not.
>> >> > >>
>> >> > >> --
>> >> > >> -Daniel
>> >> > >> This posting is provided "AS IS" with no warranties, and confers
>> >> > >> no
>> >> > >> rights.
>> >> > >>
>> >> > >>
>> >> > >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in
>> >> > >> message
>> >> > >> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
>> >> > >> > Hi,
>> >> > >> >
>> >> > >> > We recently have troubleshoots with email subscriptions. Some
>> >> > >> > reports
>> >> > >> > are
>> >> > >> > correctly sent, others aren't... There are no error messages in
>> >> > >> > the
>> >> > >> > "state"
>> >> > >> > column of all those subscriptions, "mail sent to.." is
>> >> > >> > displayed.
>> >> > >> >
>> >> > >> > Everything seems correct in the log files, RS tells us that all
>> >> > >> > messages
>> >> > >> > have been sent correctly. The only "strange" info line is this
>> >> > >> > one
>> >> > >> > before
>> >> > >> > report execution for subscription:
>> >> > >> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i
>> >> > >> > INFO:
>> >> > >> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd,
>> >> > >> > reportPath:
>> >> > >> > /<report_path>, userName: <domain>\<user> not found in the
>> >> > >> > database.
>> >> > >> >
>> >> > >> > Another user in the newsgroup is facing the same problem:
>> >> > >> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
>> >> > >> >
>> >> > >> > For information, we are using Reporting Services SP2 on Windows
>> >> > >> > Server
>> >> > >> > 2K3.
>> >> > >> >
>> >> > >> > Thanks in advance.
>> >> > >> > Grégory.
>> >> > >> >
>> >> > >>
>> >> > >>
>> >> > >>
>> >> >
>> >> >
>> >> >
>>|||Greg,
When you say "not sent", what does log say about it? Is it still not error,
but the receipt not receive the email? I was using outlook to receive email,
email went to "Junk E-Mail" box, I though I did not receive them at all.
(Daniel, sorry about my last message, in fact it was working fine.). If you
are include the report as "Web Archive" and you turn on your outlook "Junk
Email" setting, the email will go to "Junk E-Mail". But with Excel format, it
will go to your inbox, or rountie by some rules you define.
I guess, with "Web Archive" the email message will contain some script
outlook "thinks" un-save to it. So I guess, when you run AntiVirus, for
protection, the email either filter to Junk mail box by outlook, or filter by
the mail server, thought?
Tony
"Daniel Reib [MSFT]" wrote:
> I have not heard of this kind of issue before. Is this when the emails are
> being dropped to a folder or sent directly to the SMTP server? Does it
> repro if you leave the antivirus on and don't scan the RSTempFiles
> directory? Are you excluding the ASP.Net temporary files directory?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> news:86506F24-662F-4038-A6E5-D9C8766B1E31@.microsoft.com...
> > Hi,
> >
> > I've got some news!
> > I've made some test with the AntiVirus protection on the server... and
> > guess
> > what... when I stop the antivirus, subscriptions on a particular
> > problematic
> > report are working ... when I start it again, mails aren't sent.
> >
> > We are actually using Symantec AntiVirus 10, this version has been
> > installed
> > mid-december. Is there any incomatibility beetween this progam and
> > Reporting
> > Services ?
> >
> > Once again Daniel, thanks for your support.
> >
> > Grégory.
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> Yes, this is the most reliable way to send emails from RS. To do this
> >> you
> >> must have the local SMTP server installed. You then configure the SMTP
> >> server to relay the messages, then configure RS to drop the eml files to
> >> the
> >> SMTP server's pickup directory.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> >> news:73376ECB-98E3-423F-AB38-BB267DB862A9@.microsoft.com...
> >> > Hi Tony and Daniel,
> >> >
> >> > Well... After restarting ReportServer service, everything worked well
> >> > during
> >> > 2 days... and this morning the problem was back again!
> >> >
> >> > I've tried to change SMTP Pickup Directory and SendUsing options, but
> >> > since
> >> > we have to restart service for changes to take effect , it's always
> >> > working
> >> > after that and eml files are created in the directory.
> >> > Mails are correctly sent too when i restart ReportServer, so the best
> >> > way
> >> > would be to test the first option during some days.. But since the
> >> > server
> >> > is
> >> > our production server, it's impossible.
> >> >
> >> > Is there a way to have messages dropped in the directory and sent via
> >> > SMTP
> >> > in the meantime.
> >> >
> >> > Thanx in advance.
> >> > Grégory.
> >> >
> >> > "Tony" wrote:
> >> >
> >> >> Daniel, thanks for the answer. I see.
> >> >> This time I took off SMTP pickup directory and also took off
> >> >> SendUse=1.
> >> >> It
> >> >> works fine. I guess that's because I restart the ReportServer service.
> >> >> Yesterday, I also missed some email, I tried to delete the
> >> >> subscription
> >> >> and
> >> >> create a new one, if fixed as well.
> >> >> So my suggestion to Greg is, to restart service and recreate the
> >> >> subscription.
> >> >> So far they are working fine. Hope not missing again...
> >> >>
> >> >> "Daniel Reib [MSFT]" wrote:
> >> >>
> >> >> > If all the emails are being dropped then RS is doing everything it
> >> >> > can
> >> >> > to
> >> >> > send the emails. We use the CDO objects to generate and send the
> >> >> > emails.
> >> >> > If it reports no errors then from RS everything is working. The
> >> >> > most
> >> >> > reliable way to set up RS to forward emails is to have it drop the
> >> >> > .eml
> >> >> > files to the local SMTP pickup directory and have this relay the
> >> >> > emails
> >> >> > to
> >> >> > your SMTP server. Using the local smtp server gives you much better
> >> >> > retry
> >> >> > logic as well as more configuration options.
> >> >> >
> >> >> > --
> >> >> > -Daniel
> >> >> > This posting is provided "AS IS" with no warranties, and confers no
> >> >> > rights.
> >> >> >
> >> >> >
> >> >> > "Tony" <Tony@.discussions.microsoft.com> wrote in message
> >> >> > news:8741570E-4313-4624-970E-57A047057244@.microsoft.com...
> >> >> > >I got the same issue, yesterday email working fine, but this
> >> >> > >morning
> >> >> > >not
> >> >> > > working, and I try your option. Email message file .eml does
> >> >> > > droped
> >> >> > > in the
> >> >> > > SMTPServerPickupFolder. But does it mean the issue of SMTP server
> >> >> > > passing?
> >> >> > > Is
> >> >> > > it possible that RS fail to trigger SMTP to sending email? Thanks.
> >> >> > >
> >> >> > > Tony
> >> >> > >
> >> >> > > "Daniel Reib [MSFT]" wrote:
> >> >> > >
> >> >> > >> You can try having the emails dropped to a folder instead. If
> >> >> > >> all
> >> >> > >> the
> >> >> > >> emails are getting correctly dropped then your SMTP server is
> >> >> > >> having
> >> >> > >> an
> >> >> > >> issue passing them on and you should look into that.
> >> >> > >>
> >> >> > >> To get the emails to drop to a folder, set the
> >> >> > >> SMTPPickupDirectory
> >> >> > >> element
> >> >> > >> in the RSReportServer.config file to a folder location, then set
> >> >> > >> the
> >> >> > >> SendUsing element to 1. All emails will then be placed in that
> >> >> > >> folder.
> >> >> > >> If
> >> >> > >> some are not being placed then the log files should state why
> >> >> > >> they
> >> >> > >> are
> >> >> > >> not.
> >> >> > >>
> >> >> > >> --
> >> >> > >> -Daniel
> >> >> > >> This posting is provided "AS IS" with no warranties, and confers
> >> >> > >> no
> >> >> > >> rights.
> >> >> > >>
> >> >> > >>
> >> >> > >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in
> >> >> > >> message
> >> >> > >> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
> >> >> > >> > Hi,
> >> >> > >> >
> >> >> > >> > We recently have troubleshoots with email subscriptions. Some
> >> >> > >> > reports
> >> >> > >> > are
> >> >> > >> > correctly sent, others aren't... There are no error messages in
> >> >> > >> > the
> >> >> > >> > "state"
> >> >> > >> > column of all those subscriptions, "mail sent to.." is
> >> >> > >> > displayed.
> >> >> > >> >
> >> >> > >> > Everything seems correct in the log files, RS tells us that all
> >> >> > >> > messages
> >> >> > >> > have been sent correctly. The only "strange" info line is this
> >> >> > >> > one
> >> >> > >> > before
> >> >> > >> > report execution for subscription:
> >> >> > >> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i
> >> >> > >> > INFO:
> >> >> > >> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd,
> >> >> > >> > reportPath:
> >> >> > >> > /<report_path>, userName: <domain>\<user> not found in the
> >> >> > >> > database.
> >> >> > >> >
> >> >> > >> > Another user in the newsgroup is facing the same problem:
> >> >> > >> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
> >> >> > >> >
> >> >> > >> > For information, we are using Reporting Services SP2 on Windows
> >> >> > >> > Server
> >> >> > >> > 2K3.
> >> >> > >> >
> >> >> > >> > Thanks in advance.
> >> >> > >> > Grégory.
> >> >> > >> >
> >> >> > >>
> >> >> > >>
> >> >> > >>
> >> >> >
> >> >> >
> >> >> >
> >>
> >>
> >>
>
>|||I just had the same problem with Symantec Mail Security which is
included in the Corporate Edition of Symanted Antivirus. This may be
what's causing your error. If you right click on the email message in
Outlook -> Options and see something similar in the Internet headers,
it a clear indication that Symantec Mail Security could be to blame.
Microsoft Mail Internet Headers Version 2.0
X-SMSMSE-SCL: 2
I resolved the issue by adding my domain to sender whitelist within the
Symantec Antivirus web configuration tool under Real Time Blacklists
and Whitelists.
Larry|||Tony,
The log says that message has been sent. But I receive nothing, I checked
"Junk Mails" and nothing was there too.
The fact is that the Antivirus is on the RS Server, not on the client
desktop. So, I think that I'm encountering a Server problem more than a
client one.
Best Regards,
Grégory.
"Tony" wrote:
> Greg,
> When you say "not sent", what does log say about it? Is it still not error,
> but the receipt not receive the email? I was using outlook to receive email,
> email went to "Junk E-Mail" box, I though I did not receive them at all.
> (Daniel, sorry about my last message, in fact it was working fine.). If you
> are include the report as "Web Archive" and you turn on your outlook "Junk
> Email" setting, the email will go to "Junk E-Mail". But with Excel format, it
> will go to your inbox, or rountie by some rules you define.
> I guess, with "Web Archive" the email message will contain some script
> outlook "thinks" un-save to it. So I guess, when you run AntiVirus, for
> protection, the email either filter to Junk mail box by outlook, or filter by
> the mail server, thought?
> Tony
>
> "Daniel Reib [MSFT]" wrote:
> > I have not heard of this kind of issue before. Is this when the emails are
> > being dropped to a folder or sent directly to the SMTP server? Does it
> > repro if you leave the antivirus on and don't scan the RSTempFiles
> > directory? Are you excluding the ASP.Net temporary files directory?
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> > news:86506F24-662F-4038-A6E5-D9C8766B1E31@.microsoft.com...
> > > Hi,
> > >
> > > I've got some news!
> > > I've made some test with the AntiVirus protection on the server... and
> > > guess
> > > what... when I stop the antivirus, subscriptions on a particular
> > > problematic
> > > report are working ... when I start it again, mails aren't sent.
> > >
> > > We are actually using Symantec AntiVirus 10, this version has been
> > > installed
> > > mid-december. Is there any incomatibility beetween this progam and
> > > Reporting
> > > Services ?
> > >
> > > Once again Daniel, thanks for your support.
> > >
> > > Grégory.
> > >
> > > "Daniel Reib [MSFT]" wrote:
> > >
> > >> Yes, this is the most reliable way to send emails from RS. To do this
> > >> you
> > >> must have the local SMTP server installed. You then configure the SMTP
> > >> server to relay the messages, then configure RS to drop the eml files to
> > >> the
> > >> SMTP server's pickup directory.
> > >>
> > >> --
> > >> -Daniel
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > >> rights.
> > >>
> > >>
> > >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> > >> news:73376ECB-98E3-423F-AB38-BB267DB862A9@.microsoft.com...
> > >> > Hi Tony and Daniel,
> > >> >
> > >> > Well... After restarting ReportServer service, everything worked well
> > >> > during
> > >> > 2 days... and this morning the problem was back again!
> > >> >
> > >> > I've tried to change SMTP Pickup Directory and SendUsing options, but
> > >> > since
> > >> > we have to restart service for changes to take effect , it's always
> > >> > working
> > >> > after that and eml files are created in the directory.
> > >> > Mails are correctly sent too when i restart ReportServer, so the best
> > >> > way
> > >> > would be to test the first option during some days.. But since the
> > >> > server
> > >> > is
> > >> > our production server, it's impossible.
> > >> >
> > >> > Is there a way to have messages dropped in the directory and sent via
> > >> > SMTP
> > >> > in the meantime.
> > >> >
> > >> > Thanx in advance.
> > >> > Grégory.
> > >> >
> > >> > "Tony" wrote:
> > >> >
> > >> >> Daniel, thanks for the answer. I see.
> > >> >> This time I took off SMTP pickup directory and also took off
> > >> >> SendUse=1.
> > >> >> It
> > >> >> works fine. I guess that's because I restart the ReportServer service.
> > >> >> Yesterday, I also missed some email, I tried to delete the
> > >> >> subscription
> > >> >> and
> > >> >> create a new one, if fixed as well.
> > >> >> So my suggestion to Greg is, to restart service and recreate the
> > >> >> subscription.
> > >> >> So far they are working fine. Hope not missing again...
> > >> >>
> > >> >> "Daniel Reib [MSFT]" wrote:
> > >> >>
> > >> >> > If all the emails are being dropped then RS is doing everything it
> > >> >> > can
> > >> >> > to
> > >> >> > send the emails. We use the CDO objects to generate and send the
> > >> >> > emails.
> > >> >> > If it reports no errors then from RS everything is working. The
> > >> >> > most
> > >> >> > reliable way to set up RS to forward emails is to have it drop the
> > >> >> > .eml
> > >> >> > files to the local SMTP pickup directory and have this relay the
> > >> >> > emails
> > >> >> > to
> > >> >> > your SMTP server. Using the local smtp server gives you much better
> > >> >> > retry
> > >> >> > logic as well as more configuration options.
> > >> >> >
> > >> >> > --
> > >> >> > -Daniel
> > >> >> > This posting is provided "AS IS" with no warranties, and confers no
> > >> >> > rights.
> > >> >> >
> > >> >> >
> > >> >> > "Tony" <Tony@.discussions.microsoft.com> wrote in message
> > >> >> > news:8741570E-4313-4624-970E-57A047057244@.microsoft.com...
> > >> >> > >I got the same issue, yesterday email working fine, but this
> > >> >> > >morning
> > >> >> > >not
> > >> >> > > working, and I try your option. Email message file .eml does
> > >> >> > > droped
> > >> >> > > in the
> > >> >> > > SMTPServerPickupFolder. But does it mean the issue of SMTP server
> > >> >> > > passing?
> > >> >> > > Is
> > >> >> > > it possible that RS fail to trigger SMTP to sending email? Thanks.
> > >> >> > >
> > >> >> > > Tony
> > >> >> > >
> > >> >> > > "Daniel Reib [MSFT]" wrote:
> > >> >> > >
> > >> >> > >> You can try having the emails dropped to a folder instead. If
> > >> >> > >> all
> > >> >> > >> the
> > >> >> > >> emails are getting correctly dropped then your SMTP server is
> > >> >> > >> having
> > >> >> > >> an
> > >> >> > >> issue passing them on and you should look into that.
> > >> >> > >>
> > >> >> > >> To get the emails to drop to a folder, set the
> > >> >> > >> SMTPPickupDirectory
> > >> >> > >> element
> > >> >> > >> in the RSReportServer.config file to a folder location, then set
> > >> >> > >> the
> > >> >> > >> SendUsing element to 1. All emails will then be placed in that
> > >> >> > >> folder.
> > >> >> > >> If
> > >> >> > >> some are not being placed then the log files should state why
> > >> >> > >> they
> > >> >> > >> are
> > >> >> > >> not.
> > >> >> > >>
> > >> >> > >> --
> > >> >> > >> -Daniel
> > >> >> > >> This posting is provided "AS IS" with no warranties, and confers
> > >> >> > >> no
> > >> >> > >> rights.
> > >> >> > >>
> > >> >> > >>
> > >> >> > >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in
> > >> >> > >> message
> > >> >> > >> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
> > >> >> > >> > Hi,
> > >> >> > >> >
> > >> >> > >> > We recently have troubleshoots with email subscriptions. Some
> > >> >> > >> > reports
> > >> >> > >> > are
> > >> >> > >> > correctly sent, others aren't... There are no error messages in
> > >> >> > >> > the
> > >> >> > >> > "state"
> > >> >> > >> > column of all those subscriptions, "mail sent to.." is
> > >> >> > >> > displayed.
> > >> >> > >> >
> > >> >> > >> > Everything seems correct in the log files, RS tells us that all
> > >> >> > >> > messages
> > >> >> > >> > have been sent correctly. The only "strange" info line is this
> > >> >> > >> > one
> > >> >> > >> > before
> > >> >> > >> > report execution for subscription:
> > >> >> > >> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i
> > >> >> > >> > INFO:
> > >> >> > >> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd,
> > >> >> > >> > reportPath:
> > >> >> > >> > /<report_path>, userName: <domain>\<user> not found in the
> > >> >> > >> > database.
> > >> >> > >> >
> > >> >> > >> > Another user in the newsgroup is facing the same problem:
> > >> >> > >> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
> > >> >> > >> >
> > >> >> > >> > For information, we are using Reporting Services SP2 on Windows
> > >> >> > >> > Server
> > >> >> > >> > 2K3.
> > >> >> > >> >
> > >> >> > >> > Thanks in advance.
> > >> >> > >> > Grégory.
> > >> >> > >> >
> > >> >> > >>
> > >> >> > >>
> > >> >> > >>
> > >> >> >
> > >> >> >
> > >> >> >
> > >>
> > >>
> > >>
> >
> >
> >|||Daniel,
It's when email are sent directly to the SMTP Server.
For the moment, we have disabled Symantec auto-protect on the server. We
will investigate further in a couple of days. I'll let you know which
directories have to be excluded from the scan.
Grégory.
"Daniel Reib [MSFT]" wrote:
> I have not heard of this kind of issue before. Is this when the emails are
> being dropped to a folder or sent directly to the SMTP server? Does it
> repro if you leave the antivirus on and don't scan the RSTempFiles
> directory? Are you excluding the ASP.Net temporary files directory?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> news:86506F24-662F-4038-A6E5-D9C8766B1E31@.microsoft.com...
> > Hi,
> >
> > I've got some news!
> > I've made some test with the AntiVirus protection on the server... and
> > guess
> > what... when I stop the antivirus, subscriptions on a particular
> > problematic
> > report are working ... when I start it again, mails aren't sent.
> >
> > We are actually using Symantec AntiVirus 10, this version has been
> > installed
> > mid-december. Is there any incomatibility beetween this progam and
> > Reporting
> > Services ?
> >
> > Once again Daniel, thanks for your support.
> >
> > Grégory.
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> Yes, this is the most reliable way to send emails from RS. To do this
> >> you
> >> must have the local SMTP server installed. You then configure the SMTP
> >> server to relay the messages, then configure RS to drop the eml files to
> >> the
> >> SMTP server's pickup directory.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> >> news:73376ECB-98E3-423F-AB38-BB267DB862A9@.microsoft.com...
> >> > Hi Tony and Daniel,
> >> >
> >> > Well... After restarting ReportServer service, everything worked well
> >> > during
> >> > 2 days... and this morning the problem was back again!
> >> >
> >> > I've tried to change SMTP Pickup Directory and SendUsing options, but
> >> > since
> >> > we have to restart service for changes to take effect , it's always
> >> > working
> >> > after that and eml files are created in the directory.
> >> > Mails are correctly sent too when i restart ReportServer, so the best
> >> > way
> >> > would be to test the first option during some days.. But since the
> >> > server
> >> > is
> >> > our production server, it's impossible.
> >> >
> >> > Is there a way to have messages dropped in the directory and sent via
> >> > SMTP
> >> > in the meantime.
> >> >
> >> > Thanx in advance.
> >> > Grégory.
> >> >
> >> > "Tony" wrote:
> >> >
> >> >> Daniel, thanks for the answer. I see.
> >> >> This time I took off SMTP pickup directory and also took off
> >> >> SendUse=1.
> >> >> It
> >> >> works fine. I guess that's because I restart the ReportServer service.
> >> >> Yesterday, I also missed some email, I tried to delete the
> >> >> subscription
> >> >> and
> >> >> create a new one, if fixed as well.
> >> >> So my suggestion to Greg is, to restart service and recreate the
> >> >> subscription.
> >> >> So far they are working fine. Hope not missing again...
> >> >>
> >> >> "Daniel Reib [MSFT]" wrote:
> >> >>
> >> >> > If all the emails are being dropped then RS is doing everything it
> >> >> > can
> >> >> > to
> >> >> > send the emails. We use the CDO objects to generate and send the
> >> >> > emails.
> >> >> > If it reports no errors then from RS everything is working. The
> >> >> > most
> >> >> > reliable way to set up RS to forward emails is to have it drop the
> >> >> > .eml
> >> >> > files to the local SMTP pickup directory and have this relay the
> >> >> > emails
> >> >> > to
> >> >> > your SMTP server. Using the local smtp server gives you much better
> >> >> > retry
> >> >> > logic as well as more configuration options.
> >> >> >
> >> >> > --
> >> >> > -Daniel
> >> >> > This posting is provided "AS IS" with no warranties, and confers no
> >> >> > rights.
> >> >> >
> >> >> >
> >> >> > "Tony" <Tony@.discussions.microsoft.com> wrote in message
> >> >> > news:8741570E-4313-4624-970E-57A047057244@.microsoft.com...
> >> >> > >I got the same issue, yesterday email working fine, but this
> >> >> > >morning
> >> >> > >not
> >> >> > > working, and I try your option. Email message file .eml does
> >> >> > > droped
> >> >> > > in the
> >> >> > > SMTPServerPickupFolder. But does it mean the issue of SMTP server
> >> >> > > passing?
> >> >> > > Is
> >> >> > > it possible that RS fail to trigger SMTP to sending email? Thanks.
> >> >> > >
> >> >> > > Tony
> >> >> > >
> >> >> > > "Daniel Reib [MSFT]" wrote:
> >> >> > >
> >> >> > >> You can try having the emails dropped to a folder instead. If
> >> >> > >> all
> >> >> > >> the
> >> >> > >> emails are getting correctly dropped then your SMTP server is
> >> >> > >> having
> >> >> > >> an
> >> >> > >> issue passing them on and you should look into that.
> >> >> > >>
> >> >> > >> To get the emails to drop to a folder, set the
> >> >> > >> SMTPPickupDirectory
> >> >> > >> element
> >> >> > >> in the RSReportServer.config file to a folder location, then set
> >> >> > >> the
> >> >> > >> SendUsing element to 1. All emails will then be placed in that
> >> >> > >> folder.
> >> >> > >> If
> >> >> > >> some are not being placed then the log files should state why
> >> >> > >> they
> >> >> > >> are
> >> >> > >> not.
> >> >> > >>
> >> >> > >> --
> >> >> > >> -Daniel
> >> >> > >> This posting is provided "AS IS" with no warranties, and confers
> >> >> > >> no
> >> >> > >> rights.
> >> >> > >>
> >> >> > >>
> >> >> > >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in
> >> >> > >> message
> >> >> > >> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
> >> >> > >> > Hi,
> >> >> > >> >
> >> >> > >> > We recently have troubleshoots with email subscriptions. Some
> >> >> > >> > reports
> >> >> > >> > are
> >> >> > >> > correctly sent, others aren't... There are no error messages in
> >> >> > >> > the
> >> >> > >> > "state"
> >> >> > >> > column of all those subscriptions, "mail sent to.." is
> >> >> > >> > displayed.
> >> >> > >> >
> >> >> > >> > Everything seems correct in the log files, RS tells us that all
> >> >> > >> > messages
> >> >> > >> > have been sent correctly. The only "strange" info line is this
> >> >> > >> > one
> >> >> > >> > before
> >> >> > >> > report execution for subscription:
> >> >> > >> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i
> >> >> > >> > INFO:
> >> >> > >> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd,
> >> >> > >> > reportPath:
> >> >> > >> > /<report_path>, userName: <domain>\<user> not found in the
> >> >> > >> > database.
> >> >> > >> >
> >> >> > >> > Another user in the newsgroup is facing the same problem:
> >> >> > >> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
> >> >> > >> >
> >> >> > >> > For information, we are using Reporting Services SP2 on Windows
> >> >> > >> > Server
> >> >> > >> > 2K3.
> >> >> > >> >
> >> >> > >> > Thanks in advance.
> >> >> > >> > Grégory.
> >> >> > >> >
> >> >> > >>
> >> >> > >>
> >> >> > >>
> >> >> >
> >> >> >
> >> >> >
> >>
> >>
> >>
>
>|||We finally found the solution. In the "Configure" menu, we have disabled
"Internet E-mail Auto-protect".
Now everything works fine.
Grégory.
"Daniel Reib [MSFT]" wrote:
> I have not heard of this kind of issue before. Is this when the emails are
> being dropped to a folder or sent directly to the SMTP server? Does it
> repro if you leave the antivirus on and don't scan the RSTempFiles
> directory? Are you excluding the ASP.Net temporary files directory?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> news:86506F24-662F-4038-A6E5-D9C8766B1E31@.microsoft.com...
> > Hi,
> >
> > I've got some news!
> > I've made some test with the AntiVirus protection on the server... and
> > guess
> > what... when I stop the antivirus, subscriptions on a particular
> > problematic
> > report are working ... when I start it again, mails aren't sent.
> >
> > We are actually using Symantec AntiVirus 10, this version has been
> > installed
> > mid-december. Is there any incomatibility beetween this progam and
> > Reporting
> > Services ?
> >
> > Once again Daniel, thanks for your support.
> >
> > Grégory.
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> Yes, this is the most reliable way to send emails from RS. To do this
> >> you
> >> must have the local SMTP server installed. You then configure the SMTP
> >> server to relay the messages, then configure RS to drop the eml files to
> >> the
> >> SMTP server's pickup directory.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> >> news:73376ECB-98E3-423F-AB38-BB267DB862A9@.microsoft.com...
> >> > Hi Tony and Daniel,
> >> >
> >> > Well... After restarting ReportServer service, everything worked well
> >> > during
> >> > 2 days... and this morning the problem was back again!
> >> >
> >> > I've tried to change SMTP Pickup Directory and SendUsing options, but
> >> > since
> >> > we have to restart service for changes to take effect , it's always
> >> > working
> >> > after that and eml files are created in the directory.
> >> > Mails are correctly sent too when i restart ReportServer, so the best
> >> > way
> >> > would be to test the first option during some days.. But since the
> >> > server
> >> > is
> >> > our production server, it's impossible.
> >> >
> >> > Is there a way to have messages dropped in the directory and sent via
> >> > SMTP
> >> > in the meantime.
> >> >
> >> > Thanx in advance.
> >> > Grégory.
> >> >
> >> > "Tony" wrote:
> >> >
> >> >> Daniel, thanks for the answer. I see.
> >> >> This time I took off SMTP pickup directory and also took off
> >> >> SendUse=1.
> >> >> It
> >> >> works fine. I guess that's because I restart the ReportServer service.
> >> >> Yesterday, I also missed some email, I tried to delete the
> >> >> subscription
> >> >> and
> >> >> create a new one, if fixed as well.
> >> >> So my suggestion to Greg is, to restart service and recreate the
> >> >> subscription.
> >> >> So far they are working fine. Hope not missing again...
> >> >>
> >> >> "Daniel Reib [MSFT]" wrote:
> >> >>
> >> >> > If all the emails are being dropped then RS is doing everything it
> >> >> > can
> >> >> > to
> >> >> > send the emails. We use the CDO objects to generate and send the
> >> >> > emails.
> >> >> > If it reports no errors then from RS everything is working. The
> >> >> > most
> >> >> > reliable way to set up RS to forward emails is to have it drop the
> >> >> > .eml
> >> >> > files to the local SMTP pickup directory and have this relay the
> >> >> > emails
> >> >> > to
> >> >> > your SMTP server. Using the local smtp server gives you much better
> >> >> > retry
> >> >> > logic as well as more configuration options.
> >> >> >
> >> >> > --
> >> >> > -Daniel
> >> >> > This posting is provided "AS IS" with no warranties, and confers no
> >> >> > rights.
> >> >> >
> >> >> >
> >> >> > "Tony" <Tony@.discussions.microsoft.com> wrote in message
> >> >> > news:8741570E-4313-4624-970E-57A047057244@.microsoft.com...
> >> >> > >I got the same issue, yesterday email working fine, but this
> >> >> > >morning
> >> >> > >not
> >> >> > > working, and I try your option. Email message file .eml does
> >> >> > > droped
> >> >> > > in the
> >> >> > > SMTPServerPickupFolder. But does it mean the issue of SMTP server
> >> >> > > passing?
> >> >> > > Is
> >> >> > > it possible that RS fail to trigger SMTP to sending email? Thanks.
> >> >> > >
> >> >> > > Tony
> >> >> > >
> >> >> > > "Daniel Reib [MSFT]" wrote:
> >> >> > >
> >> >> > >> You can try having the emails dropped to a folder instead. If
> >> >> > >> all
> >> >> > >> the
> >> >> > >> emails are getting correctly dropped then your SMTP server is
> >> >> > >> having
> >> >> > >> an
> >> >> > >> issue passing them on and you should look into that.
> >> >> > >>
> >> >> > >> To get the emails to drop to a folder, set the
> >> >> > >> SMTPPickupDirectory
> >> >> > >> element
> >> >> > >> in the RSReportServer.config file to a folder location, then set
> >> >> > >> the
> >> >> > >> SendUsing element to 1. All emails will then be placed in that
> >> >> > >> folder.
> >> >> > >> If
> >> >> > >> some are not being placed then the log files should state why
> >> >> > >> they
> >> >> > >> are
> >> >> > >> not.
> >> >> > >>
> >> >> > >> --
> >> >> > >> -Daniel
> >> >> > >> This posting is provided "AS IS" with no warranties, and confers
> >> >> > >> no
> >> >> > >> rights.
> >> >> > >>
> >> >> > >>
> >> >> > >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in
> >> >> > >> message
> >> >> > >> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
> >> >> > >> > Hi,
> >> >> > >> >
> >> >> > >> > We recently have troubleshoots with email subscriptions. Some
> >> >> > >> > reports
> >> >> > >> > are
> >> >> > >> > correctly sent, others aren't... There are no error messages in
> >> >> > >> > the
> >> >> > >> > "state"
> >> >> > >> > column of all those subscriptions, "mail sent to.." is
> >> >> > >> > displayed.
> >> >> > >> >
> >> >> > >> > Everything seems correct in the log files, RS tells us that all
> >> >> > >> > messages
> >> >> > >> > have been sent correctly. The only "strange" info line is this
> >> >> > >> > one
> >> >> > >> > before
> >> >> > >> > report execution for subscription:
> >> >> > >> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i
> >> >> > >> > INFO:
> >> >> > >> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd,
> >> >> > >> > reportPath:
> >> >> > >> > /<report_path>, userName: <domain>\<user> not found in the
> >> >> > >> > database.
> >> >> > >> >
> >> >> > >> > Another user in the newsgroup is facing the same problem:
> >> >> > >> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
> >> >> > >> >
> >> >> > >> > For information, we are using Reporting Services SP2 on Windows
> >> >> > >> > Server
> >> >> > >> > 2K3.
> >> >> > >> >
> >> >> > >> > Thanks in advance.
> >> >> > >> > Grégory.
> >> >> > >> >
> >> >> > >>
> >> >> > >>
> >> >> > >>
> >> >> >
> >> >> >
> >> >> >
> >>
> >>
> >>
>
>|||Do you know how to fix this problem?
My logfile has the following messages:
ReportingServicesService!crypto!d58!3/30/2006-12:08:54:: i INFO:
Initializing crypto as user: ACTRANSIT\AdminSQLDW
ReportingServicesService!crypto!d58!3/30/2006-12:08:54:: i INFO: Exporting
public key
ReportingServicesService!crypto!d58!3/30/2006-12:08:54:: i INFO: Performing
sku validation
ReportingServicesService!crypto!d58!3/30/2006-12:08:54:: i INFO: Importing
existing encryption key
ReportingServicesService!library!d58!3/30/2006-12:08:54:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException:
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content and then restart the service.
Check the documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException:
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content and then restart the service.
Check the documentation for more information. -->
System.Runtime.InteropServices.COMException (0x80090005): Bad Data.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ImportSymmetricKey(Byte[] pSymKeyBlob)
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --
ReportingServicesService!library!d58!3/30/2006-12:08:54:: Exception caught
while starting service. Error:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException:
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content and then restart the service.
Check the documentation for more information. -->
System.Runtime.InteropServices.COMException (0x80090005): Bad Data.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ImportSymmetricKey(Byte[] pSymKeyBlob)
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!d58!3/30/2006-12:08:54:: Attempting to
start service again...
Thanks!
Henry
"Greg - NEOS" wrote:
> Hi,
> We recently have troubleshoots with email subscriptions. Some reports are
> correctly sent, others aren't... There are no error messages in the "state"
> column of all those subscriptions, "mail sent to.." is displayed.
> Everything seems correct in the log files, RS tells us that all messages
> have been sent correctly. The only "strange" info line is this one before
> report execution for subscription:
> ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i INFO:
> LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd, reportPath:
> /<report_path>, userName: <domain>\<user> not found in the database.
> Another user in the newsgroup is facing the same problem:
> http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
> For information, we are using Reporting Services SP2 on Windows Server 2K3.
> Thanks in advance.
> Grégory.
>