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

Question

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

Answer 1

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

AmbientTransaction flag (BT Binding Type) to False