question

FarhanJamil-5363 avatar image
0 Votes"
FarhanJamil-5363 asked Joyzhao-MSFT commented

email not been send to all in the ssrs report subscription

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@abc.com,farhan-jamil@abc.com,farhan_jamil@xyz.com

So the one that is being picked when the report is about to be published is farhan.jamil@abc.com,farhan-jamil@abc.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-transact-sqlsql-server-reporting-services
· 3
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.

Where do you get the email addresses from? Is it from a query? I would run the query to see what is returned.

0 Votes 0 ·

Hi Russel

No it is not coming from a sql query. The email address is copied manually from the list of email address. And yes all emails are entered correctly and they are all genuine company email

Regards
Farhan Jamil

0 Votes 0 ·

Has your issue been resolved?

0 Votes 0 ·

1 Answer

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

Hi @FarhanJamil-5363
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


02.png (26.2 KiB)
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.