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: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?