Exception:
A message sent to adapter “WCF-SQL” on send port <Send Port Name > with URI “mssql:<Database Server > is suspended. Error details: Microsoft.ServiceModel.Channels.Common.UnsupportedOperationException: The action “<BtsActionMapping xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:xsd=”http://www.w3.org/2001/XMLSchema” > <Operation Name=”operation_1″ Action=”TypedProcedure/dbo/<stored Procedure Name>” / > </BtsActionMapping >” was not understood.
Solution:
This issue is mainly occur when we setup SOAP Action Header on Send port as below when there is no orchestration involve in the solution:
<BtsActionMapping xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:xsd=”http://www.w3.org/2001/XMLSchema” > <Operation Name=”operation_1″ Action=”TypedProcedure/dbo/<stored Procedure Name>” / > </BtsActionMapping >
This setup comes by default in Binding file when consume stored procedure or Insert/select/delete table from Add generated items while developing the solution in visual studio.
Where there is only Receive& send port in BizTalk solution then for WCF-SQL adapter on send port we need to just specify TypedProcedure or Procedure/dbo/<stored Procedure Name> in SOAP Action Header As below
And in case of Orchestration involve in the solution for WCF-SQL Send port then configuration is defined as below:
BizTalk World 
Leave a comment