Large volume test – DTC issues

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Large volume test – DTC issues

Viewing 1 reply thread
  • Author
    Posts
    • November 11, 2005 at 8:14 PM #12283
      community-content

        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?

        Thanks!

        Neal Walters
        http://Biztalk-Training.com

      • November 11, 2005 at 11:24 PM #12282
        community-content

          Todd Uhl (a.k.a. SQL Adapter guy) suggested:

          I don’t know of any thresh hold with DTC. If there was, it wouldn’t be 200 records

          Might try changing the query to grab maybe the top 50 to chunk it up, but I bet that’s not the issue

          Probably has DTC issues anyway….bring in the network folks to sniff packets or something

      • Author
        Posts
      Viewing 1 reply thread
      • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.