BIZTALK ORCHESTRATION WIERDNESS

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › BIZTALK ORCHESTRATION WIERDNESS

Viewing 1 reply thread
  • Author
    Posts
    • January 30, 2007 at 5:45 AM #17482
      community-content

        Hi,

         I have created a Biztalk orchestration that receives an XML and transforms it into the appropriate format before it calls the SQL adapter and sends the message to the sproc and gets a response. Now the wierd part is when I execute it, the sproc is called multiple times. And it inserts multiple lines of the same record. Is there some setting I need to turn off to prevent it from calling multiple times? If so where can I find it? I'm new at this and have not had a lot of time to work on Biztalk. Your help will be much appreciated. Thank you.
         

      • January 30, 2007 at 10:21 AM #17483
        community-content

          Have you inspected the output message of the transform? Maybe the repeated inserts are actually repeated by your transform?

          It is also possible that you had submitted messages retrying until they finally succeeded and this caused the sproc to be called multiple times..

          -wa
           

           

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