There has to be a better way to do this – if you know of one, kindly post a comment.
Until then, here is a technique that will allow you to ensure that if a stored procedure that BizTalk is calling is unable to complete its work successfully, you can rollback the work and be notified of that fact within your orchestration.
<om:Element Type="Catch" OID="e7590870…" ParentLink="Scope_Catch" …> <om:Property Name="ExceptionName" Value="soapex" /> <om:Property Name="ExceptionType" Value="Microsoft.XLANGs.Core.XlangSoapException" /> <om:Property Name="IsFaultMessage" Value="False" /> <om:Property Name="ReportToAnalyst" Value="True" /> <om:Property Name="Name" Value="CatchException_2" /> <om:Property Name="Signal" Value="True" /> </om:Element>
After you’ve gone to these lengths, it is always worth considering whether you want to have your orchestration call a component so you are a little closer to the action. But, if you have need of the adapter, this should work out.
Remember Me
a@href@title, strike
Scott Colestock lives, writes, and works as an independent consultant in the Twin Cities (Minneapolis, Minnesota) area.