RS2005 email delivery problem

We started using RS 2005 web farm a month ago. Since then we have
problem delivering reports trough email. When using shared
subscription with several reports some reports are sent and some are
not.
Errors displayed by various parts of system are below:
Subscription Last Status text:
The delivery extension for this subscription could not be loaded.
Windows Application event log:
Report Server (MSSQLSERVER) cannot load the Report Server
DocumentLibrary
extension.
At first we thought that problem is our postfix mail server so we
transferred from directly sending mail to sending mail to local SMTP
which then sends mail to postfix. One problem was a connection
timeout. It seems that connection with mail server is opened at the
same time the shared schedule execution has started. With SMTP service
standard time-out of 10 minutes or so reports lasting more than that
have no chance to be sent. So my solution was installing local SMTP
Service from windows components setup and setting its timeout to
timeout needed by our reports. But the problem didn't go away. I was
hoping that unsent mail will be in badmail SMTP folder or that I will
find it in drop folder as unsent mail. Strange thing is that all the
folders are empty. There is no bad mail. My SRS can't send mail to my
local SMTP! When shared subscription with several reports is fired
connection to local SMTP is created. I can see it in Current Sessions.
If subscription is shared I suppose that reports, belonging to shared
subscription, are being executed one by one and sent to SMTP server as
they are finished. Time out of my SMTP is 180 minutes. All the reports
executed one by one take about 30 minutes so I guess now time out is
not a problem. I think that there are 2 possible reasons:
1. Opened connection to SMTP somehow brakes between two reports being
sent and can't be reestablished
2. SRS successfully execute some reports and send them to SMTP and
when next report is finished and have to be sent, SRS can't load DLL
needed to send mail.
Every suggestion will be appreciated!Any ideas?
ijeremi...@.gmail.com wrote:
> We started using RS 2005 web farm a month ago. Since then we have
> problem delivering reports trough email. When using shared
> subscription with several reports some reports are sent and some are
> not.
> Errors displayed by various parts of system are below:
> Subscription Last Status text:
> The delivery extension for this subscription could not be loaded.
> Windows Application event log:
> Report Server (MSSQLSERVER) cannot load the Report Server
> DocumentLibrary
> extension.
> At first we thought that problem is our postfix mail server so we
> transferred from directly sending mail to sending mail to local SMTP
> which then sends mail to postfix. One problem was a connection
> timeout. It seems that connection with mail server is opened at the
> same time the shared schedule execution has started. With SMTP service
> standard time-out of 10 minutes or so reports lasting more than that
> have no chance to be sent. So my solution was installing local SMTP
> Service from windows components setup and setting its timeout to
> timeout needed by our reports. But the problem didn't go away. I was
> hoping that unsent mail will be in badmail SMTP folder or that I will
> find it in drop folder as unsent mail. Strange thing is that all the
> folders are empty. There is no bad mail. My SRS can't send mail to my
> local SMTP! When shared subscription with several reports is fired
> connection to local SMTP is created. I can see it in Current Sessions.
> If subscription is shared I suppose that reports, belonging to shared
> subscription, are being executed one by one and sent to SMTP server as
> they are finished. Time out of my SMTP is 180 minutes. All the reports
> executed one by one take about 30 minutes so I guess now time out is
> not a problem. I think that there are 2 possible reasons:
> 1. Opened connection to SMTP somehow brakes between two reports being
> sent and can't be reestablished
> 2. SRS successfully execute some reports and send them to SMTP and
> when next report is finished and have to be sent, SRS can't load DLL
> needed to send mail.
> Every suggestion will be appreciated!|||If no-one responds here I suggest trying the web based forums. That is where
MS people hang out and the other RS MVP.
http://forums.microsoft.com/msdn/showforum.aspx?forumid=82&siteid=1
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<ijeremicyu@.gmail.com> wrote in message
news:1184243847.242957.320910@.w3g2000hsg.googlegroups.com...
> Any ideas?
> ijeremi...@.gmail.com wrote:
>> We started using RS 2005 web farm a month ago. Since then we have
>> problem delivering reports trough email. When using shared
>> subscription with several reports some reports are sent and some are
>> not.
>> Errors displayed by various parts of system are below:
>> Subscription Last Status text:
>> The delivery extension for this subscription could not be loaded.
>> Windows Application event log:
>> Report Server (MSSQLSERVER) cannot load the Report Server
>> DocumentLibrary
>> extension.
>> At first we thought that problem is our postfix mail server so we
>> transferred from directly sending mail to sending mail to local SMTP
>> which then sends mail to postfix. One problem was a connection
>> timeout. It seems that connection with mail server is opened at the
>> same time the shared schedule execution has started. With SMTP service
>> standard time-out of 10 minutes or so reports lasting more than that
>> have no chance to be sent. So my solution was installing local SMTP
>> Service from windows components setup and setting its timeout to
>> timeout needed by our reports. But the problem didn't go away. I was
>> hoping that unsent mail will be in badmail SMTP folder or that I will
>> find it in drop folder as unsent mail. Strange thing is that all the
>> folders are empty. There is no bad mail. My SRS can't send mail to my
>> local SMTP! When shared subscription with several reports is fired
>> connection to local SMTP is created. I can see it in Current Sessions.
>> If subscription is shared I suppose that reports, belonging to shared
>> subscription, are being executed one by one and sent to SMTP server as
>> they are finished. Time out of my SMTP is 180 minutes. All the reports
>> executed one by one take about 30 minutes so I guess now time out is
>> not a problem. I think that there are 2 possible reasons:
>> 1. Opened connection to SMTP somehow brakes between two reports being
>> sent and can't be reestablished
>> 2. SRS successfully execute some reports and send them to SMTP and
>> when next report is finished and have to be sent, SRS can't load DLL
>> needed to send mail.
>> Every suggestion will be appreciated!
>sql