Error details: Microsoft.ServiceModel.Channels.Common.UnsupportedOperationException: The action was not understood.

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&#8221; xmlns:xsd=”http://www.w3.org/2001/XMLSchema&#8221; > <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&#8221; xmlns:xsd=”http://www.w3.org/2001/XMLSchema&#8221; > <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:

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s