Data Driven Subscription by email, no error but no email

Question

Hi all, I have a situation where I have set up a DDS for email delivery, the sql data source behind is pretty complex but all works fine in testing etc.

I set the DDS up to run and it appears to run fine, I get the "x processed of x, 0 errors" on the subscription page of the report and the logs seem to reflect that there were no errors also.

This issue is the emails are just not getting to me, I've double checked I've got the address correct etc.

Where do I start looking to see what's happened? I'm pretty sure it's going to be the client's mail server not playing nicely but I just need a few ideas so I can point their IT team off in the right direction

Cheers

Dave

Answer 1

The following are possible: If your attached email is too large, then your exchange server (for example) will block it. Same, if there are lots of email addresses in the 'to' or 'cc' field etc.

try setting up a tiny report which just shows the datetime. This will help you to know if you receive the 'latest' report, or an earlier version
Try that, and then set up the subscription. Try sending an email to the recipient, and see if it gets through.
Try it end-to-end with a tiny report, and see if it works. Or try a different From address, if it is being blocked. just try sending an email from the From account, to the To account - in case it is marked as Spam etc.

Hope that helps.

If it gets through, then it will help you to determine if the issue is at the sql end, or the mail end.

Answer 2

0

Can you(they) successfully send an email using TSQL?
Does their server have other email alerting working as expected?
Do they have email profiles set up with a default one as public?
What are the results in

       USE [msdb]
       GO

       SELECT    *
       FROM  [dbo].[sysmail_log] AS sl     
       ORDER BY [sl].[log_date] desc

Just some ideas.

answered Apr 23 '12 at 12:31 PM

Fatherjack ♦♦
38.8k ● 55 ● 69 ● 104

(comments are locked)

Answer 3

0

Thanks for the input guys, turns out the ssrs service was set up to use an email account as the sender that didn't exist. The mail server didn't like this as sent them off into the electronic abyss instead of the intended recipient

Thanks

Dave

answered Apr 26 '12 at 11:05 AM

Dave Morrison
302 ● 1 ● 2 ● 3

nice! Thanks for the update.

Apr 26 '12 at 11:13 AM Fatherjack ♦♦

(comments are locked)

Data Driven Subscription by email, no error but no email

Follow this question

Related Questions