Prev: Help: No mapping between account names and security IDs was done
Next: Installation Issue of reporting services 2005
From: Greg - NEOS on 5 Jan 2006 05:36
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.

From: Daniel Reib [MSFT] on 5 Jan 2006 19:56
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(a)discussions.microsoft.com> wrote in message
news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697(a)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.
>


From: Greg - NEOS on 6 Jan 2006 04:28
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(a)discussions.microsoft.com> wrote in message
> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697(a)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.
> >
>
>
>
From: Tony on 6 Jan 2006 11:50
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(a)discussions.microsoft.com> wrote in message
> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697(a)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.
> >
>
>
>
From: Daniel Reib [MSFT] on 6 Jan 2006 12:46
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(a)discussions.microsoft.com> wrote in message
news:8741570E-4313-4624-970E-57A047057244(a)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(a)discussions.microsoft.com> wrote in message
>> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697(a)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.
>> >
>>
>>
>>


 |  Next  |  Last
Pages: 1 2 3 4
Prev: Help: No mapping between account names and security IDs was done
Next: Installation Issue of reporting services 2005