x

Data Driven Subscription by email, no error but no email

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
more ▼

asked Apr 23, 2012 at 11:29 AM in Default

Dave Morrison gravatar image

Dave Morrison
472 2 3 4

Thanks Jonathan and Jen.

Jen the reports are being sent to single recipients and the content of the reports are minimal.

I'll give the other bits a go though from both of you, thanks for the input guys :)
Apr 23, 2012 at 12:44 PM Dave Morrison
(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

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.
more ▼

answered Apr 23, 2012 at 12:42 PM

jenstirrup gravatar image

jenstirrup
101

(comments are locked)
10|1200 characters needed characters left

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.
more ▼

answered Apr 23, 2012 at 12:31 PM

Fatherjack gravatar image

Fatherjack ♦♦
42.4k 75 78 108

(comments are locked)
10|1200 characters needed characters left

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
more ▼

answered Apr 26, 2012 at 11:05 AM

Dave Morrison gravatar image

Dave Morrison
472 2 3 4

nice! Thanks for the update.
Apr 26, 2012 at 11:13 AM Fatherjack ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x581

asked: Apr 23, 2012 at 11:29 AM

Seen: 916 times

Last Updated: Apr 26, 2012 at 11:13 AM