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

Sanjiv Menon 0 Reputation points
2024-06-20T08:36:05.15+00:00

Team,

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.

thanks

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
    2024-06-20T12:26:23.3066667+00:00

    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