email not been send to all in the ssrs report subscription

Farhan Jamil 421 Reputation points
2021-05-26T09:46:56.46+00:00

HI there

I have a very bizarre situation in production environment of my work space where not all of the emails are been sent when the ssrs report is been published to go out.
For example i have three emails(not real emails) like farhan.jamil@jaswant .com,farhan-jamil@jaswant .com,farhan_jamil@xyz .com

So the one that is being picked when the report is about to be published is farhan.jamil@jaswant .com,farhan-jamil@jaswant .com,farhan_jamil
So two people on the list recieved the email but the third person didnt receive it as somehow the report is not picking full email address.

I have

  1. Checked the logs to see if their was any error on the published report causing a problem
  2. I have also check the report subscription and can confirm all email is genuine (as it is company email)and it is correctly entered.

To be precise the company report that is creating a problem has about 12 people on the email list and 7 received it whereas 5 didn't receive it

Not sure what exactly it is

Can anyone guide me here to get to the root cause of the problem

Any questions please let me know

Regards
Farhan Jamil

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,860 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,596 questions
{count} vote

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,571 Reputation points
    2021-05-27T02:23:14.633+00:00

    Hi @Farhan Jamil
    What is the result returned after the subscription is executed?Such as:
    100064-02.png

    Please also attach the log file corresponding to the subscription delivery. In SQL Server Reporting Services 2017: C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles
    What email are you using? Could you take a screenshot of the relevant subscription settings interface?
    What version of the report server are you using?
    Best Regards,
    Joy

    0 comments No comments