question

SupriyaGupta-1649 avatar image
0 Votes"
SupriyaGupta-1649 asked Joyzhao-MSFT commented

Data-driven Subscription doesnt send out 1 out of 9 emails but subscription history shows its successfull

HI

The issue is i have created data driven subscription. The status says " Done: 9 processed of 9 total; 0 errors."
It is supposed to deliver email to 9 people but only 8 are receiving the email. The person also searched in the mailbox with subject of email notification thinking that the email might be getting delivered to some other folder but of no success.

I have already gone through the below thread and followed few steps mentioned there:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b4176895-5ef3-488d-8c68-57ef287a784c/datadriven-subscription-doesnt-send-out-an-email-but-job-history-shows-its-successfull?forum=sqlreportingservices

  1. I checked the ReportServerSErvice Log in location (default location: %programfiles%\Microsoft SQL Server\<SQL Server Instance>\Reporting Services\LogFiles as mentioned in above thread. But no errors encountered there.

  2. Also checked the below tables, but no records found there . The tables are empty.

  3. Checked the table ExecutionLogStorage and ExecutionLog2 , for given reportID and there are 9 records created at that given time and all have status of rsSuccess.


Need urgent help on how to where the issue lies.
Thanks

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT commented

Hi @SupriyaGupta-1649 ,
1. First of all, please make sure that the address that did not receive the mail is correct.
2. The Reporting Services e-mail delivery extension considers "sent successfully" to be "I handed it off to some SMTP forwarder". What happens to the e-mail after that is outside the scope of RS. You need to investigate within the e- mail system.

In short, if your email address is correct, according to your description, the problem is not in the RS. You need to find the reason on the SMTP. I suggest you consult SMTP experts and check the SMTP server.
Hope this helps.
Best Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Joyzhao-MSFT
Thanks for your quick response. The email address has been verified multiple times. Like you said the issue is not in RS and if i need to check SMTP, will it be my organisation's SMPT? or is it something internally used by Report server?

Thanks

0 Votes 0 ·

Check the log information in the SMTP server. The specific process requires consultation with experts in this area. To be sure, RS has completed the task of delivering to SMTP during the subscription process, and there is no need to troubleshoot from the perspective of RS.

0 Votes 0 ·