We are doing a stree test of about 200 records. A Biztalk orch. starts by based on an SQL receive port that polls this databsae. We run an SQL update command to set the status flag on all 200 records, and away they go.
All 200 orchestrations run, but at the end of the process, we find that our SQL receive port is disabled
The receive location \”SQL://xxx/yyy\” is shutting down. Details:\”The error threshold has been exceeded. The receive location is shutting down.\”.
Looking back in the log find this 4 warning messages that say this (but no error messages):
The adapter \”SQL\” raised an error message. Details \”New transaction cannot enlist in the specified transaction coordinator. \”.
Are there are any large volume or throughput issues with DTC?