1

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

user1104946
  • 680
  • 1
  • 9
  • 30
  • 1
    You probably see some errors in the event log? – Riri Jan 31 '12 at 18:43
  • 1
    Yes this is error in event log......below this i have one warning mesg. The adapter "SQL" raised an error message. Details "HRESULT="0x80004005" Description="The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction – user1104946 Jan 31 '12 at 19:56
  • 1
    This error is due to large file.....Anyone knows what settings do i need to change to poll large data from the database – user1104946 Jan 31 '12 at 21:21
  • It is possible also that your SQL query is timing out. Possibly look at increasing the timeout on all affected SQL and BizTalk servers, or seeing if you can improve the performance of your query. – StuartLC Feb 01 '12 at 06:13
  • You also want to take a look at the SQL adapter best practices below. Its not really designed for larger datasets. http://msdn.microsoft.com/en-us/library/cc507804(v=bts.10).aspx – Bryan Corazza Feb 12 '12 at 20:40

1 Answers1

0

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.

Jay
  • 13,803
  • 4
  • 42
  • 69