I have a long ETL SSIS process, one step is to call a web service. The web service is slow for it process each person's record.
Sometimes the job time out after run a couple of hours. with the below message:
Status: CreateDriverDirectionsReport.ProcessRoutePath: [DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation
Status: CreateDriverDirectionsReport: Connection failure
Status: Handled exception in TDDReportJobThread.Execute: Connection failure: Level = B
I have done all kinds of troubleshoot, like both webserver and the db server are online at the time it failed, and there is no error in SQL log, and web log, and I added RAM to the computer. but still cannot figure out.
The same job runs fine on another server with exactly copy of databases.
Today if failed again, then I restarted then after 8 hours(it is supposed to run that long, it is calling web service to process each route and stops, we only do this once a while.) , it succeeded.
Does the IIS recycle time which is default 29 hours could affect the web service to interupt?
- This topic was modified 1 month, 2 weeks ago by sqlfriend.