The error threshold has been exceeded. The receive location is shutting down

3.1k views Asked by At

I am doing polling using SQL adapter......For small records polling is succesful......but for large recorde i am getting following error..

The receive location "RcvSqlDataLoc" with URL "" is shutting down. Details:"The error threshold has been exceeded. The receive location is shutting down.".

1

There are 1 answers

0
Jay On BEST ANSWER

Try checking your SQL server management console for deadlocks while the long running transaction is executing. If you don't need a transaction there's an option in the configuration of the port for automatically wrapping the session in a transaction. You might try turning that off.