Exception : Microsoft.ServiceModel.Channels.Common.AdapterException:

Sanjiv Menon 0 Reputation points


We are getting the below error while migrating our application from SQL 2016 to SQL 2022,

Our current setup is running on SQL 2022, integrated to the BizTalk 2020.

Error message:


Exception : Microsoft.ServiceModel.Channels.Common.AdapterException: The ResultSet returned as part of the Typed Stored Procedure or Typed Polling invocation did not match the metadata available. If this Stored Procedure or Polling Statement can return a variable number of result sets, consider using the un-typed Stored Procedure or un-typed Polling operation instead.    at Microsoft.Adapters.Sql.GenericReaderWriter.GetResultSetMetadataForTypedSPPolling(StoredProcedureMetadata procedureMetadata, ReaderMetadata readerMetadata, Int32& possibleSchemaTableIndex)    at Microsoft.Adapters.Sql.GenericReaderWriter.OnWriteBodyContents(XmlDictionaryWriter writer)    at System.ServiceModel.Channels.BodyWriterMessage.OnWriteBodyContents(XmlDictionaryWriter writer)    at Microsoft.Adapters.AdapterUtilities.AdapterMessage.OnWriteBodyContents(XmlDictionaryWriter writer)    at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfMarshaller.CreateBizTalkMessageStream(Message wcfMessage, IAdapterConfigInboundMessageMarshalling config, TLConfig t


we have tried restarting the Host instances and that did not solve this issue.


Sanjiv R

Microsoft BizTalk Server
Microsoft BizTalk Server
A family of Microsoft server products that support large-scale implementation management of enterprise application integration processes.
361 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,337 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Sanjiv Menon 0 Reputation points

    The Issue was resolved by changing the below flag to false on the BT Environment.

    AmbientTransaction flag (BT Binding Type) to False

    0 comments No comments