Stored procedure returning multiple Success responses

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Stored procedure returning multiple Success responses

Viewing 0 reply threads
  • Author
    Posts
    • #22705

      Hi All,

                I have a situation where I am inserting message in DB using Sql Adaptor and Stored procedure. 

      I have input Message Like mentioned below which has reapeating loop 

      <?xml version=”1.0″ encoding=”utf-8″
      ?>
      – <ns0:InventoryDetailRequest xmlns:ns0=”http://ABC.Edi.Inventory.Detail“>
        <ns0:sp_Insert_Inventory_Detail ctDistProductNo=”X94254“ ctFileNameToCompare=”188192002009-06-15{BECA8EC9-A057-4100-A007-73068FFA32DA}“ ctQuantityCommitted=”0“
      ctQuantityInTransit
      =”0“ ctQuantityOnHand=”0“
      ctQuantityOnOrder
      =”16“ ctQuantityReturned=”0“ ctSKU=”SKAG2001I“
      />
        <ns0:sp_Insert_Inventory_Detail ctDistProductNo=”N97544“ ctFileNameToCompare=”188192002009-06-15{BECA8EC9-A057-4100-A007-73068FFA32DA}“ ctQuantityCommitted=”0“
      ctQuantityInTransit
      =”0“ ctQuantityOnHand=”16“
      ctQuantityOnOrder
      =”0“ ctQuantityReturned=”0“ ctSKU=”SKNS2001I“
      />
        <ns0:sp_Insert_Inventory_Detail ctDistProductNo=”P13832“ ctFileNameToCompare=”188192002009-06-15{BECA8EC9-A057-4100-A007-73068FFA32DA}“ ctQuantityCommitted=”0“
      ctQuantityInTransit
      =”0“ ctQuantityOnHand=”6“
      ctQuantityOnOrder
      =”0“ ctQuantityReturned=”0“ ctSKU=”SKPV2001I“
      />
        </ns0:InventoryDetailRequest>

      As u can see InventoryDetailRequest node is repeated so Sql Adaptor is returning 3 success responses for each loop element hence Sql Adaptor is Suspending message at response side.

      Does anybody came across this type of scenario?

       

Viewing 0 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.