Subscriptions Acting Erradicately -- sql server reporting services

sql server reporting services : Subscriptions Acting Erradicately

Joel Rumerman
7/28/2004 4:37:21 PM

Some of my RS users have noted that they are not receiving their regular
subscription report emails. I looked at the RS log file and it stated that
the emails were being sent. I then talked to my operations staff and they
stated they had no record of the emails coming across the email server
(exchange 2k3) or the email gateway (a symantec system).

To test the problem I created a subscription that fired off a report once
every two minutes, but I didn't receive the first of the reports until the
second one also completed. The first report was compleded at 3:08, the
second at 3:10 and both were sent (by their sent fields in the email) at
3:10. It was almost like the first one was being queued and the second one
was pushing it through.

I've checked the SQL Jobs and the subscription job(s) look to be okay with
correct last executed times and correct next scheduled execution time. The
RS log looks like the emails are okay too. No CDO errors.

The setup we have is one server with RS and the another acting as the db
catalog. The problems have been apparent for about two weeks now. We had
some problems with our RS server at one point, but we thought it was back up
and stable.

I was wondering if anybody had any recommendations on how to further
troubleshoot this and also does this sound like something reapplying SP1
might fix?

Thanks for any insights!

Daniel Reib [MSFT]
8/3/2004 10:29:03 AM

The most reliable way to setup subscriptions is to use a local SMTP server
to relay the messages. In the RSReportServer.config file set the
SMTPPickupDirectory element to your local pickup directory. Then set the
SendUsing element to 1. This will cause emails to be dropped to the local
drive. You would then need to configure your local SMTP directory to relay
the messages. This configuration has proven to be the most reliable.

--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Joel Rumerman
8/3/2004 10:47:38 AM

Daniel,

Thanks for the advice. After opening an MSDN tech support ticket, my IT
folks figured out it was the email gateway that was blocking some of the
messages!!

Let's see, 30hrs wasted + 1MSDN ticket = $1500, my annoyance at my IT team:
priceless.

Thx, Joel

[quoted text, click to view]

ian.proffer NO[at]SPAM gmail.com
8/4/2004 12:51:43 PM

Hi Daniel,

I too have been having periodic problems with subscriptions delivered
via the local SMTP pickup directory. While some work reliably, any
new subscriptions I've created recently are failing to be delivered.
When I review the \Badmail *.bdr messages, they all say this:

Unable to deliver this message because the follow error was
encountered: "Error is processing file in pickup directory.".

The specific error code was 0xC00402CE.

If I drop a message directly into the \Pickup folder, the same error
occurs. Any idea why this is happening?

Thanks for your help,

-- Ian

[quoted text, click to view]

Daniel Reib [MSFT]
8/4/2004 1:42:47 PM

I am not familiar with this error. It seems to have something to do with
your local SMTP. A quick search on google turned up a lot of hits for this
error. Perhaps you can start there?

--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

ian.proffer NO[at]SPAM gmail.com
8/6/2004 2:32:35 PM

Hi Daniel,

Don't you mean search MSN instead of Google? ;)

The error is caused by having in invalid email address in the From
line of the email, which corresponds to the <From> portion of the
RSReportServer.config file. However, according to SRS BOL:

This value is required. It should be a valid e-mail account, but it
does not have to be.

So what gives? If I use a valid Exchange mailbox it works. If I
change the From value to a friendly name it fails, even if I append
the valid email address with HTML tags like this:

<From>My Report Server<email@my.org></From>

Why the discrepancy?

-- Ian

[quoted text, click to view]

Daniel Reib [MSFT]
8/6/2004 3:36:56 PM

The documentation doesn't seem very clear on this, then intent was that it
must be an email address but that address does not need be an existing email
address (Not sure why you would do this unless you are trying to spam, which
would not be good)

--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Jerome BERTHAUD
8/7/2004 5:31:04 PM

Hello,

I know that some smtp servers doesn't accept invalid email adress in mime
content. I think it's why we should always provide a well formed adress.

Jerome Berthaud (MCSD)
http://www.winsight.fr

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn