all groups > sql server notification services > february 2007 >
You're in the

sql server notification services

group:

Way to increase Distributor timeout?


Way to increase Distributor timeout? BigDave
2/3/2007 1:30:54 PM
sql server notification services:
Hello all,

We have built a custom content formatter which creates a report via
Reporting Services.

Unfortunately, for some subscribers, the report can take a minute or
more to generate.

We have found that whenever the content formatter takes more than 15
seconds, the NS Distributor returns the error "The operation has timed
out" (Event ID 6033).

We've researched all of the NS timeouts, and can't find a setting for
the Distributor to allow a custom content formatter to run for longer
than about 15 seconds.

Does anyone know of a way to increase this timeout? It would be most
appreciated. Thanks,
Dave
Re: Way to increase Distributor timeout? Joe Webb
2/6/2007 6:46:32 AM
[quoted text, click to view]

I've had similar issues in custom content providers that I've created. In
my case, however, it wasn't RS that was timing out but a command object in
C#. I used the CommandTimeout property of the command object to lengthen
the time allowed. It worked for me.

HTH....

Joe



--
Joe Webb
SQL Server MVP
http://www.sqlns.com



Re: Way to increase Distributor timeout? BigDave
2/6/2007 1:06:02 PM
Joe,

I truly appreciate your response.

Sure enough, although I thought it was NS firing the timeout, it was
indeed the content formatter web service client-proxy that was timing
out. We increased the client-proxy timeout, and this solved it.

Thanks again,
Dave
Re: Way to increase Distributor timeout? Joe Webb
2/7/2007 1:12:39 PM
[quoted text, click to view]


Great! Glad you got it resolved, Dave.

Cheers!

Joe


--
Joe Webb
SQL Server MVP
http://www.sqlns.com



AddThis Social Bookmark Button