The 'A request to send data to the computer running IIS has failed' Exception
Hi guys,
When I do the RDA process, this weird problem comes out. I don't think there is any problem with the connction between the SQLce Server Agent and SQL Server agent.
Everytime I run the RDA process, it looks like it is waiting for the time out of the connection. And If I cancel this process and rerun it, it works out and seems there is no problem at all. The conclusion is that, if i start the RDA, 20 or 30 minutes after a previous RDA process, this exception is definitely coming out.
BTW, the HResult in the exception is -2147012867.
Help......
Cheers,
Justin
Hi Justin,
Seems like as if the previous RDA did not release something?
Could there be something happening at the Publisher at this time?
Is this problem consistently reproducable? That is, every time you run RDA, it takes a long time and then after you cancel it and rerun, it passes?
Also the other thing you mentioned about starting RDA after 20-30 minutes after a prev RDA, did the previous RDA succeed? or was it cancelled?
Also, try to increase the timeout value on the IIS default web site and see if that helps. Open up IIS Manager-->R-Click on Web Sites-->Properties-->ConnectionTimeout
Hi Mahesh,
Sorry for the delay.
Is this problem consistently reproducable? That is, every time you run RDA, it takes a long time and then after you cancel it and rerun, it passes?
Yes. if I run it for the first time, it will take a long time and seems like waiting for the time out. And if I cancel it before time out and rerun it, it passes.
Also the other thing you mentioned about starting RDA after 20-30 minutes after a prev RDA, did the previous RDA succeed? or was it cancelled?Yes. It was successful.This problem is still bothering me...
Did you try the higher timeout on the IIS?
Also try increasing the timout value in the RDA script if there is a means of doing it?
Is there so much data that it takes so long (20-30 minutes before timing out)?