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.".
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.