Microsoft BizTalk Server
A family of Microsoft server products that support large-scale implementation management of enterprise application integration processes.
358 questions
WCF SQL Composite Operation Send Port throwing Transmission Failure Error
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 57.99999999999999%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETH%3C/text%3E%3C/svg%3E)
Tahir Hemani
1
Reputation point
I'm using the CompositeOperation WCF-SQL Send port, and it works well. Normally, I would send roughly 1000 records to a stored process that does upserts, and everything worked perfectly. I just got a file containing around 5000 entries and received a Transmission failure message. Is there a limit to the number of records we may transmit over the compositeoperation port?
Since it generates one huge xml and adds all the records as an xml node, I'm wondering whether sending the enormous xml to SQL from BizTalk is efficient.
I have the following settings on the SendPort:
Close Timeout: 00:01:00
Open Timeout: 00:01:00
Receive Timeout: Infinite
Send Timeout: Infinite
Error details:
System.Data.SqlClient.SqlException (0x80131904): The Microsoft Distributed
Transaction Coordinator (MS DTC) has cancelled the distributed transaction.