BizTalk Gurus
Forums » BizTalk Server » BizTalk 2006 R2 » Stored procedure returning multiple Success responses

Stored procedure returning multiple Success responses

rated by 0 users
Not Answered This post has 0 verified answers | 0 Replies | 0 Followers

posted on Mon, Jun 22 2009 9:54 AM

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?

 

 Quick Reply
Page 1 of 1 (1 items) | RSS