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

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